jania;405586 Wrote:
> After getting the templates imported successfully I was getting the
> following error in the cacti logs:
> Every derived table must have its own alias
>
> turns out there is a syntax error in the ss_squeeze_played.php file:
>
> where ifnull(lastplayed,0)>unix_timestamp()-TIME_TO_SEC(CURTIME()))
>
> was the culprit, adding a left parenthesis in front of "unix" fixed it
> (which is what you have posted in this thread above):
>
> where ifnull(lastplayed,0)>(unix_timestamp()-TIME_TO_SEC(CURTIME()))
>
> Now everything is working beautifully! Thanks for your effort on this.
whoops, that was pretty sure a copy&paste failure ^^
I just added these lines to the php script (and also changed the
attached file in the first post) because I found out that the graph
gets really ugly, as soon as there are only few tracks left for an
"average" rating:
//Use rating only if more them 10 tracks have been played
if($line[1] <= 10) {
$line[2] = 0;
}
--
Blu3IcE
System: Ubuntu, SqueezeCenter-Version: 7.3
Player: Squeezebox v3 @ Bose LifeStyle Series III
Plugins: TrackStat, SugarCube, Dynamic Playlists, AutoDim
------------------------------------------------------------------------
Blu3IcE's Profile: http://forums.slimdevices.com/member.php?userid=13792
View this thread: http://forums.slimdevices.com/showthread.php?t=61105
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
