[mythtv-users] Fwd: Re: channel4 hd has no eit - cross-eit

[UB40D]

On Sun, 5 Sept 2021 at 10:31, Steve Evans <mythtv-users at gorbag.com> wrote:

>
> Maybe one of them has the deleted field set and is the one with
> an xmltvid value. Try running the query
>
> select serviceid,chanid,channum,sourceid,callsign,deleted,xmltvid from
> channel where callsign like("%Channel 4 HD%") ;
>
>
Aha! Well guessed! This one seems to be hitting paydirt!

 mysql> select serviceid,chanid,channum,sourceid,callsign,deleted,xmltvid
from

    -> channel where callsign like("%Channel 4 HD%") ;

+-----------+--------+---------+----------+--------------+---------------------+-----------------+

| serviceid | chanid | channum | sourceid | callsign     | deleted
    | xmltvid         |

+-----------+--------+---------+----------+--------------+---------------------+-----------------+

|     21200 |  22200 | 21200   |        1 | Channel 4 HD | 2021-04-13
22:25:17 | hd.channel4.com |

|     21200 |  31200 | 21200   |        1 | Channel 4 HD | NULL
    |                 |

+-----------+--------+---------+----------+--------------+---------------------+-----------------+

2 rows in set (0.00 sec)

So what's the proper fix going forward?
I'm guessing: deleting the chanid 22200 line manually from the database (or
perhaps via mythweb) and adding xmltvid hd.channel4.com to the other line?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210905/a0869b6a/attachment.htm>