[mythtv-users] database recorded table question

Nick knowledgejunkie at gmail.com
Mon Oct 10 19:49:31 UTC 2005


On 10/10/05, Neale Swinnerton <mythtv-users.spam at isismanor.com> wrote:
>
> Hi,
>
> I seem to have some erroneous data in my recorded table. I have 3 rows
> where progstart and progend are set to '0000-00-00 00:00:00'. These show
> up in the recorded program view but can't be deleted - if I delete them
> they disappear from the display, but are still there when I exit recorded
> programs and go back in
>
> I'm going to delete them manually with a
>
> delete from recorded where progend='0000-00-00 00:00:00'
>
> can anyone see any problem with that?

No, but I'd still suggest you take a backup of the DB just in case.

Nick


More information about the mythtv-users mailing list