Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
erland;646161 Wrote: I think it now should be fixed in the Custom Browse 2.11.3389 version which I just released. I've already released a new Custom Scan version which had a similar issue in the Tags and Dynamic Tags based menus, not sure if that affects you. All seems fine now. I think I would have tripped over the Tags problem as well at some point. Thanks very much indeed. You are a star. -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
I think it now should be fixed in the Custom Browse 2.11.3389 version
which I just released. I've already released a new Custom Scan version
which had a similar issue in the Tags and Dynamic Tags based menus,
not sure if that affects you.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89159
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
I'm hoping that the following log entry may help pin down where this error is coming from (I'm not quite sure why the text has been interpreted with smileys) : [11-08-01 13:15:28.8182] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db prepare failed: near Pathetique: syntax error [for Statement select customscan_track_attributes.extravalue,customscan_track_attributes.value, substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1), ifnull(customscan_track_attributes.valuetype,'mixedtagWORKARTIST') from customscan_track_attributes join multilibrary_track on customscan_track_attributes.track=multilibrary_track.track and multilibrary_track.library=2 join customscan_track_attributes as attr1 on customscan_track_attributes.track=attr1.track and attr1.module='mixedtag' and attr1.attr='COMPOSER' and attr1.extravalue='2324' join customscan_track_attributes as attr2 on customscan_track_attributes.track=attr2.track and attr2.module='mixedtag' and attr2.attr='WORK' and attr2.extravalue='Piano Sonata No.08 in Cmi Op.13 \'Pathetique\'' where customscan_track_attributes.module='mixedtag' and customscan_track_attributes.attr='WORKARTIST' group by customscan_track_attributes.extravalue order by ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value) asc] [11-08-01 13:15:28.8193] Slim::Schema::Storage::throw_exception (119) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeDBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 71) frame 3: (eval) (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 68) frame 4: Plugins::CustomBrowse::MenuHandler::SQLHandler::_execute (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLHandler.pm line 53) frame 5: Plugins::CustomBrowse::MenuHandler::SQLHandler::getData (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLMenu.pm line 166) frame 6: Plugins::CustomBrowse::MenuHandler::SQLMenu::getData (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/SQLMenu.pm line 110) frame 7: Plugins::CustomBrowse::MenuHandler::SQLMenu::prepareMenu (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/BaseMenuHandler.pm line 297) frame 8: Plugins::CustomBrowse::MenuHandler::BaseMenuHandler::_getMenuItems (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/MenuHandler/BaseMenuHandler.pm line 825) frame 9: Plugins::CustomBrowse::MenuHandler::BaseMenuHandler::getPageItemsForContext (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/CustomBrowse/Plugin.pm line 2183) frame 10: Plugins::CustomBrowse::Plugin::handleWebList (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Web/HTTP.pm line 1103) frame 11: Slim::Web::HTTP::generateHTTPResponse (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Web/HTTP.pm line 926) frame 12: Slim::Web::HTTP::processURL (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Web/HTTP.pm line 736) frame 13: Slim::Web::HTTP::processHTTP (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm line 139) frame 14: (eval) (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm line 123) frame 15: Slim::Networking::IO::Select::__ANON__ (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm line 184) frame 16: (eval) (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm line 184) frame 17: Slim::Networking::IO::Select::loop (slimserver.pl line 693) frame 18: main::idle
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
Erland, I have done more research (I should have done before - sorry - Works by Composer is my most used menu). This problem occurs for many (probably all) CB menus when I get down to a WORK that contains a single quote. SB Menus are fine playing songs with the single quote in the title (which is a concatenation of WORK and MOVEMENT) I surmise this is related to the handling of Custom Scan and non-standard tags in the extravalue attribute. I'm using your recommended Classical tags (plus a couple of my own), so I have WORK and MOVEMENT in my custom tags. -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
Some more research to try to pin the problem down. I tried to search using an Albums by Artist menu where the Artist (O'Conor) has a single quote in the name. This uses the MixedTag scanning module It had a similar error, as below. The menu follows. Error: Running: select customscan_track_attributes.value,customscan_track_attributes.value, substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1) from customscan_track_attributes join multilibrary_track on customscan_track_attributes.track=multilibrary_track.track and multilibrary_track.library=2 join customscan_track_attributes as attr1 on customscan_track_attributes.track=attr1.track and attr1.module='mixedtag' and attr1.attr='ARTIST' and attr1.value='O\'Conor, J' where customscan_track_attributes.module='mixedtag' and customscan_track_attributes.attr='ALBUM' group by customscan_track_attributes.value order by ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value) asc got error: near Conor: syntax errorRunning: select distinct customscan_track_attributes.value,customscan_track_attributes.value from customscan_track_attributes where module='mixedtag' and attr='ARTIST' and value='O\'Conor, J' got error: near Conor: syntax error The Menu is: ?xml version=1.0 encoding=utf-8? custombrowse template idcustomscan_multiplecustomtagsalbums/id parameter type=text id=menunamevalueAlbums by Artist/value/parameter parameter type=text id=menugroupvalueClassical Music/value/parameter parameter type=text id=menuordervalue50/value/parameter parameter type=text id=datasourcevaluemixedtag/value/parameter parameter type=text id=limituppertagsvalue1/value/parameter parameter type=text id=rolesvalue1/valuevalue3/valuevalue5/valuevalue6/value/parameter parameter type=text id=showartistwithalbumvalue0/value/parameter parameter type=text id=customtag1valueARTIST/value/parameter parameter type=text id=customsorttag1/parameter parameter type=text id=customtag1artistsortvalue0/value/parameter parameter type=text id=customtag1numbersortvalue0/value/parameter parameter type=text id=customtag2valueALBUM/value/parameter parameter type=text id=level2namevalueAlbums/value/parameter parameter type=text id=customsorttag2/parameter parameter type=text id=customtag2artistsortvalue0/value/parameter parameter type=text id=customtag2numbersortvalue0/value/parameter parameter type=text id=customtag3/parameter parameter type=text id=level3name/parameter parameter type=text id=customsorttag3/parameter parameter type=text id=customtag3artistsortvalue0/value/parameter parameter type=text id=customtag3numbersortvalue0/value/parameter parameter type=text id=customtag4/parameter parameter type=text id=level4name/parameter parameter type=text id=customsorttag4/parameter parameter type=text id=customtag4artistsortvalue0/value/parameter parameter type=text id=customtag4numbersortvalue0/value/parameter parameter type=text id=customtag5/parameter parameter type=text id=level5name/parameter parameter type=text id=customsorttag5/parameter parameter type=text id=customtag5artistsortvalue0/value/parameter parameter type=text id=customtag5numbersortvalue0/value/parameter parameter type=text id=playalltracksvalue1/value/parameter parameter type=text id=libraryvalue2/value/parameter parameter type=text id=activelibraryvalue0/value/parameter parameter type=text id=includedclients/parameter parameter type=text id=excludedclients/parameter parameter type=text id=includedlibraries/parameter parameter type=text id=excludedlibraries/parameter /template /custombrowse -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
I guess you haven't selected to customize the SQL/XML yourself for this
meny ?
If you haven't, make sure you have the latest Custom Browse version and
try if the problem is solved if you click the Refresh link at the
bottom of a Custom Browse page in the web interface.
If that didn't help, try to goto SBS Settings/Advanced/Custom
Browse/Manage menus, open the specific menu, make sure its settings are
ok and if they are save the menu again. It could be that some values
have been stored in 7.5 in the configuration files and re-saving the
menu like this should make sure they are stored with '' instead of \'.
If none of this helps, let me know again and I'll take a look if I've
missed something in the code. The intention is that it should use \' in
MySQL and '' in SQLite.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89159
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
erland;645187 Wrote: I guess you haven't selected to customize the SQL/XML yourself for this meny ? If you haven't, make sure you have the latest Custom Browse version and try if the problem is solved if you click the Refresh link at the bottom of a Custom Browse page in the web interface. If that didn't help, try to goto SBS Settings/Advanced/Custom Browse/Manage menus, open the specific menu, make sure its settings are ok and if they are save the menu again. It could be that some values have been stored in 7.5 in the configuration files and re-saving the menu like this should make sure they are stored with '' instead of \'. If none of this helps, let me know again and I'll take a look if I've missed something in the code. The intention is that it should use \' in MySQL and '' in SQLite. I am running CB 2.11.3376 (as shown in the log). I've also done a refresh just in case and stopped/started the server. I haven't customised this menu's XML but I have added a tag to the list of tags in the standard pre-defined form (ie. WORKARTIST - the main artists for this 'work'). I still get the same error, showing the string surrounded by \' rather than '' If there is somewhere else I can look in the server config I'll be happy to have a look. I didn't clear out all the prefs/confs before taking the leap into the dark that is 7.6, and maybe that was a mistake. I note that the release took most people by surprise. All a bit odd. -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
PasTim;645194 Wrote:
I am running CB 2.11.3376 (as shown in the log). I've also done a
refresh just in case and stopped/started the server. I haven't
customised this menu's XML but I have added a tag to the list of tags
in the standard pre-defined form (ie. WORKARTIST - the main artists for
this 'work').
I still get the same error, showing the string surrounded by \' rather
than ''
Could you post or send me the *.cb.values.xml file which corresponds to
this menu ?
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89159
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
The xml is below (for some reason attachments with type xml are rejected). I could have changed the extension, but it's not too big. For what I could make of the error it's the 'work' attribute parsing that's failed. I did try and look at some of the Perl parsing files, but I don't know Perl and got a bit bogged down. ?xml version=1.0 encoding=utf-8? custombrowse template idcustomscan_mixedtags.xml/id parameter type=text id=menunamevalueWorks by Composer/value/parameter parameter type=text id=menugroupvalueClassical Music/value/parameter parameter type=text id=menuordervalue50/value/parameter parameter type=text id=limituppertagsvalue1/value/parameter parameter type=text id=customtag1valueCOMPOSER/value/parameter parameter type=text id=customtagtype1value/value/parameter parameter type=text id=customsorttag1/parameter parameter type=text id=customtag1artistsortvalue0/value/parameter parameter type=text id=customtag1numbersortvalue0/value/parameter parameter type=text id=customtag2valueWORK/value/parameter parameter type=text id=customtagtype2value/value/parameter parameter type=text id=level2namevalueWorks/value/parameter parameter type=text id=customsorttag2/parameter parameter type=text id=customtag2artistsortvalue0/value/parameter parameter type=text id=customtag2numbersortvalue0/value/parameter parameter type=text id=customtag3valueWORKARTIST/value/parameter parameter type=text id=customtagtype3value/value/parameter parameter type=text id=level3namevalueWork Artist/value/parameter parameter type=text id=customsorttag3/parameter parameter type=text id=customtag3artistsortvalue0/value/parameter parameter type=text id=customtag3numbersortvalue0/value/parameter parameter type=text id=customtag4/parameter parameter type=text id=customtagtype4value/value/parameter parameter type=text id=level4name/parameter parameter type=text id=customsorttag4/parameter parameter type=text id=customtag4artistsortvalue0/value/parameter parameter type=text id=customtag4numbersortvalue0/value/parameter parameter type=text id=customtag5/parameter parameter type=text id=customtagtype5value/value/parameter parameter type=text id=level5name/parameter parameter type=text id=customsorttag5/parameter parameter type=text id=customtag5artistsortvalue0/value/parameter parameter type=text id=customtag5numbersortvalue0/value/parameter parameter type=text id=customtracktag/parameter parameter type=text id=playalltracksvalue1/value/parameter parameter type=text id=libraryvalue2/value/parameter parameter type=text id=activelibraryvalue0/value/parameter parameter type=text id=includedclients/parameter parameter type=text id=excludedclients/parameter parameter type=text id=includedlibraries/parameter parameter type=text id=excludedlibraries/parameter /template /custombrowse -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] CB - Works by Composer problem in 7.6
In 7.6 I have encountered a Custom Browse problem with the classical set-up. When selecting using the Works by Composer menu, any Work with a single quote ' in the title causes an SQL error, as below. I don't yet know if other menus have a similar problem. This worked fine in 7.5.n. I assume it's an SQLite issue. The error message is as follow: No matching songs, albums or artists were found Refresh(Custom Browse 2.11.3376) Error: Running: select customscan_track_attributes.extravalue,customscan_track_attributes.value, substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1), ifnull(customscan_track_attributes.valuetype,'mixedtagWORKARTIST') from customscan_track_attributes join multilibrary_track on customscan_track_attributes.track=multilibrary_track.track and multilibrary_track.library=2 join customscan_track_attributes as attr1 on customscan_track_attributes.track=attr1.track and attr1.module='mixedtag' and attr1.attr='COMPOSER' and attr1.extravalue='2324' join customscan_track_attributes as attr2 on customscan_track_attributes.track=attr2.track and attr2.module='mixedtag' and attr2.attr='WORK' and attr2.extravalue='Symphony No.3 in Eb Op.55 \'Eroica\'' where customscan_track_attributes.module='mixedtag' and customscan_track_attributes.attr='WORKARTIST' group by customscan_track_attributes.extravalue order by ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value) asc got error: near Eroica: syntax errorRunning: select distinct customscan_track_attributes.extravalue,customscan_track_attributes.value,substr(customscan_track_attributes.value,1,1),ifnull(customscan_track_attributes.valuetype,'mixedtagWORK') from customscan_track_attributes where module='mixedtag' and attr='WORK' and extravalue='Symphony No.3 in Eb Op.55 \'Eroica\'' got error: near Eroica: syntax error -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CB - Works by Composer problem in 7.6
PasTim;644755 Wrote: This worked fine in 7.5.n. I assume it's an SQLite issue. Having done a bit of research I find that it seems that the backward slash \ used in MySQL to escape from an embedded single quote ' needs to be replaced by a single quote ' in SQLite. However, I don't know how or where to fix this in Custom Browse/Scan. -- PasTim PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=89159 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
