Bugzilla – Bug 1346
Duplicate genre entries when accented characters are involved
Last modified: 2008-08-18 10:54:04 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
Uh, I hope those umlauts will look right for the non-European users here ... try "Western Europe" as encoding - sorry!
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!
try this as well: https://bugs-archive.lyrion.org/show_bug.cgi?id=1315#c3
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.
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?
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
Could you upload a track with an umlat in the genre? Thanks.
Closing - refer to bug 1358