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.exe>Slim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/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.exe>Slim/Web/HTTP.pm line 1103) frame 11: Slim::Web::HTTP::generateHTTPResponse (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 926) frame 12: Slim::Web::HTTP::processURL (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 736) frame 13: Slim::Web::HTTP::processHTTP (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 139) frame 14: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 123) frame 15: Slim::Networking::IO::Select::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 16: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 17: Slim::Networking::IO::Select::loop (slimserver.pl line 693) frame 18: main::idle (slimserver.pl line 57) frame 19: PerlSvc::Startup (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>PerlSvc.pm line 95) frame 20: PerlSvc::_startup (slimserver.pl line 0) frame 21: (eval) (slimserver.pl line 0) -- 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