<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, 5 Sept 2021 at 10:31, Steve Evans <<a href="mailto:mythtv-users@gorbag.com">mythtv-users@gorbag.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><br>
Maybe one of them has the deleted field set and is the one with<br>
an xmltvid value. Try running the query<br>
<br>
select serviceid,chanid,channum,sourceid,callsign,deleted,xmltvid from<br>
channel where callsign like("%Channel 4 HD%") ;<br>
<br></blockquote><div><br></div><div>Aha! Well guessed! This one seems to be hitting paydirt!</div><div><br></div><div> <span style="color:rgb(0,0,0);font-family:fixedX6x13;font-size:13px">mysql> select serviceid,chanid,channum,sourceid,callsign,deleted,xmltvid from</span></div>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space">    </span>-> channel where callsign like("%Channel 4 HD%") ;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+---------------------+-----------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| serviceid | chanid | channum | sourceid | callsign <span class="gmail-Apple-converted-space">    </span>| deleted <span class="gmail-Apple-converted-space">            </span>| xmltvid <span class="gmail-Apple-converted-space">        </span>|</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+---------------------+-----------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| <span class="gmail-Apple-converted-space">    </span>21200 |<span class="gmail-Apple-converted-space">  </span>22200 | 21200 <span class="gmail-Apple-converted-space">  </span>|<span class="gmail-Apple-converted-space">        </span>1 | Channel 4 HD | 2021-04-13 22:25:17 | <a href="http://hd.channel4.com">hd.channel4.com</a> |</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| <span class="gmail-Apple-converted-space">    </span>21200 |<span class="gmail-Apple-converted-space">  </span>31200 | 21200 <span class="gmail-Apple-converted-space">  </span>|<span class="gmail-Apple-converted-space">        </span>1 | Channel 4 HD | NULL<span class="gmail-Apple-converted-space">                </span>| <span class="gmail-Apple-converted-space">                </span>|</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+---------------------+-----------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2 rows in set (0.00 sec)</span></p>
<br class="gmail-Apple-interchange-newline"></div><div class="gmail_quote">So what's the proper fix going forward? </div><div class="gmail_quote">I'm guessing: deleting the chanid 22200 line manually from the database (or perhaps via mythweb) and adding xmltvid <a href="http://hd.channel4.com">hd.channel4.com</a> to the other line?</div><div class="gmail_quote"><br></div></div>