[mythtv-users] Deleted files: Pruning/updating the database
lanas at securenet.net
Wed Jun 25 01:53:10 UTC 2008
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:
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 ?
More information about the mythtv-users