[mythtvnz] Prime => Sky Open

[Robert Fisher]

On 8/09/23 22:30, Stephen Worthington wrote:
> If there are no recording rules for Prime or Sky Open, do you still 
> have the channel for Sky Open?
Yes the channel works and I can set a recording manually'
> 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) 


This morning I edited the xmltvid and the Freeview.xmltv (back to 
skyopen.freeviewnz.tv)

Now I get (when I run journalctl -eu epg)

Sep 09 11:18:16 FishMyth bash[26764]: Sky Open        Sky Open        
skyopen.freeviewnz.tv

*But no Prime or Sky Open in --- Channel Names ---*

*But PRIME is there (and when I look back PRIME was there yesterday too)*

Could that be a tip?

The database query now looks similar to yours:-

mysql> 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%';
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+
| chanid | channum | sourceid | callsign | name     | 
xmltvid               | mplexid | serviceid |
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+
|  10015 | 15      |        1 | Sky Open | Sky Open | 
skyopen.freeviewnz.tv |       4 |      1406 |
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+
1 row in set (0.00 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20230909/1183cfcf/attachment.html>