Bug 2456 - Multiple artist sorting broken
: Multiple artist sorting broken
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.2.1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-11-01 01:05 UTC by Philip Meyer
Modified: 2008-09-15 14:37 UTC (History)
2 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Philip Meyer 2005-11-01 01:05:43 UTC
I have a track that has tags:
  ARTIST="Michael Andrews;Gary Jules"
  ARTISTSORT="Andrews, Michael;Jules, Gary"

"Michael Andrews" is correctly sorted when browsing artists, but I notice 
that "Gary Jules" appears just above Michael Andrews, instead of sorted 
under "J".
Comment 1 Philip Meyer 2005-11-01 01:41:44 UTC
My "Articles To Ignore When Sorting" includes "The", but this is not being 
ignored in artist or album names.
Comment 2 Dan Sully 2005-11-03 13:42:57 UTC
Phil - can you upload a zipped copy of your slimserversql.db to this bug?

Also - what is your split character set to? is it ";" ?
Comment 3 Dan Sully 2005-11-03 13:46:32 UTC
*** Bug 2477 has been marked as a duplicate of this bug. ***
Comment 4 Philip Meyer 2005-11-03 15:06:53 UTC
I just did a full rescan with the latest trunk, and now the artists Michael 
Andrews and Gary Jules are not listed under "Browse Artists" - I can't see 
them anywhere, ie not sorted under M, A, G or J.

This track doesn't have an album tag.

I notice that my artist count is 457.  I think a few days ago this was around 
600.  I have been tidying tags up, correcting typo's, adding more ARTISTSORT 
tags, and some artists have probably dissapeared from the list because of 
detecting more various artist albums, but I was expecting more than 457.

I notice I have a "No Album" in the album list, but I don't have a "No Artist" 
in the artist list.

However, if I do a search for "Michael" or "Gary", it finds the track in 
question, listing it as "Mad World by Michael Andrews, Gary Jules".  If I 
display the song info for the track, it then displays the artists as "Gary 
Jules, Michael Andrews".  Note that the order of the artists has changed.

I'm assuming that in one case it has sorted by ARTISTSORT tag, and in the 
other case it has sorted by ARTIST tag.  I'd actually prefer it if it didn't 
sort by either of those tags, but listed the artists in the order they were 
entered in the file tags.  A song by "Fripp & Eno" would look rather wrong if 
it was listed as "Eno, Fripp" as another example.

Also note that if I search for "Andrews" or "Jules", it doesn't find the 
track.  My Search option is currently set to "Search Beginning of Words" - I'd 
expect the artist to be found by either first or last name, as they are words?


Back to the original problem(s)... :)

My artist separator is semi-colon, which I have started to use in my tags.  
Where I have multiple artists with ARTISTSORT tags, I have used the same 
number of divider characters in both ARTIST and ARTISTSORT tags to associate 
the two entries.  eg:

  ARTIST="Michael Andrews;Gary Jules"
  ARTISTSORT="Andrews, Michael;Jules, Gary"

The sorting problem for "The" article still remains.

I will zip my slimserversql.db and email to you - prefer to do that rather 
than make my music habbits visible to the world!
Comment 5 Dan Sully 2005-11-03 18:56:52 UTC
Fixed in change 5023 and change 5024 for the 6.2.1 branch.