chef 3745 Posted November 19, 2019 Share Posted November 19, 2019 Currently, in many different parts of emby I am experiencing a repeating of database items. In my devices tab, but also under auto organize in my series tab I have lots and lots of repeating series names which are not in my actual library. I'd like to remove these by editing the db files directly. I am on windows, but I can't seem to find a good editor online. I need to remove rows from the db files and clean them up. Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted November 19, 2019 Share Posted November 19, 2019 DB Browser for sqlite - works well 1 Link to comment Share on other sites More sharing options...
chef 3745 Posted November 19, 2019 Author Share Posted November 19, 2019 DB Browser for sqlite - works well I actually just tried that application, but I get an error when I try to remove rows in the table. Something about a foreign key error. Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted November 19, 2019 Share Posted November 19, 2019 yes thats because the row you are trying to delete - is linked(foreign Key) to one or more other tables in the db - its the way Emby db is setup (normal db stuff) and not something the editor can "know" about so you need to find which tables those are by checking which have linked iD's e.g. in mediaItems take the id value of say a Movie and look for the same id in Chapters3, Mediastreams2 etc etc - can be several diff tables delete from these tables the row or rows with the same id and repeat until you have removed all the foreign keys for each "other" table - THEN - you can delete the movie record from the MediaItems table 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