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

Aaron Klein klein.aaron at gmail.com
Fri Nov 7 01:09:51 UTC 2008

On Thu, Nov 6, 2008 at 7:58 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> 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
Thanks  always more than 1 way to skin a cat.

More information about the mythtv-users mailing list