Hello
Since build 1148 my MM statistic is completely messed up.
I don't know what it is. The play-count of the mp3s ist still correct but the statistic appears to be several years old.
Seems like the past years haven't been counted.
Any solution for that?
Reinstalling build 1147 brought no change.
1148: Statistics messed up
Moderator: Gurus
Guy, in build 1147 some SQL queries were optimized in the script in order to speed up the report process. It was slow on some very large DBs. It is possible that there could be a regression, but rather many SQL queries related mailnly to 'played' values have been corrrected.
Could you give me an exact line which is reported badly for you?
e.g.
Page: Avagares
Line: Tracks per Artist
Could you give me an exact line which is reported badly for you?
e.g.
Page: Avagares
Line: Tracks per Artist
Hello Ludek, thank you for response.
The average lines seem to be correct.
The problem only concerns the Top 10-lists (Top10 played artists and top10 played albums). A new list Top10 albums wasn't there before but it only lists albums I only played a few times and my real top albums doesn't even appear in the statistics.
I also rescanned the library, but still no change.
The average lines seem to be correct.
The problem only concerns the Top 10-lists (Top10 played artists and top10 played albums). A new list Top10 albums wasn't there before but it only lists albums I only played a few times and my real top albums doesn't even appear in the statistics.
I also rescanned the library, but still no change.
Re: Top 10 Albums Played, Top 10 Artists Played
Yes, the determinant here is "How many songs of this album/artist have been played"
e.g.
Album1: 20 tracks and 18 of them have been played only once.
Album 2: 15 tracks and all 15 track have been played 6 times.
The Album1 will be higher because more tracks of this album have been played.
Do you think that there should be another determinant/indicator related to playcount?
You might be right. Then the SQL query in the Stats.vbs needs to be modified slightly:
i.e. Replace Count(Songs.ID) by Sum( PlayCounter)
in Scripts\stats.vbs on the lines 685 (twice - also in ORDER BY part) for Top 10 Artists Played and on the lines 746, 752 for Top 10 albums Played
Edited: I meant Sum( PlayCounter)
Yes, the determinant here is "How many songs of this album/artist have been played"
e.g.
Album1: 20 tracks and 18 of them have been played only once.
Album 2: 15 tracks and all 15 track have been played 6 times.
The Album1 will be higher because more tracks of this album have been played.
Do you think that there should be another determinant/indicator related to playcount?
You might be right. Then the SQL query in the Stats.vbs needs to be modified slightly:
i.e. Replace Count(Songs.ID) by Sum( PlayCounter)
in Scripts\stats.vbs on the lines 685 (twice - also in ORDER BY part) for Top 10 Artists Played and on the lines 746, 752 for Top 10 albums Played
Edited: I meant Sum( PlayCounter)