Posts: 110
Joined: Sep 2017
Reputation:
0
Tstrbl
Senior Member
Posts: 110
I scanned a two disc compilation of poorly tagged (didn't know) songs into the Kodi music library; both the artist tage and the title tag were artist-title. I cleaned up the tags and rescanned but the residue of the old artist tags still appears in the library artist view. That is, there is an artist entry but then a separate 'artist' entry with the artists name - song title for each of the songs the artist has in the compilation. So for example, artist X who sings songs A, B, C, and D in the compilation now has five different artist entries in the music library artist view: X, X-A, X-B, X-C, X-D.
I ran clean library several times but hasn't fixed it. Is there any way to resolve this without deleting the folder from file view, recopying, rescanning?
Posts: 4,545
Joined: Jun 2015
Reputation:
269
Are you sure that you did not clean the video library by mistake, it is a common error? To clean the music library you need to scroll down the page.
Posts: 110
Joined: Sep 2017
Reputation:
0
Tstrbl
Senior Member
Posts: 110
Still have not managed to fix this. In fact I've noticed that there are numerous inconsistencies in my library that the 'clean' command does not remove. There are lots of artist entries that are empty and cleaning the library does not remove them. Double entries here and there. What causes the 'clean' command to miss this? Even when I've successfully used the 'clean' command it still takes four or five goes before it removed what I wanted removed.
Do I have to learn how to use SQL to resolve this?
Posts: 110
Joined: Sep 2017
Reputation:
0
Tstrbl
Senior Member
Posts: 110
Deleting and rescanning would be tedious so I decided I'd be better off learning SQL. I went into terminal and just deleted the artist entries manually from the database...seems to have worked. In fact, it was much easier than I expected. If you had to edit a database would you do it manually in terminal like I did or use some kind of SQLite GUI?
Posts: 110
Joined: Sep 2017
Reputation:
0
Tstrbl
Senior Member
Posts: 110
I did something like
delete from artist where idArtist between 1894 and 1920
All of these artists were added at the smae time so the Artist IDs were sequential. Is that what you would have done?
Posts: 110
Joined: Sep 2017
Reputation:
0
Tstrbl
Senior Member
Posts: 110
Oh, OK. I still have a copy of the original MyMusic60.db file which I'm happy to send you. I'd also like to know why the 'clean' process didn't work. Do you need any other files?
What effect should the 'clean' process have on the .db? Does it not also just delete the orhpaned artists? What negative effects might my deletion of those files have on the .db as a whole?