Bug 1346 - Duplicate genre entries when accented characters are involved
: Duplicate genre entries when accented characters are involved
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.0.1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-04-09 23:56 UTC by narya
Modified: 2008-08-18 10:54 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description narya 2005-04-09 23:56:06 UTC
When using "Browse Genres" (both in the Web UI or using the Squeezebox) I get 
a duplicate entry for every genre that has an accented character (like �, �, 
�, �, �, � ...) in its name.

One of these entries will always contain every song, with at least one 
accented character in either its name or the name of the corresponding album 
or artist. 

The second entry always contains all songs with _no_ accented characters at 
all in the artist's, the album's or the song's name. (In the rare case, where 
a genre contains only one artist, which in turn has an accented character in 
its name, I consequently get only _one_ entry, because the second will be 
empty.)

It is interesting to note, that only the instance containing all the accented-
character-songs will be sorted correctly. The other instance (containing 
the "non-accented" songs) will be placed somewhere before. For 
example "K�lsch" wrongly between "Kammermusik" and "Kinder" and "S�damerika" 
wrongly between "Rock&Roll" and "Skandinavien". (Yes, that's all German.)

It seems as if the o umlaut and u umlaut in these examples are "coded" and 
thus sorted differently.

BTW: I don't see any double entries in "Browse Albums" or "Browse Artists", 
even where accented characters are involved! So the genre seems to be treated 
differently ...


I already stopped slimserver, deleted the slimserversql.db, started 
slimserver, let it finish the initial scan (takes about two hours!), and 
finally restarted the server again, just to make sure - the problem persists.

Thanks,
Alexander.

--

SlimServer Version: 6.0.1 - 2895 (4/8 nightly)
Windows XP, SP2
iTunes 4.7.1.30 as database source
nearly 22,000 songs
Comment 1 narya 2005-04-09 23:57:53 UTC
Uh, I hope those umlauts will look right for the non-European users here ... 
try "Western Europe" as encoding - sorry!
Comment 2 narya 2005-04-10 00:05:59 UTC
I just noticed that this only seems to happen with mp3 files (which are all 
tagged with ID3 v2.3 BTW) and not with my AAC files.

I ripped all my audiobooks in AAC with iTunes and gave them "H�rbuch" (with o 
umlaut) as genre. This genre does _not_ get a duplicate entry, just because 
all files with this genre are AAC files!
Comment 3 KDF 2005-04-10 00:15:07 UTC
try this as well:
https://bugs-archive.lyrion.org/show_bug.cgi?id=1315#c3
Comment 4 narya 2005-04-10 02:39:44 UTC
Thanks for the tip, KDF. I believe you're refering to:

> can you stop the server, remove the slimserversql.db file, and start the
server up again? Once it's done scanning, do a rescan.

As I said I had already stopped the server, deleted the database file and 
started the server again. Now I did an additional "Rescan" after slimserver 
finished its initial scan - to no avail. I still have the same duplicate genre 
entries.
Comment 5 narya 2005-04-12 04:22:15 UTC
I just installed the latest 04/12 nightly and after rebuilding the database 
the duplicates are gone. Thanks!

Instead now the display on the Squeezebox is "broken" for the genres with 
umlauts. While browsing through my genres with the remote, every umlaut in a 
genre name gets replaced by _two_ strange characters (unicode representation 
or something?) so that the little arrow pointing right at the end of the 
second line now shows up as first character in the first line (replacing 
the "G" from "Genre").

The Web UI is fine in this respect.

Should I file this as a new bug?
Comment 6 narya 2005-04-12 04:37:05 UTC
I just noticed it happens everywhere in the player UI, so I opened bug #1358: 
https://bugs-archive.lyrion.org/show_bug.cgi?id=1358
Comment 7 Dan Sully 2005-04-12 16:48:26 UTC
Could you upload a track with an umlat in the genre?

Thanks.
Comment 8 Dan Sully 2005-04-12 16:49:19 UTC
Closing - refer to bug 1358