This is what I see in the log with trackstat debugging turned on when I navigate to TrackStat / Songs / Most played songs recently played:
2006-10-15 10:35:48.5539 TrackStat: Entering baseWebPage 2006-10-15 10:35:48.5560 TrackStat: Get statistic context for level=1 2006-10-15 10:35:48.5562 TrackStat: Exiting baseWebPage 2006-10-15 10:35:48.5564 TrackStat: Calling webfunction for mostplayedalbums 2006-10-15 10:35:48.5577 TrackStat::Statistics: Executing: select albums.id,avg(case when track_statistics.rating is null then 60 else track_statistics.rating end) as avgrating, avg(case when track_statistics.playCount is null then tracks.playCount else track_statistics.playCount end) as avgcount,max(track_statistics.lastPlayed) as lastplayed, max(track_statistics.added) as maxadded from tracks left join track_statistics on tracks.url = track_statistics.url join albums on tracks.album=albums.id group by tracks.album having count(tracks.id)>=1 order by avgcount desc,avgrating desc,rand() limit 50 2006-10-15 10:35:48.5598 Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' 2006-10-15 10:35:51.1549 TrackStat: Entering baseWebPage 2006-10-15 10:35:51.1570 TrackStat: Get statistic context for level=1 2006-10-15 10:35:51.1572 TrackStat: Get statistic context for level=2 2006-10-15 10:35:51.1573 TrackStat: Exiting baseWebPage 2006-10-15 10:35:57.2815 TrackStat: Entering baseWebPage 2006-10-15 10:35:57.2838 TrackStat: Get statistic context for level=1 2006-10-15 10:35:57.2841 TrackStat: Get statistic context for level=2 2006-10-15 10:35:57.2842 TrackStat: Exiting baseWebPage 2006-10-15 10:35:57.2844 TrackStat: Calling webfunction for mostplayedrecent 2006-10-15 10:35:57.2857 TrackStat::Statistics: Executing: select tracks.id,count(track_history.url) as recentPlayCount,0 as added,max(track_history.played) as lastPlayed,avg(track_statistics.rating) as avgrating from tracks,track_history,track_statistics where tracks.url = track_history.url and tracks.url=track_statistics.url and tracks.audio=1 and played>1158312957 group by track_history.url order by recentPlayCount desc,avgrating desc,rand() limit 50; 2006-10-15 10:35:57.2876 Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' 2006-10-15 10:36:57.5340 TrackStat: Entering baseWebPage 2006-10-15 10:36:57.5361 TrackStat: Get statistic context for level=1 2006-10-15 10:36:57.5363 TrackStat: Get statistic context for level=2 2006-10-15 10:36:57.5365 TrackStat: Exiting baseWebPage 2006-10-15 10:36:57.5366 TrackStat: Calling webfunction for mostplayedrecent 2006-10-15 10:36:57.5388 TrackStat::Statistics: Executing: select tracks.id,count(track_history.url) as recentPlayCount,0 as added,max(track_history.played) as lastPlayed,avg(track_statistics.rating) as avgrating from tracks,track_history,track_statistics where tracks.url = track_history.url and tracks.url=track_statistics.url and tracks.audio=1 and played>1158313017 group by track_history.url order by recentPlayCount desc,avgrating desc,rand() limit 50; 2006-10-15 10:36:57.5406 Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Phil _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
