Bug 2203 - Albums with more than one artist being listed many times
: Albums with more than one artist being listed many times
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Tagging
: 6.2.0
: PC Linux (other)
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-09-26 14:26 UTC by John Gorst
Modified: 2011-03-16 04:19 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments
Database file (5.57 MB, application/octet-stream)
2005-10-11 12:03 UTC, John Gorst
Details

Note You need to log in before you can comment on or make changes to this bug.
Description John Gorst 2005-09-26 14:26:16 UTC
Problem with an album I have created called "singles" containting a number of
random (and mostly not to my taste) one off tracks. I have retagged all of these
mp3 files with the album name "singles".

Prior to the 'various artists' feature being added all these tracks were listed
under the same album the "browse albums". Now there are multiple listing as
shown below. They should be listed as "Singled by various artists"

If for example I click on "Singles by david essex" I get a load of songs by
about 20 different artists. I have noted that the tracks listed under an artist
are mostly of the same genre category (although not exclusively).

Any ideas?

Linux, latest nightly, using musicmagic

        Singles  by  Pulp
AddPlay MusicMagic Mix     Singles by The Farm
AddPlay MusicMagic Mix     Singles by Rooster
AddPlay MusicMagic Mix     Singles by Björk
AddPlay MusicMagic Mix     Singles by David Essex
AddPlay MusicMagic Mix     Singles by Elton John
AddPlay MusicMagic Mix     Singles by R Kelly
AddPlay MusicMagic Mix     Singles by Will Smith
AddPlay MusicMagic Mix     Singles by Vanessa Carlton
AddPlay MusicMagic Mix     Singles by The Police
AddPlay MusicMagic Mix     Singles by The Contours
AddPlay MusicMagic Mix     Singles by The Beatles
AddPlay MusicMagic Mix     Singles by The Avalanches
AddPlay MusicMagic Mix     Singles by t.A.T.u.
AddPlay MusicMagic Mix     Singles by Sugababes
AddPlay MusicMagic Mix     Singles by U2
AddPlay MusicMagic Mix     Singles by Stevie Wonder
AddPlay MusicMagic Mix     Singles by Starlight
AddPlay MusicMagic Mix     Singles by Smash Mouth
AddPlay MusicMagic Mix     Singles by Steps
AddPlay MusicMagic Mix     Singles by Gwen Stefani
AddPlay MusicMagic Mix     Singles by S Club 7
AddPlay MusicMagic Mix     Singles by Ricky Martin
AddPlay MusicMagic Mix     Singles by The Red Hot Chili Peppers
AddPlay MusicMagic Mix     Singles by Queen
AddPlay MusicMagic Mix     Singles by Nelly
AddPlay MusicMagic Mix     Singles by Puff Daddy
AddPlay MusicMagic Mix     Singles by Madonna
AddPlay MusicMagic Mix     Singles by Kylie Minogue
AddPlay MusicMagic Mix     Singles by Jackson Five
AddPlay MusicMagic Mix     Singles by Gloria Gaynor
AddPlay MusicMagic Mix     Singles by Frankie Vali
AddPlay MusicMagic Mix     Singles by Elton John
AddPlay MusicMagic Mix     Singles by Dr. Evil
AddPlay MusicMagic Mix     Singles by Dolby
AddPlay MusicMagic Mix     Singles by Don McLean
AddPlay MusicMagic Mix     Singles by Diana Ross & The Supremes
AddPlay MusicMagic Mix     Singles by Deep Blue Something
AddPlay MusicMagic Mix     Singles by Counting Crows
AddPlay MusicMagic Mix     Singles by Coolio
AddPlay MusicMagic Mix     Singles by Claire Sweeney
AddPlay MusicMagic Mix     Singles by Clarence Henry
AddPlay MusicMagic Mix     Singles by Charlie's Angels
AddPlay MusicMagic Mix     Singles by Britney Spears
AddPlay MusicMagic Mix     Singles by Bob Dylan
AddPlay MusicMagic Mix     Singles by Black Lace
AddPlay MusicMagic Mix     Singles by Barry White
AddPlay MusicMagic Mix     Singles by Barry Manilow
AddPlay MusicMagic Mix     Singles by Aqua
AddPlay MusicMagic Mix     Singles by Alice Deejay
AddPlay MusicMagic Mix     Singles by Al Green

Resutls of clicking on "singles by david essex"

