<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Yes. You are correct. Thanks for the clarification Klaas.<br>
</p>
<div class="moz-cite-prefix">On 7/10/2021 1:40 AM, Klaas de Waal
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANcAQaOjz2BRKNzxzpKC869RXmVJ0pDGj-ca6cXn9wgPDh=ZkQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sat, 10 Jul 2021 at
08:34, Scott Simpson <<a
href="mailto:scottsimpson1240@comcast.net"
moz-do-not-send="true">scottsimpson1240@comcast.net</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">I killed mythfilldatabase
and now I have multiple entries for each <br>
channel in my "channel" table in SQL. The only difference
seems to be <br>
the chanid. How can I delete these multiple entries? I
probably just <br>
want to start over. I went to mythtv-setup and deleted my
video source <br>
and re-added it and that didn't solve the problem.<br>
<br>
</blockquote>
<div>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. </div>
<div>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.<br>
</div>
<div>This is done so that you still have the channel
information when you play a recording from a channel that
does not exist anymore.</div>
<div>
<div>FYI, look at the field "deleted" and when that has a
date/time then the channel will be deleted in due course.</div>
<br class="gmail-Apple-interchange-newline">
</div>
<div>Hope this helps,</div>
<div>Klaas.</div>
<div><br>
</div>
<div><br>
</div>
<div> </div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
</body>
</html>