Page 1 of 1

Removing missing genres from DB

Posted: 16 Oct 2014, 14:05
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.

Re: Removing missing genres from DB

Posted: 16 Oct 2014, 15:46
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 !!