<div class="gmail_quote">On Mon, Oct 22, 2012 at 7:47 PM, Worik Stanton <span dir="ltr"><<a href="mailto:worik.stanton@gmail.com" target="_blank">worik.stanton@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">
On 22/10/12 18:23, Steve Hodge wrote:<br>
<br>
> You are running DVB-T, right? We need the serviceid. How are you<br>
populating<br>
> guide data? Give us the output of this query:<br>
<br>
</div>Yes and DVB-T. I am downloading NZ data via a python script. Slips my<br>
mind exactly how. I am using the back end as I write otherwise I'd run<br>
mythtv-setup. But I learnt how here.<br>
<br>
But that said I made an observation when Get Smart recorded on the wrong<br>
channel. I was watching at the time and I went to the "Program Guide"<br>
and there was no data there. Normally I see an hour or two ahead.<br></blockquote><div><br>That sounds like EIT "now and next" data.<br><br>chanid,callsign,mplexid,xmltvid,serviceid<br>1050,TV2,NULL,<a href="http://tv2.freeviewnz.tv">tv2.freeviewnz.tv</a>,0<br>
1002,TV2,5,,1201<br>3002,TV2,8,,1201<br><br>The first TV2 row is the only one with a xmltvid so it's the only one being populated with downloaded guide data. But it doesn't seem to have any tuning information (neither freqid or serviceid are populated) so it can't be recorded.<br>
<br>The other two TV2 rows have tuning data for DVB. My guess is that they are getting "now and next" data from the EIT columns. So when that's working everything records ok. But when the EIT data is missing then Myth tries to record from the broken channel and fails.<br>
<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">> select chanid, channum, freqid, sourceid, callsign, name, xmltvid,<br>
visible,<br>
> useonairguide, mplexid, serviceid from channel;<br>
<br>
</div>Attached.<br></blockquote><div><br>You missed sourceid and useonairguidedata. Can you include those so I can confirm that you are getting EIT data?<br> <br>This looks like the exact same problem you had back in June. But
back then these channels with the xmltvid had different chanids. It
looks like you probably deleted them back then and something (probably
your guide data downloader) has repopulated them. You should assign an
xmltvid to all the DVB channels and then delete these extra channels. Give us the output of the above query and I'll put together an sql script to sort it out.<br><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">> If you need more info, search the archives. I've gone into detail on the<br>
> chanid/channum/callsign stuff before.<br>
<br>
</div>Any clues? The archive is big.<br></blockquote><div><br>Try searching for my email and "channum" or "callsign". But the email I was thinking of with from 7 Mar 2007. It doesn't actually have much more info, just this:<br>
<br>If the <span class="il">callsign</span> and channel numbers of two
channels are identical then the channel will only appear once in the
guide (and MythWeb). If the callsigns are identical but the channums are
not then the channel will appear twice in the guide but the scheduler
will treat them as the same provided they have the same listings data.
This allows people who have two channels that are mostly the same, but
have some differences, to use them interchangably when a program appears
on both versions without screwing up when the channels differ (this
doesn't happen in NZ at the moment). Unfortunately it means that it is
important that EPG listings for copies of a single channel are identical
otherwise the scheduler won't be able to use them interchangably.
That's why I keep telling people to use the same listings data for
FreeView channels and for Sky/terrestrial channels - there are
differences in the data between what Sky send and what FreeView send and
those differences can cause problems if you're using Sky data for one
version of a channel and FreeView data for another.
<br><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Here is some data:<br>
<br>
I know Get Smart failed. So I look for it in the program table with the<br>
matching row from channel.<br>
<br>
mysql> select p.chanid, <a href="http://c.name" target="_blank">c.name</a>, c.serviceid, title from program p,<br>
channel c where title like "%Smart%" and p.chanid=c.chanid;<br>
+--------+------+-----------+-----------+<br>
| chanid | name | serviceid | title |<br>
+--------+------+-----------+-----------+<br>
| 1050 | TV 2 | 0 | Get Smart |<br>
+--------+------+-----------+-----------+<br>
1 row in set (0.11 sec)<br>
<br>
>From what you have been saying a serviceid of 0 is not good for DVB?<br></blockquote><div><br>Right. You can't record that channel and that program is not in the guide data for the channels you can record.<br><br>Cheers,<br>
Steve<br></div></div>