Posts: 5
Joined: Sep 2019
Reputation:
0
When I delete a TV Show (ie All Files & Folders related to the TV Show) and run a database CleanUp,
The TV Show remains in the Library as Empty TVShow
When skin is setup for displaying empty tvShow, i see deleted ones.
When i look in the database with a sqlite browser, i can see that all deleted tvShows remain in Library.
Please fix it
or
Give a sqlite statement to make a real clean
Posts: 20,235
Joined: Apr 2017
Reputation:
1,343
or just highlight the row and press Delete
Posts: 5
Joined: Sep 2019
Reputation:
0
Sorry but deleting some rows in the tvshow table wont be enough.
There are a lot of references to an episode in the library database (files, paths, season, rating, views, bookmark, and more...)
Was wondering that someone already have done the job...
Posts: 12,461
Joined: Oct 2014
Reputation:
601
And in the meantime this is why there are a few database clean-up addons listed in the addons section here (mainly the program addons one iirc).
But you won't find them in the official repo, as they have to connect to the database directly and addons which do that are not allowed in the official repo.
Posts: 5
Joined: Sep 2019
Reputation:
0
Deleting a line from tvshow table did some trick :
1. delete record(s) of the obsolete TvShow(s) in the tvshow table
2. run a 'Library Cleanup'
3. No more obsolete TvShow in GUI
(Im working on a SQLite query that will remove records in the tvshow table for which no related video file is found, in case of success, ill post it there)
Posts: 20,235
Joined: Apr 2017
Reputation:
1,343
2019-11-11, 08:26
(This post was last modified: 2019-11-11, 08:29 by Karellen.)
Why did you go to all that effort when in the TV Show listing you could just press Delete from a keyboard or from the Context Menu if using a remote control?