[mythtv-users] Manually delete db entries for live tv

[Brad DerManouelian]

On Nov 6, 2008, at 12:19 PM, mythtv at blandford.net wrote:

> Aaron Klein wrote:
>> I have two shows that are in the DB's live tv group.  The system is
>> trying to expire and delete the two shows but is unable to because  
>> the
>> actual files no longer exist.  It looks like the only way I can keep
>> the system from trying to expire them is to remove the entries from
>> the DB.  What would be the SQL syntax to delete the two entries from
>> the live tv group?
>
>
> Try running myth.find_orphans.pl.  It is in the contrib directory.
>
> It will clean up your DB for you.

Even better, touch <filename> and let expire do it's job. No messing  
with the database directly.