Hi Erland,
When using the Trackstat Statistics query in the Database Query plugin
I get the following error:
Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: no such function: concat [for Statement " select concat('Number
of ',round(track_statistics.rating/20),' star rated songs') as
parameter,count(*) from track_statistics,tracks where
tracks.url=track_statistics.url and audio=1 and
track_statistics.rating>0 group by round(track_statistics.rating/20)
order by track_statistics.rating "] at /Slim/Schema/Storage.pm line 123
, no such function: concat
However the output seems correct. Any ideas?
CW
--
Chunkywizard
*Squeezebox:* Boom x2 (Lounge and Office), Radio (with battery)
*Server:* 7.6.0 for Windows Home Server (HP EX-490 MediaSmart Server)
*Plugins:* Dynamic Playlists 2.8.4 | SQL Playlist 2.5.3359 | Music
Information Screen 4.4.7 | Custom Scan 2.83378 | TrackStat 2.10.3366 |
Album Review 2.9.5 | Biography 2.9.4
*Remote:* iPod Touch Gen. 1 running 'iPeng'
(http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/)
*Music: *'Last.fm' (http://www.last.fm/user/chunkywizard)
------------------------------------------------------------------------
Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868
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
