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

[mythtv at blandford.net]

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.

Michael