Chunkywizard;646159 Wrote:
> 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?
>
Should be fixed in Database Query 2.3.3392 which I just released.
--
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
