Posts: 3,048
Joined: Aug 2009
Reputation:
153
vbat99
Posting Freak
Posts: 3,048
As someone who experiments a lot with Kodi and Media with nfo files, I have found this to be very frustrating.
MyVideodb file just seems to grow and grow.
Entries are still present in the MyVideos107.db file even after a Clean Library, or if the source path has been fully removed from Kodi.
It seems that all scraped data added to the MyVideo db file is never removed. This is a problem, as new scraped data is not correctly written to the db file.
Case in point, If refreshing a movie in a collection, and the nfo has new Set Overview entry, this is never updated to MyVideo db file.
Playing with 'Database Pre-Wash Scrub' never found any entries that needed to be removed. But it should not be up to a third-party tool to clean up the database, or the Artwork.
Clean Video Library Should take care of removing artwork and database fields from MyVideo and texturecache files. Otherwise, all Clean Library is doing is flagging entries to not be displayed.
For devices with limited storage, over time, this will be a Major issue.
Posts: 97
Joined: Dec 2011
Reputation:
3
I couldn't agree more!
I'd like to see "Clean Library" renamed to "Library Clean(Quick): Hide missing files" and a new "Library Clean(Full): Re-scan all files and clean database".
I can't program it, but I'd be happy to test it.
Posts: 9
Joined: Aug 2008
Reputation:
0
Same problem here
any news?
Posts: 216
Joined: Jun 2010
Reputation:
1
I've noticed this recently as well. I had some shared directories on a local computer that contained media files. I have since deleted that media off that local computer. The shared directories are no longer sources in Kodi, and the library has been cleaned. But once the share is removed from the local computer, the kodi CLEAN LIBRARY function will cause Kodi to hang. I have found that the "Path" table in my MyVideos99.db file contains many references to the old shared directories on the local computer. So currently the only way the I can keep Kodi from hanging up during a CLEAN LIBRARY is to make sure that local PC is on, and the shared directories are still there... even though they no longer have anything in them.
Posts: 280
Joined: Mar 2004
Reputation:
0
Same issue here - I've been playing with MySQL Workbench to figure this out. I really should see if I can fix this but I don't have time right now - I tried to manually (re)move some invalid paths and now a few TV Shows invalid episode counts for some strange reason.
Seems to me that my best option is probably to export the library, drop the DB and then scan the video back in again which shouldn't take too long with the .nfo's created by the export.
Posts: 216
Joined: Jun 2010
Reputation:
1
Since I have all individual NFOs, it would not be difficult to re-import. But wouldn't that mess up all of the "Add Dates?" The family always sorts by a "Add Date" to see what I have newly added.
Either way, if the media is gone and the shares are no longer in existence, I would assume either manually removing the sources from Kodi, or Cleaning the library, would do exactly that - remove all references within databases to no longer existing media files or shares.
Unless there is a reason to keep these database entries around, to me this seems like a bug-
Posts: 97
Joined: Dec 2011
Reputation:
3
What a shame this doesn't have much traction with the Kodi team; it's obviously not an issue for most users.
Posts: 216
Joined: Jun 2010
Reputation:
1
I agree-
While I love Kodi, I find needing to keep empty directories around so Kodi does not crash is a bug....
Call me crazy....
Posts: 216
Joined: Jun 2010
Reputation:
1
2017-07-04, 15:05
(This post was last modified: 2017-07-04, 15:16 by WannaTheater.)
I upgraded to Kodi 17.3. I have not removed my "fake" placeholder shares (which contain no files), so don't know if it corrects the problem. But I am seeing some other interesting things which I assume are related to bad library entries.
1) I search for a known movie name, and it is found, and I can play it. BUT it is not showing up in the list of movies (by title, or year, etc). I tried correcting by deleting directory (which contains .mkv, nfo, fanart, etc), cleaning library, exiting kodi, restarting kodi, recreating the removed directory, then scanning for new media in that directory. The same symptom is exhibited (movie is there, I can search for it, play it, etc., but it does not show up in any movie lists. The only way to fix this is to delete movie, clean library, copy movie back RENAMED, then rescan into movie library.
2) I also somehow have TWO library entries for the same movie. I delete the movie directory, then clean library. Both movie entries disappear from library listings and search. I then put the movie back in the windows directory and rescan. BOTH entries reappear. I believe (and will test later) that if I rename the movie file to something different, it will scan properly and there will only be one entry in MOVIES.
To me it appears that CLEAN library is not effectively (or reliably) removing entries that are no longer available. They are hanging out in the database, and if you rescan something with the same name, it will "reactivate" them.
Posts: 356
Joined: May 2013
Reputation:
23
1) Sounds like you have "hide watched" enabled.
For kodi 17 open up movies library, side menu, if you see an "Unwatched" line press on it until it becomes "All videos".
2) Does that movie's folder contain any other videos? Eg trailer, extras etc.
You can see the path of library items by going to information window and highlighting Refresh button.
