Bugzilla – Bug 2662
Empty genres when browsing
Last modified: 2008-09-15 14:39:24 UTC
I have a couple of empty genres that show up on my slimserver after scanning, including one called "Black Metal". I don't have any songs that are in that genre, nor does the slimserver show any songs within. Nonetheless it keeps showing up when browsing by genre. Please let me know if there's any additional information I can provide, such as a log file somewhere or the like. Thanks!
Please attach a zipped copy of your slimserversql.db file to this bug. Thanks
Created attachment 1061 [details] slimserversql.db
Looks like these files have that Genre set: file:///D:/music/The%20Timelords/Doctorin%27%20The%20Tardis/02%20Doctorin%27%20The20Tardis.mp3 file:///D:/music/The%20Timelords/Doctorin%27%20The%20Tardis/04%20Gary%20In%20The%20Tardis.mp3 file:///D:/music/The%20Timelords/Doctorin%27%20The%20Tardis/05%20Doctorin%27%20The%20Tardis.mp3 More Electronica than Black Metal, I would think. :)
Heh. Yes, "Black Metal" doesn't seem quite right. Looking directly at the mp3 files themselves, the genre is blank for the v2 tag, and "Black Metal" for only the v1 tag. I had no idea. I guess iTunes only edits the v2 tag, rather than the v1, and the slimserver must default to v1 if the v2 is blank? Also, the genre is still empty in the slimserver when I view it -- The Timelords don't show up. Any ideas? I'd like to remove the genre altogether, but I'll wait until I hear back in case there's more info you need on the bug. Lastly, how did you figure out that those were the files in question? I also have an empty genre called "Other" but I'm not sure how to find the files that I assume have incorrect genres listed in their v1 tags. Thanks for looking at this!
Ok - Fixed in change 5335 & change 5337 This is in the 6.5 nightlies right now - it may make it into the 6.2.x branch. To figure it out - I ran the following queries on the SQLite database: sqlite3 ~/Desktop/slimserversql.db "select id from genres where name = 'Black Metal'" (returns 22) sqlite3 ~/Desktop/slimserversql.db "select track from genre_track where genre = 22" (returns 10490,10491,10492) sqlite3 ~/Desktop/slimserversql.db "select id,url from tracks where id in (10490,10491,10492)"
Thanks, Dan! I tried to verify the fix using last night's 6.5 build, but I'm getting a 403 when I try to download it from: http://www.slimdevices.com/downloads/nightly/latest/6.5/ Is there a different URL I should be using? Thanks.
Subject: Re: Empty genres when browsing That's the URL - I'm fixing the link right now.
Verified fixed with the 2005-12-02 build. Thanks!