[mythtv-users] Manually delete db entries for live tv
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
>>>> 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.
Thanks always more than 1 way to skin a cat.
More information about the mythtv-users