[mythtv-users] EPG Language
Timo Ketola
tike64 at riihineva.no-ip.org
Mon Aug 11 19:29:53 UTC 2008
Ismo Tanskanen wrote:
> What tv station you are using?
Lapua
> Have you any sql tool to examine database?
I'll try mysql...
> If you can send me minor part
> of database (channel, eit, dtv tables etc), I can check if there is
> divergences.
I took samples from each. Tell me what more should I send...
mysql> select * from channel;
+--------+---------+--------+----------+---------------+---------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+
| chanid | channum | freqid | sourceid | callsign | name | icon | finetune | videofilters | xmltvid | recpriority
| contrast | brightness | colour | hue | tvformat | commfree | visible | outputfilters | useonairguide | mplexid | serviceid |
atscsrcid | tmoffset | atsc_major_chan | atsc_minor_chan | last_record | default_authority | commmethod |
+--------+---------+--------+----------+---------------+---------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+
| 1001 | 1 | NULL | 1 | YLE TV1 | YLE TV1 | | NULL | | | 0
| 32768 | 32768 | 32768 | 32768 | | 0 | 1 | | 1 | 1 | 17 |
NULL | 0 | 0 | 0 | 2008-08-10 19:50:26 | | -1 |
| 1002 | 2 | NULL | 1 | YLE TV2 | YLE TV2 | | NULL | | | 0
| 32768 | 32768 | 32768 | 32768 | | 0 | 1 | | 1 | 1 | 33 |
NULL | 0 | 0 | 0 | 2008-07-07 12:36:47 | | -1 |
mysql> select * from eit_cache where chanid = 1001;
+--------+---------+---------+---------+------------+--------+
| chanid | eventid | tableid | version | endtime | status |
+--------+---------+---------+---------+------------+--------+
| 1001 | 0 | 0 | 0 | 1218481697 | 2 |
| 1001 | 1 | 80 | 4 | 1218560400 | 0 |
| 1001 | 1 | 0 | 0 | 1218479718 | 2 |
mysql> select * from dtv_multiplex;
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+---------------------+
| mplexid | sourceid | transportid | networkid | frequency | inversion | symbolrate | fec | polarity | modulation | bandwidth |
lp_code_rate | transmission_mode | guard_interval | visible | constellation | hierarchy | hp_code_rate | sistandard |
serviceversion | updatetimestamp |
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+---------------------+
| 1 | 1 | 4097 | 8438 | 610000000 | a | NULL | NULL | NULL | NULL | 8 |
2/3 | 8 | 1/8 | 0 | qam_64 | n | 2/3 | dvb |
16 | 2007-09-18 23:15:53 |
| 2 | 1 | 8193 | 8438 | 602000000 | a | NULL | NULL | NULL | NULL | 8 |
2/3 | 8 | 1/8 | 0 | qam_64 | n | 2/3 | dvb |
16 | 2007-09-18 23:16:07 |
mysql> select * from dtv_privatetypes;
+--------+-----------+---------------------+---------------------------------------------------+
| sitype | networkid | private_type | private_value |
+--------+-----------+---------------------+---------------------------------------------------+
| dvb | 9018 | channel_numbers | 131 |
| dvb | 9018 | guide_fixup | 2 |
| dvb | 256 | guide_fixup | 1 |
These long lines propably will get messed in transit. Maybe I should put them into text file and attach it.
> Beyond that I can't assume what is wrong. Screen captures
> etc from mythtv-setup could help.
Can do. Which pages? Maybe I shouldn't send them through the list.
Here is also a sample from program table where you see the problem:
| 1001 | 2008-08-11 21:00:10 | 2008-08-11 21:55:46 | Kotikatsomo: Caasha | |
Somalialainen tyttö ja suomalainen poika tutustuvat kesäisessä Itä-Helsingissä. Rooleissa Arttu Kapulainen, Anab Egal. Ohjaus
Lotta Kupiainen. Käsikirjoitus Jan Forsström. (U) | Movie
| movie | 2000 | 0 | 0 | | 1 | 1 | 0 |
0 | 0 | 0 | | NULL | | | | |
0 | 0 | 1 | 1 | 1 | STEREO | NORMAL | WIDESCREEN |
| 1001 | 2008-08-11 21:55:46 | 2008-08-11 22:55:00 | 5 perspektiv på kosmologi: Alltets början | | Hur vet vi
att universum uppstod genom en urexplosion? Vilka värden erbjuder vetenskapen vår världsbild? Gäster hos Esko Valtaoja är
kosmolog Kari Enqvist och religionsvetaren Matti Kamppinen. |
Education/Science/Factual | tvshow | 2000 | 0 | 0 | | 1 | 1 | 0 |
0 | 0 | 0 | | NULL | | | |
| 0 | 0 | 1 | 0 | 0 | STEREO | NORMAL | WIDESCREEN |
Do you know, how mythtv manages the EPG when the signal is not ideal. If it fails to get finnish entry does it fill the void
with swedish? And would it replace a swedish entry later if it manages to get the same entry in finnish. Supposing, of course,
that the preferred language is finnish.
--
Timo
More information about the mythtv-users
mailing list