Reply To: FireStats – Top 40 php script (now with added charts)

  • Post date

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.