lazpete;647195 Wrote:
> 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
Try restarting SBS if you haven't already done so.
Then also take a look at the plugin\trackstat.prefs files in the
"Preference Folder", you will find the location of the preference
folder in SBS Settings/Information.
Look for a line like this and report back which number it specifies:
playlist_length: 50
--
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
