[mythtv-users] Have duplicate channel entries in channel table

Klaas de Waal klaas.de.waal at gmail.com
Sat Jul 10 08:40:19 UTC 2021

On Sat, 10 Jul 2021 at 08:34, Scott Simpson <scottsimpson1240 at comcast.net>

> I killed mythfilldatabase and now I have multiple entries for each
> channel in my "channel" table in SQL. The only difference seems to be
> the chanid. How can I delete these multiple entries? I probably just
> want to start over. I went to mythtv-setup and deleted my video source
> and re-added it and that didn't solve the problem.
> I think that you do not have a problem. After deleting and re-adding the
video source you should be OK. Only channels that are attached to a video
source are used.
The reason that you see the old channels still being present in the channel
table is that they are not deleted immediately but they are marked for
deletion. The channels that are marked for deletion are deleted later by a
housekeeping task when there are no recordings anymore that have been
recorded from that channel.
This is done so that you still have the channel information when you play a
recording from a channel that does not exist anymore.
FYI, look at the field "deleted" and when that has a date/time then the
channel will be deleted in due course.

Hope this helps,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210710/75f3ecd5/attachment.htm>

More information about the mythtv-users mailing list