[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