gjgriffith;645266 Wrote:
> 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
>
Have you tried if it works if you restart Squeezebox Server ?
I think it might end up in this state after a full rescan because I'm
adding the "unix_timestamp" function it says is missing at SQL Playlist
plugin initialization when the server starts up and I think it maybe
could be removed by standard SBS code after a full rescan.
Let me know if restarting Squeezebox Server helps.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
