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
