[sufreak]

So I'm looking at MyVideos99 db and I see under the PATH table, there are numerous paths which are no longer valid. But the parent folder is a valid source.

For example:

Code:

/media/TVShows/Glee

Glee is no longer a valid path, but

Code:

/media/TVShows/

still is. So it doesn't seem like any sources are cleaning up the entry in Path/strPath in MyVideos99 to remove idPath.

Is there a plugin/script/guide to doing this that I may have overlooked?

I'd rather not purge my db and start over

[Klojum]

Personally I would write a PHP script that would do a MySQL query that looks for TVshows with zero episodes, and any TVshow without episodes will be deleted.

But I also occasionally do a video library export (using separate files), delete the current video database, and then import my collection again. Just to get rid of all the old/invalid/no-use entries. Exporting and importing takes about 5-6 minutes (MySQL database is on an SSD), so it's not that much trouble.

[sufreak]

But don't you have leftover NFO files? I surmise I could just write some code to keep the ones that existed previously.

I'm curious to the tables that are impacted. I can code the rest