<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 8/09/23 22:30, Stephen Worthington
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:ictlfihqsimdfa9on3a1j88lt7sdmgshuu@4ax.com">If there are
no recording rules for Prime or Sky Open, do you still
have the channel for Sky Open?</blockquote>
Yes the channel works and I can set a recording manually'<br>
<blockquote type="cite"
cite="mid:ictlfihqsimdfa9on3a1j88lt7sdmgshuu@4ax.com"> 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)
</blockquote>
<p><br>
</p>
<p>This morning I edited the xmltvid and the Freeview.xmltv (back to
skyopen.freeviewnz.tv)</p>
<p>Now I get (when I run journalctl -eu epg)</p>
<p>Sep 09 11:18:16 FishMyth bash[26764]: Sky Open Sky
Open skyopen.freeviewnz.tv</p>
<p><b>But no Prime or Sky Open in --- Channel Names ---</b></p>
<p><b>But PRIME is there (and when I look back PRIME was there
yesterday too)</b></p>
<p>Could that be a tip?</p>
<p>The database query now looks similar to yours:-</p>
<p>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%';<br>
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+<br>
| chanid | channum | sourceid | callsign | name |
xmltvid | mplexid | serviceid |<br>
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+<br>
| 10015 | 15 | 1 | Sky Open | Sky Open |
skyopen.freeviewnz.tv | 4 | 1406 |<br>
+--------+---------+----------+----------+----------+-----------------------+---------+-----------+<br>
1 row in set (0.00 sec)<br>
</p>
</body>
</html>