Bug 4708 - Compilations bug with various artists - STILL not resolved in 651
: Compilations bug with various artists - STILL not resolved in 651
Status: RESOLVED DUPLICATE of bug 4516
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5.1
: All Ubuntu Linux
: P2 minor (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-01-24 07:16 UTC by Jim Willsher
Modified: 2007-02-21 11:28 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments
MP3 file where the artist isn't being listed. (6.33 MB, application/octet-stream)
2007-01-24 14:28 UTC, Jim Willsher
Details
Build log for a sample problem album (68.29 KB, text/plain)
2007-01-31 12:08 UTC, Jim Willsher
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Willsher 2007-01-24 07:16:48 UTC
I got all excited when I saw 6.5.1 had been released. Admittedly the Various Artists bug is lss prominent, but it's still there.

I have an album (mp3) called The Eighties Movies Album. On the album there's a track called "9 to 5" by Dolly Parton.

If I type "Eighties" in the search I can see the album. I then select the album and I see all the tracks. If I click the 9-5 track I get the details, and I can click Dolly Parton (oo-er!).. But this then returns:

Artists / Dolly Parton    0 albums with 0 songs by 0 artists. 

Similarly, Dolly Parton doesn't appear in the list of artists when viewing the A-Z of artists.


I'm using Fishbone, MySql 5, Ubuntu 6.06 (server only), and I've done a full clear and rescan. The server behavious is set to "List compilation albums under each artists"


Do Slim (Logitech) propose actually fixing this bug? It's been around for months and months now,a nd 6.5.1 was the Great White Hope. Sorry to sound a bit harsh, but I'm really quite saddened that this is still lurking.

Many thanks,



Jim
Comment 1 Jim Willsher 2007-01-24 07:19:45 UTC
By the way, all the tracks from the given album are contained within a single folder: 

/slim/music/Various/The Eighties Movie Album/01 - The Power Of Love.mp3
/slim/music/Various/The Eighties Movie Album/09 - 9 To 5.mp3 


etc.
Comment 2 KDF 2007-01-24 09:07:37 UTC
If this is referring to an existing report, please add comments to that bug.  Opening a new report will NOT help.  If this has not been given a bug report, then no surprise it's not fixed.
Comment 3 Jim Willsher 2007-01-24 09:17:16 UTC
Thanks KDF, four your tact and politeness.


It's hard to tell if anyone has attempted to resolve it or not. The closest match is 

https://bugs-archive.lyrion.org/show_bug.cgi?id=4283

but that claims to be fixed. If it's fixed, why is it still broken? Methinks you have too many code branches....




Jim
Comment 4 Ben Sandee 2007-01-24 10:52:30 UTC
(In reply to comment #3)
 
> but that claims to be fixed. If it's fixed, why is it still broken? Methinks
> you have too many code branches....
>

This doesn't look like the same bug to me.  The reason that bug is marked fixed is that a patch was applied and the reporter verified it as fixed.  No need to get sardonic.

Ben
Comment 5 Spies Steven 2007-01-24 13:10:28 UTC
Jim, would you attache an archive of the Dolly Parton file or better yet the whole album? I would like to take a look at the tags. The behavior you are seeing sounds similar to bug 4386 and bug 4629 to me.
Comment 6 Jim Willsher 2007-01-24 14:28:04 UTC
Created attachment 1787 [details]
MP3 file where the artist isn't being listed.
Comment 7 Jim Willsher 2007-01-24 14:30:50 UTC
Ok, I've uplaoded the offending MP3 file. I suspect are the tracks all in the same boat, but I wasn't comfortable uplaoding the entire album (bandwidth and piracy reasons!).

Many thanks for your help, appreciated.


Jim
Comment 8 Spies Steven 2007-01-24 15:25:13 UTC
Jim, I noticed that the "TCMP" Compilation frame was not set in this file. Try setting it to 1 and see if you get the same behavior.
Comment 9 Jim Willsher 2007-01-25 01:53:33 UTC
What the heck is a TCMP compilation frame?

I tag all my MP3 files using JJ MP3 Renamer, which allows me to edit the ID3 V1 and ID3 V2 tags.  My ID3 V2 Artist tag says "Dolly Parton" - isn't this sufficient?

Cheers :-)




Jim
Comment 10 KDF 2007-01-25 11:57:12 UTC
TCMP is the Compilation tag which is used to indicate that a given track is part of a mixed album.  Tag & Rename has this selectable as a checkbox "part of compilation".  Slimserver relies on this tag as part of its various artists logic.

some extra info here:
http://wiki.slimdevices.com/index.cgi?VariousArtistsLogic
Comment 11 Jim Willsher 2007-01-25 12:18:02 UTC
Many thanks for the link.

It's a shame that SS relies on this tag. It's apparently a non-standard tag, and SS correctly reports the info when I choose to view the whole album:

9. 9 To 5 from The Eighties Movie Album by Dolly Parton  


so if it's knows the artist is Dolly Parton, why does Dolly Parton not appear within the Artists list?
Comment 12 Spies Steven 2007-01-25 12:36:38 UTC
(In reply to comment #11)
> Many thanks for the link.
> 
> It's a shame that SS relies on this tag. It's apparently a non-standard tag,
> and SS correctly reports the info when I choose to view the whole album:

The TCMP frame Compilation tag is standard and part of the ID3 specification. Your tagging program may not support it however. More information can be found at www.id3.org

> 9. 9 To 5 from The Eighties Movie Album by Dolly Parton  
> 
> 
> so if it's knows the artist is Dolly Parton, why does Dolly Parton not appear
> within the Artists list?

I am still looking into this and I hope to report back soon.
Comment 13 Jim McAtee 2007-01-26 00:56:37 UTC
TCMP is not a standard id3v2 frame.  More importantly, this tag should NOT be necessary for the SlimServer to realize that an album is a compilation.  Just having different artists for the different tracks is usually enough.

Is this the only track on the album that displays this behavior?  What about other VA albums?

In Server Setttings > Behavior > Compilations, what is your setting for "You can choose to have compilation albums appear together..." ?
Comment 14 Jim Willsher 2007-01-26 01:11:23 UTC
I have the setting as "list compilation albums under each artist"

This problem affects ALMOST every track on this album. On the same album there's a track "2. Flashdance... What A Feeling from The Eighties Movie Album by Irene Cara" which says "Compilation: Yes". When I view "Irene Cara"  I see:

1 album with 16 songs by 1 artist. 
--------------------------------------------------------------------------------

The Eighties Movie Album




I have another compilation album called "The Ultimate Eighties (Disc 2)". If I browse the album I see:

"3. White Wedding from The Ultimate Eighties (Disc 2) by Billy Idol". I then click "Billy Idol" and see "0 albums with 0 songs by 0 artists. ". Even though when I view the track it says "Compilation: Yes".

On the very same album I see "19. We Close Our Eyes from The Ultimate Eighties (Disc 2) by Go West". I then click "Go West" and I see:

1 album with 20 songs by 1 artist. 
--------------------------------------------------------------------------------

The Ultimate Eighties (Disc 2)  

This track also shows "Compilation: Yes" (as did the track from the initial problem report, the "9 to 5" track)



So, it's working happily for one track on each album, but seemingly for nothing else. To me, what is happening is that only one artist from each compilation is getting stored, possibly either the first or last to be processed (though it's not the first or last track). All others result in nothing. 

I can confirm that with three other albums: for each album, clicking the track and then the artist results in "0 alnums with 0 songs by 0 artists" for EVERY track except one (unless of course I have other recordings by the artist).

Comment 15 Spies Steven 2007-01-26 09:23:49 UTC
(In reply to comment #13)
> TCMP is not a standard id3v2 frame.  More importantly, this tag should NOT be
> necessary for the SlimServer to realize that an album is a compilation.  Just
> having different artists for the different tracks is usually enough.

Jim, I don't know what I was thinking. You are correct that TCMP is NOT part of the id3 specification. Sorry about that. However Slimserver does support this tag.

Note to self: Investigate use of TCMP in Slimserver.
Comment 16 Jim Willsher 2007-01-26 09:35:57 UTC
Yeah, I thought that was the case, but then doubted myself :-)

I think I must be on to something though, with my subsequent notes - only ONE track from each Compilation album has the artist listed in the "Artists" view, and this is true for every compilation album I try.

Jim
Comment 17 Spies Steven 2007-01-30 14:16:00 UTC
Jim, I was not able to reproduce the behavior you described. I tested on Mac OS X, Win XP and Ubuntu 6.06.1. Have you tried contacting support? http://www.slimdevices.com/su_tech.html
Comment 18 Jim Willsher 2007-01-31 04:41:33 UTC
Hi Steven,

No I've not contacted support yet, but will do so.

Did you have Ubuntu configured to use MySql?


Jim
Comment 19 Spies Steven 2007-01-31 10:44:46 UTC
Jim, I believe that Slimserver version 6.5.0 and higher use MySQL by default.

Here is the version info from the Ubuntu system I used for reference:

SlimServer Version: 6.5.1 - 11206 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.101
Perl Version: 5.8.7 i486-linux-gnu-thread-multi
MySQL Version: 4.1.15-Debian_1ubuntu5
Comment 20 Jim Willsher 2007-01-31 11:00:56 UTC
Mine shows this:

VERSION INFO
SlimServer Version: 6.5.1 - 11206 - Debian - EN - utf8
Server IP address: 192.168.1.150
Perl Version: 5.8.7 i486-linux-gnu-thread-multi
MySQL Version: 5.0.22-Debian_0ubuntu6.06.2-log


I've had a poke around in the database. If I look at "albums" and search:

SELECT * 
FROM `albums` 
WHERE `titlesearch` LIKE '%eighties%'
LIMIT 0 , 30

I get three matches, which is fair enough:


  id  title  titlesort  titlesearch  customsearch  compilation  year  artwork  disc  discc  replay_gain  replay_peak  musicbrainz_id  musicmagic_mixable  contributor  
      345 [BLOB - 24 B] EIGHTIES MOVIE ALBUM EIGHTIES MOVIE ALBUM NULL 1 0 3763 NULL NULL NULL NULL NULL NULL 97 
      346 [BLOB - 30 B] ULTIMATE EIGHTIES DISC 1 ULTIMATE EIGHTIES DISC 1 NULL 1 1994 3779 NULL NULL NULL NULL NULL NULL 97 
      347 [BLOB - 30 B] ULTIMATE EIGHTIES DISC 2 ULTIMATE EIGHTIES DISC 2 NULL 1 1994 3799 NULL NULL NULL NULL NULL NULL 97 



If I then look at "contributor_album" via:

SELECT *  FROM `contributor_album` WHERE `album` = 345 OR `album` = 346 OR `album` = 347

I get:

  role  contributor  album  
      1 292 345 
      1 315 346 
      1 304 347 


So if I then look at contributors:

SELECT *  FROM `contributors` WHERE `id` = 292 OR `id` = 315 OR `id` = 304

I see:

  id  name  namesort  namesearch  customsearch  moodlogic_id  moodlogic_mixable  musicbrainz_id  musicmagic_mixable  
      292 [BLOB - 10 B] IRENE CARA IRENE CARA NULL NULL NULL NULL NULL 
      304 [BLOB - 7 B] GO WEST GO WEST NULL NULL NULL NULL NULL 
      315 [BLOB - 20 B] FINE YOUNG CANNIBALS FINE YOUNG CANNIBALS NULL NULL NULL NULL NULL 


In other words, for each of the three "Various" albums I only ever see ONE artist.


Can you (or anyone) suggest where else I can debug this? There's definitely something whacky going on!


Jim
Comment 21 Jim Willsher 2007-01-31 12:08:47 UTC
Created attachment 1800 [details]
Build log for a sample problem album

Sorry if you get this several times, I kept getting timeout messages from bugs.slimdevices.com



I've attached the section fo the build log from this album. It's clear what is happening - after each track there's an UPDATE ALBUMS SET CONTRIBUTOR = statement. So this explains why each album only ever has one contributor - the last one to be processed.

I'd be happy to upload the entire album if that helps to save my sanity....
Comment 22 Spies Steven 2007-02-21 11:28:40 UTC
After further investigation for Bug 4516 it appears that this bug is actually
the same. The undesired behavior seems to be dependent on only having a
playlist saved with one or more songs from a compilation album. If it turns out
I am mistaken please open this bug again.

*** This bug has been marked as a duplicate of 4516 ***