dcol 165 Posted October 30, 2018 Share Posted October 30, 2018 Thanks, I will look at these options tmw Link to comment Share on other sites More sharing options...
dcol 165 Posted November 1, 2018 Share Posted November 1, 2018 Genre Cleaner did not remove the duplicate Genres. They were in the Genre Cleaner settings, and I deleted it from there. Now it is gone from the Genre Cleaner list, but still remains in the actual Genre page. Tried restarting the server, no change. Guess I need to repair the DB after all. Link to comment Share on other sites More sharing options...
dcol 165 Posted November 1, 2018 Share Posted November 1, 2018 So I installed SQLiteDatabaseBrowserPortable and I opened Library.db Can't find where the Genres are located. The Item ID's are not unreadable. Not even sure if library.db is the correct place to look. What table would I find the Genre's in and then what steps do I take to apply the change? If I just delete the Library.db, will Emby recreate it? Link to comment Share on other sites More sharing options...
dcol 165 Posted November 1, 2018 Share Posted November 1, 2018 I stopped Emby server, renamed the library.db to library.old, restarted the server and re-scanned the library. Not only did that rebuild the library and fix the duplicates, but the library.db went from 450MB to 19MB and sped up Emby. Shouldn't there be a way to schedule a library.db cleaning? Or is there a plugin for that? Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted November 1, 2018 Share Posted November 1, 2018 (edited) What version of the Emby server are you using? As you say the ID are not readable i guess you are on the Stable Server If you delete the library.db it will be recreated on startup (although you may lose some of your metadata customisation) - although this may not solve your problem as the lowercase genre may be embedded in a video file and/or in an nfo (if you use them) and the library scan may pick it up again Although the newer versions of the Stable server have changes in place to prevent this problem now - as its a long time since i have seen a lowercase genre being picked up. [edit] Good you solved it Edited November 1, 2018 by PenkethBoy Link to comment Share on other sites More sharing options...
Happy2Play 8319 Posted November 1, 2018 Share Posted November 1, 2018 (edited) I stopped Emby server, renamed the library.db to library.old, restarted the server and re-scanned the library. Not only did that rebuild the library and fix the duplicates, but the library.db went from 450MB to 19MB and sped up Emby. Shouldn't there be a way to schedule a library.db cleaning? Or is there a plugin for that? Of course a new database will be smaller and will grow over the next day or so. Did you restore any userdata, since you deleted it also? Edited November 1, 2018 by Happy2Play Link to comment Share on other sites More sharing options...
Gilgamesh_48 944 Posted November 1, 2018 Share Posted November 1, 2018 Genre Cleaner did not remove the duplicate Genres. They were in the Genre Cleaner settings, and I deleted it from there. Now it is gone from the Genre Cleaner list, but still remains in the actual Genre page. Tried restarting the server, no change. Guess I need to repair the DB after all. Just want to say that the better way to handle this using Genre Cleaner would be not to delete the unwanted entry but rather to map the unwanted entry to the wanted one. This allows Emby to be as initially "wrong" as it wants to be but fixes it later. Also I think that the delete only happens on the next full library refresh so that simply deleting a genre will have no effect at all until the library fully refreshes. After a full refresh the deleted genre may well be gone. 1 Link to comment Share on other sites More sharing options...
dcol 165 Posted November 1, 2018 Share Posted November 1, 2018 I did not restore the userdata. Really don't have any and made very few changes to the metadata except for some images. Didn't know I could combine genres in the cleaner. Rebuiding the DB did remove the duplicate Genres Link to comment Share on other sites More sharing options...
nomatches4mikey 8 Posted December 14, 2018 Share Posted December 14, 2018 Finally got this resolved on my server. I had a lot of older library entries with media.xml files. I deleted all the xml files, then edited the library database to remove the genres starting with lower case (after shutting down Emby Server and making a backup, of course.) Then restarted server and performed a full library scan. Now the extra genres are gone. Link to comment Share on other sites More sharing options...
Luke 37133 Posted December 14, 2018 Share Posted December 14, 2018 Thanks for the feedback. Newer releases of Emby Server are better at preventing this from happening, though they won't necessarily clean up older existing duplicates for you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now