AddPlay  MusicMagic Mix          99 red Balloons - Singles - Nena
AddPlay MusicMagic Mix     Albatross - Singles - Fleetwood Mac
AddPlay MusicMagic Mix     Blame It On The Boogie - Singles - The Jacksons
AddPlay MusicMagic Mix     Bridge Over Troubled Water - Singles - Simon &Garfunkel
AddPlay MusicMagic Mix     Down Under - Singles - Men At Work
AddPlay MusicMagic Mix     Everlasting Love - Singles - Love Affair
AddPlay MusicMagic Mix     Hold Me Close - Singles - David Essex
AddPlay MusicMagic Mix     Jin-Go-Lo-Ba - Singles - Santana
AddPlay MusicMagic Mix     Mr. Sky Blue - Singles - Electric Light Orchestra
AddPlay MusicMagic Mix     Mr. Tambourine Man - Singles - The Byrds
AddPlay MusicMagic Mix     Oh, pretty women - Singles - Roy Orbison
AddPlay     The Ole House - Singles - Shakin' Stevens
AddPlay MusicMagic Mix     The Power Of Love - Singles - Jennifer rush
AddPlay MusicMagic Mix     San francisco (Be Sure To Wear Some Flowers In Your
Hair) - Singles - Scott McKenzie
AddPlay MusicMagic Mix     Stand And Deliver - Singles - Adam And The Ants
AddPlay MusicMagic Mix     Time After Time - Singles - Cyndi Lauper
AddPlay MusicMagic Mix     Total Eclipse Of The Heart - Singles - Bonnie Tyler
AddPlay MusicMagic Mix     Two Out Of Three Ain't Bad - Singles - Meat Loaf
AddPlay MusicMagic Mix     When Will I See You Again - Singles - The Three Degrees
AddPlay MusicMagic Mix     Wherever I lay My Hat (That's My Home) - Singles -
Paul Young
Comment 1 Dan Sully 2005-09-27 15:41:51 UTC
John - can you tag all of those tracks with the 'compilation' bit?
Comment 2 John Gorst 2005-09-28 12:24:10 UTC
what do you mean 'compilation bit' - I think I am missing something here!
Comment 3 Dan Sully 2005-09-28 12:26:25 UTC
What tag editor do you use?
Comment 4 John Gorst 2005-09-28 14:04:05 UTC
EasyTAG linux or Tagscanner windows.

Happy to use any reccomended others.
Comment 5 Dan Sully 2005-09-30 16:47:26 UTC
I'm not sure if any of those will do it - Tag & Rename might, but I haven't checked.

Using the 'metaflac' executable on the command line though, you can do:

metaflac --set-vc-field="COMPILATION=1" *.flac 

on your Singles directory.
Comment 6 Jim McAtee 2005-09-30 17:11:08 UTC
I thought he said these were mp3 files, so is there an ID3 equivalent to the 
vorbis COMPILATION tag?

Is the setting of tag COMPILATION=1 equivalent to setting ABLUMARTIST=Various 
Artists?
Comment 7 Dan Sully 2005-09-30 17:13:20 UTC
The MP3 equiv is TCMP - which iTunes created, but other programs use. Tag & Rename should do it, as 
will Media Rage & foobar2000.

Setting COMPILATION is slightly more dynamic than an explit ALBUMARTIST tag. And for some, like MP3s, 
it's really the only option.
Comment 8 John Gorst 2005-10-09 04:03:39 UTC
Just to get this straight (currently away from the server so cant try it out
easily)....

Should I tag all my 'single' MP3's with the TCMP=1 or compilation=1 or
albumartist=Various Artists?

I have a few flac 'singles' and I should tag that with compilation=1?

Cheers
Comment 9 Dan Sully 2005-10-09 10:31:00 UTC
You should tag your MP3s with TCMP=1, and FLACs with COMPILATION=1
Comment 10 John Gorst 2005-10-11 10:42:12 UTC
Adding TCMP=1 to my mp3 'single' files using Foobar2000 has made no difference
to the problem.

Using 26/9 nightly, stopped service and deleted sql file and restarted to ensure
this made no difference.

Any ideas?

Comment 11 Dan Sully 2005-10-11 10:46:44 UTC
John - can you attach your .db file?

Thanks.
Comment 12 John Gorst 2005-10-11 12:03:30 UTC
Created attachment 899 [details]
Database file
Comment 13 Dan Sully 2005-10-12 14:07:40 UTC
John - can you also add 'Singles' to the 'Common Album Titles' pref in Settings -> Behavior?

Then wipe & rescan.
Comment 14 Dan Sully 2005-10-15 00:22:55 UTC
John - can you also upload two of the files in question? I just tested this on my end, and it should work.

Thanks.
Comment 15 John Gorst 2005-10-15 02:32:33 UTC
Adding "singles" to my 'common album titles' preferences did not solve the problem. 

However I selected the tick box next to "Specifiy a list of Common Album Titles"
at the same time. This solved the smae problem thich was happening to "singles
not tested" album.

When I removed "singles" fromt he 'command album types' list all was resolved.

To complicate matters I had also upgraded to the 13/10/5 nightly.

The only problem is that they are being listed not under 'by various artists'
but 'by rooster' (even though there is only one rooster song from over 600 singles).

I wll try deselected the tick box next to "Specifiy a list of Common Album
Titles" and rescanning and see what happens!
Comment 16 John Gorst 2005-10-15 03:51:52 UTC
I can confirm that when I deselected the tick box next to "Specifiy a list of
Common Album Titles" and performed a full rescan that I again had many entries
for 'singles'

What is the default setting for this? I dont think I have changed it. Should it
be ticked by default in future versions?

Comment 17 Dan Sully 2005-10-15 11:08:56 UTC
John - the logic is structured as such that having the Compilation tag set should override any common 
album titles setting. Could you upload two of the files in question, so I can make sure their tags are 
correct?

The logic for building a query to find an existing album or create a new album is this:


# If we have a compilation bit set - use that instead
# of trying to match on the artist. Having the
# compilation bit means that this is 99% of the time a
# Various Artist album, so a contributor match would fail.
if (track is a compilation)

        searchParams->compilation = 1

} else {

# Check if the album name is one of the "common album names"
 # we've identified in prefs. If so, we require a match on
# both album name and primary artist name.

      if ((checkCommonAlbumTitles AND album IN commonAlbumTitles) OR NOT 
checkCommonAlbumTitles) {
                                
               searchParams->contributor = contributorName
       }
}

So you can see that having a COMPILATION bit set will cause the search to execute only on the title, and 
not on the artist.
Comment 18 John Gorst 2005-10-15 11:16:46 UTC
2 affected files sent to dan off list


Comment 19 Dan Sully 2005-10-15 12:12:08 UTC
John - these files have a TCMP flag - but they are only ID3v1 !

Use a tagging program and convert / copy the ID3v1 tags to v2 tags - and add the Compilation flag via 
Tag & Rename, iTunes or something else.
Comment 20 Dan Sully 2005-10-27 20:38:30 UTC
I've checked in a fix as subversion change 4893 - which will be in the 10-28-2005 nightlies.

Please give that a try.

Thanks.