You are here: Home » Reply

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

#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.