erland;647191 Wrote: > Can you post or mail me the *.sql or *.sql.values.xml file for the > playlists that doesn't work ? > > Do you get any error in the server.log ?
this is one error I found, and its long :) I will try to find the sql file. [11-08-04 18:50:38.9212] Plugins::TrackStat::Plugin::getNextDynamicPlayListTracks (4892) Failure calling playlistfunction for topratedrecentalbums: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: near " ": syntax error [for Statement "select albums.id,avg(case when track_statistics.rating is null then 60 else track_statistics.rating end) as avgrating,count(track_history.url)/count( track_history.url) as avgcount,max(track_history.played) as lastplayed, 0 as maxadded from tracks join track_history on tracks.url=track_history.url join albums on tracks.album=albums.id join track_statistics on tracks.url=track_statistics.url left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='00:04:20:12:56:2a' where dynamicplaylist_history.id is null and played1309884638 group by tracks.album order by avgrating desc,avgcount desc,random() limit "] at /<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 123 -- lazpete ------------------------------------------------------------------------ lazpete's Profile: http://forums.slimdevices.com/member.php?userid=4841 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
