[mythtv-users] Deleted files: Pruning/updating the database

[lanas]

Le Mardi, 24 Juin 2008 18:24:31 -0700,
Brad DerManouelian <myth at dermanouelian.com> a écrit :

>>  Some recordings were deleted from /storage/recordings/.  How can I
>> make MythTV realize that these files are not there anymore (they are
>> still showing in the menu) ?

> The obvious (and best) answer is to delete them from the Delete  
> Recordings or Watch Recordings screen. 

That's long.  Pressing each title to see if MythTV finds it, not, then
delete it, then next recording, ...  

> I assume you mean you want an  
> automated way to go through the database and "find" your "orphaned"  
> files in which case you could use
> http://www.mythtv.org/wiki/index.php/Myth.find_orphans.pl which is in
> your contrib directory.

MythDora4 which I use do not seem to have that file.  A find on / did
not return anything.  I found a copy somewhere:
http://horche.net/mythtvdoc/examples/?C=M;O=A

but the Perl script complains:

DBD::mysql::st execute failed: Table 'mythconverg.storagegroup' doesn't exist at ./myth.find_orphans.pl line 251.
Could not execute () at ./myth.find_orphans.pl line 251.

Since all other defaults are OK, I'm a bit worried about forcing it to
use the database (if I knew where the db file is located, that is) as
I'd rather take the long way than ending up with a corrupted db.

Any other automated solution ?

Thanks.