FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FireStats – Top 40 php script (now with added charts) › Reply To: FireStats – Top 40 php script (now with added charts)
16/12/2007 at 10:34 PM
#14795
sonichouse
Participant
@sonichouse wrote:
sqlite2 does not like the
select 'Albums Played' as Item, count(distinct Album) as Desc from songs where play_count>0
bit in that sql. I will find an approach that does work – for now can you just comment out that one sql statement ?
Fixed in 1.21
summary.php:select 'Albums Played' as Item, count(Album) as Desc from (select distinct Album from songs where play_count>0)
Discussed in my blog here.