[mythtv-users] Have duplicate channel entries in channel table
scottsimpson1240 at comcast.net
Sat Jul 10 08:45:14 UTC 2021
Yes. You are correct. Thanks for the clarification Klaas.
On 7/10/2021 1:40 AM, Klaas de Waal wrote:
> On Sat, 10 Jul 2021 at 08:34, Scott Simpson
> <scottsimpson1240 at comcast.net <mailto: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
> 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,
> mythtv-users mailing list
> mythtv-users at mythtv.org
> MythTV Forums: https://forum.mythtv.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users