I finally had a chance to revisit this issue.
I installed the latest nightly (LogitechMediaServer-7.9.0-1450532265)
and had the same issue. I searched around a bit and found the comment by
Erland
http://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=659085&viewfull=1#post659085
that implies that somehow the plugin is supposed to install the
unix_timestamp function, but clearly this is no longer working as I've
tried restarting the server and every other trick I can think of, and
the issue remains.
The server log:
[15-12-19 12:55:42.6044] Slim::Schema::Storage::throw_exception (122)
Error: DBI Exception: DBD::SQLite::db prepare failed: no such function:
unix_timestamp [for Statement "select tracks.url from tracks join
genre_track on tracks.id=genre_track.track join genres on
genre_track.genre=genres.id left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:12:d6:db' left join
track_statistics on tracks.url=track_statistics.url where audio=1 and
dynamicplaylist_history.id is null and genres.name in ('Jazz') and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-15724800) group
by tracks.id order by random() limit 10;"]
[15-12-19 12:55:42.6049] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line
122)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm
line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1057)
frame 3: (eval)
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1056)
frame 4: Plugins::SQLPlayList::Plugin::executeSQLForPlaylist
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 964)
frame 5: Plugins::SQLPlayList::Plugin::getTracksForPlaylist
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm
line 1261)
frame 6: Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3319)
frame 7: (eval)
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3319)
frame 8: Plugins::DynamicPlayList::Plugin::getTracksForPlaylist
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 345)
frame 9: Plugins::DynamicPlayList::Plugin::findAndAdd
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 525)
frame 10: Plugins::DynamicPlayList::Plugin::playRandom
(C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3848)
frame 11: Plugins::DynamicPlayList::Plugin::cliPlayPlaylist
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
1883)
frame 12: (eval)
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
1883)
frame 13: Slim::Control::Request::execute
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
880)
frame 14: Slim::Control::Request::executeRequest
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Web/HTTP.pm line 875)
frame 15: Slim::Web::HTTP::processURL
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Web/HTTP.pm line 683)
frame 16: Slim::Web::HTTP::processHTTP
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm
line 123)
frame 17: (eval)
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm
line 119)
frame 18: Slim::Networking::IO::Select::__ANON__
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm
line 168)
frame 19: (eval)
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm
line 168)
frame 20: Slim::Networking::IO::Select::loop (slimserver.pl line
735)
frame 21: main::idle (slimserver.pl line 685)
frame 22: main::main (slimserver.pl line 129)
frame 23: PerlSvc::Interactive
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>PerlSvc.pm line 99)
frame 24: PerlSvc::_interactive (slimserver.pl line 0)
frame 25: (eval) (slimserver.pl line 0)
[15-12-19 12:55:42.6053]
Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1083) Database
error: no such function: unix_timestamp
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed:
no such function: unix_timestamp [for Statement "select tracks.url from
tracks join genre_track on tracks.id=genre_track.track join genres on
genre_track.genre=genres.id left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:12:d6:db' left join
track_statistics on tracks.url=track_statistics.url where audio=1 and
dynamicplaylist_history.id is null and genres.name in ('Jazz') and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-15724800) group
by tracks.id order by random() limit 10;"] at
/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line
126
------------------------------------------------------------------------
gjgriffith's Profile: http://forums.slimdevices.com/member.php?userid=44069
View this thread: http://forums.slimdevices.com/showthread.php?t=104816
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
