I tried to play a dynamic playlist, that is provided via SQL Playlist, but it
failed to play the mix.
Home > Dynamic Playlists > Recently added > Not rated > Not rated songs
recently added
[I imagine a similar fault exists in other SQL Playlists]
Looking at the log:
[09:22:22.0977] Slim::Schema::Storage::throw_exception (122) Error: DBI
Exception: DBD::SQLite::db prepare failed: near "DAY": syntax error [for
Statement "select tracks.url from tracks where tracks.audio=1 and exists
(select 1 from track_statistics t1 where tracks.url=t1.url and
t1.added>UNIX_TIMESTAMP(DATE_ADD(NOW(),INTERVAL -30 DAY))) and not exists
(select 1 from track_statistics t2 where tracks.url=t2.url and t2.rating>0) and
not exists (select 1 from dynamicplaylist_history d where tracks.id=d.id and
d.client='00:04:20:1e:00:c6') group by tracks.id order by rand() limit 10;"]
[09:22:22.0988] Slim::Schema::Storage::throw_exception (122) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(C:/Squeezebox/LMS/Beta/server/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception
(C:\Squeezebox\LMS\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1057)
frame 3: (eval)
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1056)
frame 4: Plugins::SQLPlayList::Plugin::executeSQLForPlaylist
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 964)
frame 5: Plugins::SQLPlayList::Plugin::getTracksForPlaylist
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1261)
frame 6: Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3319)
frame 7: (eval)
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3319)
frame 8: Plugins::DynamicPlayList::Plugin::getTracksForPlaylist
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 345)
frame 9: Plugins::DynamicPlayList::Plugin::findAndAdd
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 525)
frame 10: Plugins::DynamicPlayList::Plugin::playRandom
(C:\Squeezebox\LMS\Beta\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3848)
frame 11: Plugins::DynamicPlayList::Plugin::cliPlayPlaylist
(C:/Squeezebox/LMS/Beta/server/Slim/Control/Request.pm line 1885)
frame 12: (eval) (C:/Squeezebox/LMS/Beta/server/Slim/Control/Request.pm line
1885)
frame 13: Slim::Control::Request::execute
(C:/Squeezebox/LMS/Beta/server/Slim/Control/Request.pm line 882)
frame 14: Slim::Control::Request::executeRequest
(C:/Squeezebox/LMS/Beta/server/Slim/Web/HTTP.pm line 915)
frame 15: Slim::Web::HTTP::processURL
(C:/Squeezebox/LMS/Beta/server/Slim/Web/HTTP.pm line 723)
frame 16: Slim::Web::HTTP::processHTTP
(C:/Squeezebox/LMS/Beta/server/Slim/Networking/IO/Select.pm line 123)
frame 17: (eval) (C:/Squeezebox/LMS/Beta/server/Slim/Networking/IO/Select.pm
line 119)
frame 18: Slim::Networking::IO::Select::__ANON__
(C:/Squeezebox/LMS/Beta/server/Slim/Networking/IO/Select.pm line 168)
frame 19: (eval) (C:/Squeezebox/LMS/Beta/server/Slim/Networking/IO/Select.pm
line 168)
frame 20: Slim::Networking::IO::Select::loop
(C:\Squeezebox\LMS\Beta\server\slimserver.pl line 715)
frame 21: main::idle (C:\Squeezebox\LMS\Beta\server\slimserver.pl line 665)
frame 22: main::main (C:\Squeezebox\LMS\Beta\server\slimserver.pl line 1200)
Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
