[mythtv-users] Channel listings for one channel don't show up in mythweb

[David Watkins]

On Wednesday, 9 December 2020, Chris H <hoffchris at gmail.com> wrote:

> On Dec 9, 2020, at 9:58 AM, David Watkins <watkinshome at gmail.com> wrote:
>
>
>
>
>
>>
>> I don't think the actual page has ever been mentioned. I'd assume it's:
>>
>>   http://somehostname/mythweb/tv/list
>>
>> or wherever the mythweb is installed.
>>
>> See if http://somehostname/mythweb/settings/tv/channels page show the
>> channels of interest.
>>
>
> 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.
>
> <image.png>
>
> sourceid 1 was for my DVB-T capture card.
> sourceid 2 was for my DVB-T2 capture card and contained all the same
> channels as sourceid 1, plus the HD ones.
>
> 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?
>
> 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.
>
>
>>
>> Would expect an empty response from this:
>>
>>   mysql --user=mythtv --password=<from config.xml> --host=localhost
>> --execute="SELECT chanid,channum,callsign,visible FROM channel WHERE
>> visible
>> NOT IN (0, 1)" mythconverg
>>
>>
>> I get an empty response from that.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>
> 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).
>

That explains my 8 zombie channels.  They must be the ones I have
recordings from.

If I watch and delete those recordings perhaps the channel's will disappear?

Seems the backend's being quite clever, but mythweb isn't.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201209/82e64976/attachment.htm>