Thanks Erland for your time and efforts developing and supporting your
plugins.
Since I've upgraded to 7.6, I can'r run my Dynamic Playlists on Windows
Home Server. I use no custom SQL.
The log seems to show complaints about unix_timestamp being an
unsupoorted function. Here is a typical log entry:
[11-07-30 09:06:05.1456]
Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1036) 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','Pop/Rock') and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-86400) group by
tracks.id order by random() limit 10;"] at /<C:\Program
Files\Squeezebox\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 123
--
gjgriffith
------------------------------------------------------------------------
gjgriffith's Profile: http://forums.slimdevices.com/member.php?userid=44069
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
