PDA

View Full Version : How do I delete an empty Genre?



mikelis
2005-11-26, 13:23
I spelled a genre wrong and now want it to no longer appear in my browse genre listing. there is nothing assigned to the genre anymore but it still appears.

Mark Lanctot
2005-11-26, 14:31
Did you rescan?

Select "Clear library and rescan everything" to be
sure.

--- mikelis
<mikelis.1z4f3n (AT) no-mx (DOT) forums.slimdevices.com> wrote:

>
> I spelled a genre wrong and now want it to no longer
> appear in my browse
> genre listing. there is nothing assigned to the
> genre anymore but it
> still appears.
>
>
> --
> mikelis
>
------------------------------------------------------------------------
> mikelis's Profile:
> http://forums.slimdevices.com/member.php?userid=1084
> View this thread:
> http://forums.slimdevices.com/showthread.php?t=18548
>
>

mikelis
2005-11-26, 15:08
Yes, i even deleted the .db database file. it still shows up.

Jim
2005-11-26, 16:15
First thing worth checking is before you rescan make sure you have a empty playlist - maybe it gets the old value from there and is a bug?

OK, so your playlist is empty, you've deleted the DB and rescanned and it's still there.....

The it must still be assigned to something, it cannot possibly appear out of thin air. This also means you are missing a song from your lists, and that song is using this genre - which is why if you say you have cleared the DB and it is still appearing that you think the genre is empty as you obviously don't see the song(s).

If you have a SQL client one way to find out would be......



select id, rtrim(name) from genres order by name;


Find the id for the genre you don't want (in this list). You don't actually have to do this and could just do a Browse Genres on the webinterface and see what id number the link has - e.g.

hxxp://localhost:9000/browsedb.html?hierarchy=genre,artist,album,track&level=1&genre=14&player=....

Now find the song(s) with that genre (why it/they don't appear in the genre list I don't know - this is another issue).



select rtrim(tracks.url) from tracks
left join genre_track on tracks.id = genre_track.track
where genre_track.genre = 14 (Your genre's id)

mikelis
2005-11-26, 16:58
found the problem-i still had two files that contained only the mispelled genre with no other artist, album, etc info in them so nothing showed up when i did a browse genre.

mikelis
2005-11-26, 17:11
BTW Jim, Thanks for the helpful SQL code snippets. I'm going to save them for future use.

james

Jim
2005-11-26, 17:13
found the problem-i still had two files that contained only the mispelled genre with no other artist, album, etc info in them so nothing showed up when i did a browse genre.
I would say that's a bug - it should of at least listed them as "No Artist" and then "No Album" when your browsed into the unwanted genre.

I know it's fixed but will help others to report it.