Bug 3806 - Various Artists: Incorrect album, song, artist counts
: Various Artists: Incorrect album, song, artist counts
Status: RESOLVED PATCHWELCOME
Product: Logitech Media Server
Classification: Unclassified
Component: Web Interface
: 6.5b1
: PC Windows XP
: P2 normal with 1 vote (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-07-23 22:38 UTC by Jim McAtee
Modified: 2008-09-15 14:39 UTC (History)
4 users (show)

See Also:
Category: ---


Attachments
zip file containing multigenre mp3 and flac files (51.35 KB, application/octet-stream)
2006-07-28 14:05 UTC, Chris Owens
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jim McAtee 2006-07-23 22:38:02 UTC
My library total (if correct) shown on the home page is '928 albums with 11022 songs by 452 artists'.  When I go into Browse Albums I see '928 albums with 11022 songs by 419' artists.  Shouldn't the artists count be the same?

Also see incorrect counts when browsing by genre.  It doesn't look like any artists or albums are missing, just that the counts on the initial artist list page are off.

I have one VA album under the genre 'Acoustic'.  When I enter I see 'Various Artists' listed, but '0 albums with 0 songs by 0 artists' is shown.  Under another genre I have one (non-VA) album by three artists.  Entering that genre I see the three individual artists listed, but '2 albums with 28 songs by 3 artists.  Should be 1, 15, 3.  This album happens to be tagged with two genres.  Under 'Comedy' I should have 4 albums, one a VA album.  All 4 artists are listed, but the counts only count the albums, tracks and artists of the 3 non-VA albums.  In another instance I have 9 albums by 5 artists by the count shows 11 by 4.

I get the feeling that the incorrect counts have to do with albums that are tagged with more than one genre.
Comment 1 Chris Owens 2006-07-25 11:01:29 UTC
What kind of files are these, Jim?  mp3?  Flac?
Comment 2 Jim McAtee 2006-07-25 11:19:22 UTC
All flac.
Comment 3 Chris Owens 2006-07-28 14:05:49 UTC
Created attachment 1384 [details]
zip file containing multigenre mp3 and flac files

Could you upload one of the affected files?  I couldn't seem to repro the problem with the test files I made.
Comment 4 Jim McAtee 2006-07-28 14:27:40 UTC
I think the forum thread below, particularly '(b)' in post #6, touches on the issue.

http://forums.slimdevices.com/showthread.php?t=25605

I'll see if I can create a test album of very short tracks with the same tagging as one of the albums where the problem is evident.
Comment 5 Chris Owens 2006-08-19 15:48:49 UTC
This forum thread ends up pointing to bug 3866, now.

Jim, it looks like maybe you ended up with this bug being fixed (looking at http://forums.slimdevices.com/showpost.php?p=126598&postcount=34).  Is that true?
Comment 6 Jim McAtee 2006-08-19 23:35:39 UTC
Yes and no.  The album counts when browsing genres are mostly worked out now.  I still have one VA 'Acoustic' album and it still shows a count of 0-0-0 when entering that genre, but most everything else is now correct.

Browe Albums is still showing the wrong artist count, but maybe it's related to whatever is causing bug 3255?  I have no idea how these counts are arrived at.  On the home page of the web UI and in all other browse modes I have:

979 albums with 11569 songs by 469 artists

In browse Albums I have:

979 albums with 11569 songs by 729 artists
Comment 7 Chris Owens 2006-08-21 10:48:18 UTC
Dan do you have any ideas what I could do to help figure this one out?
Comment 8 Jim McAtee 2006-08-21 11:24:53 UTC
The incorrect browse Albums arist count maybe be related to VA albums not being grouped together, as I just recently discovered and commented on in bug 3350.  On the top level pages of browse Albums, shouldn't you simply be running the same counting queries as run on the home page, so that overall library totals are always displayed?  The counts should never differ from those shown on the home page.
Comment 9 Jim McAtee 2006-08-29 11:03:30 UTC
Another data point: In the genre where I had one VA album and a count of 0-0-0 shown, I've added 4 albums, 42 tracks, by 1 artist.  The total is now 4-42-1.  So it appears that VA albums aren't being counted under browse Genres.  Again, maybe related to the issues broken compilation album grouping.
Comment 10 Dan Sully 2006-09-10 17:33:48 UTC
I know what's happening, and I don't have a way to fix it at this point in time.

You'll just need to deal with the VA counts being off.

Probably won't make 6.5 unless I have have an epiphany
Comment 11 Patrick Dixon 2006-09-11 01:53:40 UTC
I've got:-

Artists
1634 albums with 25142 songs by 699 artists. 

Albums
1634 albums with 25142 songs by 2668 artists. 

So my assumption is that the Artists, artists count is correctly discounting VA artists (so it's just a count of artists with their own albums), whilst Albums, artists count is counting every single artist.
Comment 12 Patrick Dixon 2006-09-11 02:41:39 UTC
Checking the MySQL db tables shows 'contributors' has 2669 records (is the count off by 1 because the records start at 0?)

'albums' agrees at 1634

HTH
Comment 13 Simon Turner 2006-09-11 13:43:17 UTC
Dan Sully has indicated tnat this bug is the one relevant to my problem so I thought it best to document it.
I have a genre (Chamber Music) that only contains one album. This album is by various artists, each track tagged as Chamber Music. It is impossible to play this album via the remote (using browse by genre) and it is listed oddly in the web interface too (0 albums with 0 songs by 0 artists), although it can be played.
MC
Comment 14 Dan Sully 2006-09-11 13:47:27 UTC
Simon - the player part is another bug. I do have a fix for it though, which I'll get in shortly.
Comment 15 Jim McAtee 2006-09-13 11:43:15 UTC
I just took a look at the counts presented under Browse Genres.  Examining a small genre, with NO compilation albums, SlimServer gives counts of: 20-307-10, whereas the actual counts are 11-198-10.  So there are counting problems that go beyond those involving just various artists.
Comment 16 Dan Sully 2006-09-13 11:44:26 UTC
Oh just turn the damn counts off.
Comment 17 Jim McAtee 2006-09-13 12:08:34 UTC
You're welcome.  Glad I could help.
Comment 18 Simon Turner 2006-09-13 12:40:46 UTC
aha, the pressure of a new product release deadline. I hope you are getting some sleep Dan. Good luck.
Comment 19 Patrick Dixon 2006-10-10 08:07:47 UTC
svn 6.5 10272

Artists
Artists
2048 albums with 29849 songs by 900 artists.


Albums Gallery
Sort By Artist, Year, Album 
Albums
2048 albums with 29849 songs by 3319 artists

Looks like Albums/Songs count is consistent for me between Artists and Albums Web UI views - Artist count is much larger in Album view, presumably because it's not ignoring VA artists.

Is there a bug filed for VA albums included under Browse Artists (in both Player & Web UI) - even when they are set to be ignored?  If not, I'd like to raise one!