<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">On Dec 9, 2020, at 9:58 AM, David Watkins <<a href="mailto:watkinshome@gmail.com" class="">watkinshome@gmail.com</a>> wrote:<br class=""><div><blockquote type="cite" class=""><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><br class=""></div><br class=""><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br class=""><br class="">
I don't think the actual page has ever been mentioned. I'd assume it's:<br class="">
<br class="">
<a href="http://somehostname/mythweb/tv/list" rel="noreferrer" target="_blank" class="">http://somehostname/mythweb/tv/list</a><br class="">
<br class="">
or wherever the mythweb is installed.<br class="">
<br class="">
See if <a href="http://somehostname/mythweb/settings/tv/channels" rel="noreferrer" target="_blank" class="">http://somehostname/mythweb/settings/tv/channels</a> page show the<br class="">
channels of interest.<br class=""></blockquote><div class=""><br class=""></div><div class="">It does. In fact it shows them twice. The affected channels appear to be those where I have a second 'zombie' entry for a source that I have deleted.</div><div class=""><br class=""></div><div class=""><span id="cid:ii_kihlat100"><image.png></span><br class=""></div><div class=""><br class=""></div><div class="">sourceid 1 was for my DVB-T capture card.</div><div class="">sourceid 2 was for my DVB-T2 capture card and contained all the same channels as sourceid 1, plus the HD ones.</div><div class=""><br class=""></div><div class="">I deleted sourceid 1 using mythtv-setup a while ago when I got rid of my DVB-T card, but about 8 of its channels (out of 150 or so) have remained in the database. I've been wondering whether to delete them by hand?</div><div class=""><br class=""></div><div class="">mythweb is not showing guide data for any of these channels which still exist on sourceid 2. frontends and frontend web show guide data correctly and the backend can schedule and make recordings from them.</div><div class=""> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br class="">
Would expect an empty response from this:<br class="">
<br class="">
mysql --user=mythtv --password=<from config.xml> --host=localhost --execute="SELECT chanid,channum,callsign,visible FROM channel WHERE visible<br class="">
NOT IN (0, 1)" mythconverg<br class="">
<br class=""><br class=""></blockquote><div class="">I get an empty response from that.</div><div class=""><br class=""></div><div class=""> </div></div></div>
_______________________________________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users<br class="">http://wiki.mythtv.org/Mailing_List_etiquette<br class="">MythTV Forums: https://forum.mythtv.org<br class=""></div></blockquote><br class=""></div><div>I had a similar issue recently when I migrated from dd to xmltv. Looking at the ‘channel’ table in the database, I noticed that the deleted channels were still there, but the ‘deleted’ column now had a date. It seems like mythweb pays no attention to this column, which causes confusion with listings and scheduling recordings. I suppose the proper fix would be to update mythweb to not select deleted channels. But instead I just used sql to remove the deleted channels from the channel table. The only negative side-effect I’ve noticed from this is all my old recordings no longer indicate the channel they were recorded on. This is probably because the ‘chanid’ no longer exists in the database (I also replaced my sources in this migration, so the ’same’ channels would have a different chanid).</div><div><br class=""></div><br class=""></body></html>