Removing missing genres from DB

Need help? Post your questions here.
skopo
Contributor
Contributor
Posts: 68
Joined: 07 Apr 2013, 07:48
Has thanked: 8 times
Been thanked: 16 times

Removing missing genres from DB

Unread post by skopo »

Is there a way to remove genres that doesn't have any song in library from the database?

example I have genre "15" that is empty.
User avatar
DoCC
Contributor
Contributor
Posts: 211
Joined: 25 Feb 2014, 14:41
Has thanked: 40 times
Been thanked: 65 times

Re: Removing missing genres from DB

Unread post by DoCC »

stop madsonic
go to your db directory
open madsonic.script

scroll down or search for stuff like

Code: Select all

INSERT INTO GENRE VALUES('',309,48,11)
If there is any genre not needed kick the entire line out of the file ... .
then start madsonic again

!! keep in mind, do a backup of this file when messing around in it !!
These users thanked the author DoCC for the post:
skopo
Rating: 7.69%
Post Reply