Removing missing genres from DB

Need help? Post your questions here.

Removing missing genres from DB

Unread postby skopo » 16 Oct 2014, 14:05

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.
skopo
Contributor
Contributor
 
Posts: 69
Joined: 07 Apr 2013, 07:48
Has thanked: 11 times
Been thanked: 20 times

Re: Removing missing genres from DB

Unread postby DoCC » 16 Oct 2014, 15:46

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 !!
User avatar
DoCC
Contributor
Contributor
 
Posts: 210
Joined: 25 Feb 2014, 14:41
Location: UpperBavaria : ))
Has thanked: 41 times
Been thanked: 71 times


Return to Support 5.x

Who is online

Users browsing this forum: No registered users and 1 guest

cron