[mythtv-users] EPG Language

Ismo Tanskanen ismot at telemail.fi
Tue Aug 12 06:23:38 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
_______________________________________________
mythtv-users mailing list
mythtv-users
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

I can't see any differences in those tables, although I don't know if 
those do matter anyway. Your problem seems strange, because I have never 
seen swedish entry in my epg. How often this happens?

What about your setup? Do you have multiple video inputs? I have three 
cards and two video inputs configured, one for free channels and one for 
pay channels. Myth seems to catch eit data for both, even if channel 
numbers and id:s are equal. I sometimes see, that same show is recorded 
twice, because eit data has slight difference in video inputs. Usually 
start time is one minute different.

If you can send me mythtv-setup screen captures to my email : 
ismot at telemail.fi

I'm interested of general settings , video sources, input connections, 
and maybe one channel setup for sample.

Sure this is shot in the dark, but I can't imagine any other problems 
than some little setting difference.

- I


More information about the mythtv-users mailing list