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

[Michael T. Dean]

On 11/06/2008 05:04 PM, Brad DerManouelian wrote:
> On Nov 6, 2008, at 12:19 PM, someone 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.
>   
Even even better, go to the Watch Recordings screen, use M to change the
filter to show LiveTV recordings, then go to the LiveTV recording you
want to delete, then select it and use I to get the Action Popup.  It
should display a popup allowing you to "Show Details" or "Delete". 
Choose "Delete," then confirm that you want to delete it even though the
file is gone.

Mike