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

UB40D ub40dd at googlemail.com
Sun Dec 29 18:10:24 UTC 2019


On Sun, 29 Dec 2019 at 16:37, John <jksjdevelop at gmail.com> wrote:

> On Freesat Channel 4 HD does indeed have no EIT
>

Argh! Weird and unexpected, but this explains things!


> One solution is to copy the EIT from channel 4 using
> https://www.mythtv.org/wiki/Cross-eit.py
>
> I run this once a day using cron
>

Thanks very much for this tip.

I have managed to extract a channel number for channel 4 as follows:

mysql -u tv -p mythconverg -e "SELECT chanid,callsign from channel WHERE
callsign='Channel 4'"
Enter password:
+--------+-----------+
| chanid | callsign  |
+--------+-----------+
|  10211 | Channel 4 |
|  10212 | Channel 4 |
|  10213 | Channel 4 |
|  10214 | Channel 4 |
|  10216 | Channel 4 |
|   9320 | Channel 4 |
+--------+-----------+

(I have no idea why I have so many; this happens with several other
channels too, even when I restart from a clean scan)

Anyway, I plugged the first of these numbers into a command line for
cross-eit, as follows, and I managed to produce an xml file:

 ./cross-eit.py -o /tmp/export.xml "10211,Channel 4 HD"

...and I confirm the file had stuff that looked sensible; however I was not
able to import it into the database. What I tried was

mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1
--xmlfile /tmp/export.xml
****************************************************
 WARNING: --refresh-all has been deprecated
          use --refresh instead
****************************************************

2019-12-29 18:02:24.010591 C  mythfilldatabase version: fixes/29
[v29.1-40-g951f1fe] www.mythtv.org
2019-12-29 18:02:24.010611 C  Qt version: compile: 5.5.1, runtime: 5.9.5
2019-12-29 18:02:24.010615 N  Enabled verbose msgs:  general xmltv
2019-12-29 18:02:24.010627 N  Setting Log Level to LOG_INFO
2019-12-29 18:02:24.021071 I  Bypassing grabbers, reading directly from file
2019-12-29 18:02:24.021656 I  Setup Interrupt handler
2019-12-29 18:02:24.021671 I  Setup Terminated handler
2019-12-29 18:02:24.021679 I  Setup Segmentation fault handler
2019-12-29 18:02:24.021689 I  Setup Aborted handler
2019-12-29 18:02:24.021713 I  Setup Bus error handler
2019-12-29 18:02:24.021723 I  Setup Floating point exception handler
2019-12-29 18:02:24.021731 I  Setup Illegal instruction handler
2019-12-29 18:02:24.021743 I  Setup Real-time signal 0 handler
2019-12-29 18:02:24.021754 I  Setup Hangup handler
2019-12-29 18:02:24.021801 I  Added logging to the console
2019-12-29 18:02:24.021877 N  Using runtime prefix = /usr
2019-12-29 18:02:24.021881 N  Using configuration directory =
/home/tv/.mythtv
2019-12-29 18:02:24.021959 I  Assumed character encoding: en_GB.UTF-8
2019-12-29 18:02:24.022298 N  Empty LocalHostName.
2019-12-29 18:02:24.022304 I  Using localhost value of sgrizzo
2019-12-29 18:02:24.022350 I  Start up testing connections. DB localhost,
BE , attempt 0, status dbAwake
2019-12-29 18:02:25.039701 N  Setting QT default locale to en_US
2019-12-29 18:02:25.039709 I  Current locale en_US
2019-12-29 18:02:25.039766 N  Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
2019-12-29 18:02:25.043599 I  Loading en_gb translation for module
mythfrontend
2019-12-29 18:02:25.044414 I  Current MythTV Schema Version (DBSchemaVer):
1348
2019-12-29 18:02:25.046092 I  MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-12-29 18:02:25.046909 I  MythCoreContext::CheckProtoVersion(): Using
protocol version 91 BuzzOff
2019-12-29 18:02:25.047055 I  Opening blocking connection to master backend
2019-12-29 18:02:25.049521 I  Starting process manager
2019-12-29 18:02:25.049530 I  Starting process signal handler
2019-12-29 18:02:25.050315 I  Starting IO manager (write)
2019-12-29 18:02:25.050524 I  Starting IO manager (read)
2019-12-29 18:02:25.559565 W  No explicit time zone found, guessing
implicit UTC! Please consider enhancing the guide source to provide
explicit UTC or local time instead.
2019-12-29 18:02:25.618284 N  Unknown xmltv channel identifier: Channel -
Skipping channel.
2019-12-29 18:02:25.618303 I  Updated programs: 0 Unchanged programs: 0
2019-12-29 18:02:25.619910 I  Adjusting program database end times.
2019-12-29 18:02:25.620058 I      0 replacements made
2019-12-29 18:02:25.620061 I  Marking generic episodes.
2019-12-29 18:02:26.047229 I      Found 0
2019-12-29 18:02:26.047235 I  Extending non-unique programids with multiple
parts.
2019-12-29 18:02:26.115452 I      Found 0
2019-12-29 18:02:26.115458 I  Fixing missing original airdates.
2019-12-29 18:02:26.381737 I      Found 0 with programids
2019-12-29 18:02:26.558699 I      Found 0 without programids
2019-12-29 18:02:26.558707 I  Marking repeats.
2019-12-29 18:02:26.937490 I      Found 0
2019-12-29 18:02:26.937497 I  Unmarking new episode rebroadcast repeats.
2019-12-29 18:02:26.959418 I      Found 0
2019-12-29 18:02:28.289978 I  Marking episode first showings.
2019-12-29 18:02:32.714980 I      Found 75686
2019-12-29 18:02:32.714987 I  Marking episode last showings.
2019-12-29 18:02:37.053638 I      Found 60974
2019-12-29 18:02:37.063622 I
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2019-12-29 18:02:37.064193 N  mythfilldatabase run complete.
2019-12-29 18:02:37.064245 I  Waiting for threads to exit.


...but at the end of that I did not find data for Channel 4 HD in the
database. What I did was

manage recordings / schedule recordings / search lists / channels / Channel
4 HD

and it came up with just the current programme, nothing else.

Interestingly, in the box with the names of the channels, it appeared as
21200 Channel 4 HD

So I tried the whole rigmarole again but with that number in, as in


 ./cross-eit.py -o /tmp/export.xml "10211,21200 Channel 4 HD"

 mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1
--xmlfile /tmp/export.xml

but it still didn't do me any good.
What am I missing?


I vaguely remember the result being one hour offset, presumably it doesn't
> handle the clocks changing correctly.
>
> This line may need attention
>
> date = dateobj # + datetime.timedelta(seconds=time.altzone)
>
Thanks. I' ll look into that once I manage to import some schedule data...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191229/ffff7b2b/attachment.htm>


More information about the mythtv-users mailing list