[slim] Re: How do I delete an empty Genre?
mikelis Wrote: > 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. -- Jim Jim's Profile: http://forums.slimdevices.com/member.php?userid=213 View this thread: http://forums.slimdevices.com/showthread.php?t=18548 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: How do I delete an empty Genre?
BTW Jim, Thanks for the helpful SQL code snippets. I'm going to save them for future use. james -- mikelis mikelis's Profile: http://forums.slimdevices.com/member.php?userid=1084 View this thread: http://forums.slimdevices.com/showthread.php?t=18548 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: How do I delete an empty Genre?
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 mikelis's Profile: http://forums.slimdevices.com/member.php?userid=1084 View this thread: http://forums.slimdevices.com/showthread.php?t=18548 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: How do I delete an empty Genre?
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.. Code: 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). Code: 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) -- Jim Jim's Profile: http://forums.slimdevices.com/member.php?userid=213 View this thread: http://forums.slimdevices.com/showthread.php?t=18548 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: How do I delete an empty Genre?
Yes, i even deleted the .db database file. it still shows up. -- mikelis mikelis's Profile: http://forums.slimdevices.com/member.php?userid=1084 View this thread: http://forums.slimdevices.com/showthread.php?t=18548 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
