c0utta;266577 Wrote:
> Erland, do you have any ideas as to what this could be?
>
It could be that there are extra entries in the track_statistics table
that doesn't exist in the SlimServer database. This will happen if you
have renamed or moved any music file.
If this is the cause, the solution is to change the SQL to something
like:
Code:
--------------------
select ts.url
from track_statistics ts,tracks
where ts.rating > 4 and ts.url=tracks.url and tracks.audio=1
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, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library and Database Query plugins'
(http://wiki.erland.homeip.net/index.php/Category:SlimServer))
------------------------------------------------------------------------
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
