[mythtvnz] Prime => Sky Open

[Stephen Worthington]

On Fri, 8 Sep 2023 16:26:50 +1200, you wrote:

>I thought that my epg had previously had data for Sky Open but today 
>there is nothing in
>
>/home/mythtv/.mythtv/freeview.xml  for Sky Open (or Prime
>
>I am a bit stuck now. Here is some supporting info if someone has any 
>suggestions I would appreciate help.
>
>When I ran journalctl -eu epg
>
>I got:-
>
>Sep 08 15:38:03 FishMyth bash[4818]: Getting channel info from MythTV 
>database using mysql
>Sep 08 15:38:03 FishMyth bash[4820]: mysql: [Warning] Using a password 
>on the command line interface can be insecure.
>Sep 08 15:38:03 FishMyth bash[4822]: mysql: [Warning] Using a password 
>on the command line interface can be insecure.
>Sep 08 15:38:03 FishMyth bash[4818]: Al Jazeera        Al Jazeera        
>aljazeera.freeviewnz.tv
>Sep 08 15:38:03 FishMyth bash[4818]: Radio NZ National Radio NZ 
>National        rnz-national.freeviewnz.tv
>
>etc etc etc and
>
>Sep 08 15:38:03 FishMyth bash[4818]: Sky Open        Sky Open        
>skyopen.freeviewnz.tv
>
>so I tried changing the xmltvid from
>
>skyopen.freeviewnz.tv to prime.freeviewnz.tv
>
>and doing the same in Freeview.xmltv
>
>Now I get (when I run journalctl -eu epg)
>
>Sep 08 16:13:35 FishMyth bash[5729]: Sky Open        Sky Open        
>prime.freeviewnz.tv
>
>But no Prime or Sky Open in --- Channel Names ---
>
>/home/mythtv/.mythtv/freeview.xml gets updated but has no reference to 
>prime or sky open
>
>In mythconverg I ran
>
>mysql> select recordid,chanid,station,title from record where station 
>like '%prime%';
>Empty set (0.01 sec)
>
>mysql> select recordid,chanid,station,title from record where station 
>like '%skyopen%';
>Empty set (0.00 sec)
>
>mysql> select recordid,chanid,station,title from record where station 
>like '%sky open%';
>Empty set (0.00 sec)
>
>mysql> select recordid,chanid,station,title from record where station 
>like '%PRIME%';
>Empty set (0.00 sec)

If there are no recording rules for Prime or Sky Open, do you still
have the channel for Sky Open?  If the channel was deleted, then the
recording rules would also be deleted with it.  And then the EPG would
not collect data for the channel either.  Try this query:

select chanid,channum,sourceid,callsign,name,xmltvid,mplexid,serviceid
from channel where name like '%prime%' or name like '%sky open%' or
callsign like '%prime%' or callsign like '%sky open%' or
serviceid=1406 or xmltvid like '%prime%' or xmltvid like '%skyopen%';

I get:

+--------+---------+----------+-------------+-------------+------------------------+---------+-----------+
| chanid | channum | sourceid | callsign    | name        | xmltvid                | mplexid | serviceid |
+--------+---------+----------+-------------+-------------+------------------------+---------+-----------+
|   1010 | 15      |        1 | Sky Open    | Sky Open    | skyopen.freeviewnz.tv  |       4 |      1406 |
|   3010 | 10      |        3 | Sky Open    | Sky Open    | skyopen.freeviewnz.tv  |       9 |      1530 |
|  10004 | 4004    |        6 | Sky Open    | Sky Open    | skyopen.sky.co.nz      |    NULL |      1211 |
|  10514 | 4514    |        6 | Sky Open +1 | Sky Open +1 | skyopenplus1.sky.co.nz |    NULL |      1227 |
+--------+---------+----------+-------------+-------------+------------------------+---------+-----------+
4 rows in set (0.000 sec)