Yannzola;166054 Wrote: > Nope. No joy. Any other suggestions or data I can provide? 1. Just to make sure, you have restarted slimserver after you upgraded to the new plugin versions ?
2. Have you checked if there are any errors in the slimserver log: http://localhost:9000/log.txt 3. Could you try to create a number of new playlists like: Playlist 1: Simple playlist, check that it only return tracks with rating>=3. If this playlist doesn't return anything, you don't have to check the next playlists because then it means that your ratings doesn't seem to exist. We then need to start investigate why. Code: -------------------- select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url where audio=1 and track_statistics.rating>=50 group by tracks.id order by rand() limit 10; -------------------- Playlist 2: Doesn't exclude already played tracks, check if it returns both unrated tracks and track rated>=3 Code: -------------------- select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url where audio=1 and tracks.secs>60 and track_statistics.rating>=50 or track_statistics.rating is null and not exists (select * from tracks t2,genre_track,genres where t2.id=tracks.id and tracks.id=genre_track.track and genre_track.genre=genres.id and genres.name in ('Christmas','Musical','Spoken Word')) group by tracks.id order by rand() limit 10; -------------------- Playlist 3: Doesn't return unrated tracks, check that it only return tracks rated>=3 Code: -------------------- select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1 and dynamicplaylist_history.id is null and tracks.secs>60 and track_statistics.rating>=50 and not exists (select * from tracks t2,genre_track,genres where t2.id=tracks.id and tracks.id=genre_track.track and genre_track.genre=genres.id and genres.name in ('Christmas','Musical','Spoken Word')) group by tracks.id order by rand() limit 10; -------------------- Playlist 4: Doesn't exclude the genres, check if it returns both unrated tracks and tracks rated>=3 Code: -------------------- select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1 and dynamicplaylist_history.id is null and tracks.secs>60 and track_statistics.rating>=50 or track_statistics.rating is null group by tracks.id order by rand() limit 10; -------------------- Playlist 5: Doesn't exclude short tracks, check if it returns tracks with both unrated tracks and tracks rated>=3 Code: -------------------- select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1 and dynamicplaylist_history.id is null and track_statistics.rating>=50 or track_statistics.rating is null and not exists (select * from tracks t2,genre_track,genres where t2.id=tracks.id and tracks.id=genre_track.track and genre_track.genre=genres.id and genres.name in ('Christmas','Musical','Spoken Word')) group by tracks.id order by rand() limit 10; -------------------- -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
