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

[Steve Evans]

On Sun, 5 Sep 2021 10:14:11 +0100
UB40D via mythtv-users <mythtv-users at mythtv.org> wrote:

> On Sun, 5 Sept 2021 at 09:23, John <jksjdevelop at gmail.com> wrote:
> 
> 
> In any case, your query gives the following on my system right now:
> 
> mysql> select serviceid,chanid,channum,sourceid,callsign from channel
> mysql> where  
> callsign like("%Channel 4 HD%") ;
> 
> +-----------+--------+---------+----------+--------------+
> 
> | serviceid | chanid | channum | sourceid | callsign     |
> 
> +-----------+--------+---------+----------+--------------+
> 
> |     21200 |  22200 | 21200   |        1 | Channel 4 HD |
> 
> |     21200 |  31200 | 21200   |        1 | Channel 4 HD |
> 
> +-----------+--------+---------+----------+--------------+
> 
> 2 rows in set (0.01 sec)
> 
> I am not sure why I get two. Maybe a relic of multiple scans? No clue
> which is the "correct" one (if either is).
> 
> 

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%") ;

Steve
-- 
____________________________________________________________________
Steve Evans            E-mail: mailto:stevee at gorbag.com
Registered Linux user #217906: http://counter.li.org
Public Encryption Key:         http://www.gorbag.com/public-key.html
____________________________________________________________________

5.10.61-gentoo Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz GNU/Linux

 10:24:26 up 4 days, 23:00,  5 users,  load average: 0.29, 0.10, 0.08

Whether weary or unweary, O man, do not rest,
Do not cease your single-handed struggle.
Go on, do not rest.
		-- An old Gujarati hymn
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210905/4921f41d/attachment.sig>