[mythtv-users] wrong EIT data in database
Markus Schulz
msc at antzsystem.de
Sat Feb 7 09:41:01 UTC 2009
hello,
i've bad eit data sometimes in my database (mythtv at trunk) like the
following:
mysql> SELECT
p.chanid,starttime,endtime,title,subtitle,LEFT(description,25),
c.callsign,c.serviceid, m.transportid, m.networkid, m.symbolrate,
m.modulation,m.frequency FROM program p LEFT JOIN channel c ON
(p.chanid=c.chanid) LEFT JOIN dtv_multiplex m ON (c.mplexid =
m.mplexid) WHERE p.chanid = 20501 and starttime > '2009-02-07 13:00'
and endtime < '2009-02-07 16:00' order by starttime;
| chanid | starttime | endtime |title |
| subtitle |LEFT(description,25) | callsign | serviceid |
transportid | networkid | symbolrate | modulation | frequency |
| 20501 | 2009-02-07 13:16:22 | 2009-02-07 13:44:25 | Malcolm
mittendrin | | Um auf ein Rockkonzert ge | ProSieben |
17501 | 1107 | 1 | 22000000 | qpsk | 12544750 |
| 20501 | 2009-02-07 13:44:25 | 2009-02-07 14:12:44 | How I Met Your
Mother | | Um auf ein Rockkonzert ge | ProSieben | 17501 |
1107 | 1 | 22000000 | qpsk | 12544750 |
| 20501 | 2009-02-07 14:12:44 | 2009-02-07 14:38:30 | How I Met Your
Mother | | Die beiden Brautleute Mar | ProSieben | 17501 |
1107 | 1 | 22000000 | qpsk | 12544750 |
| 20501 | 2009-02-07 14:38:30 | 2009-02-07 15:04:57 | Scrubs - Die
Anf�nger | | In ihrer Zeit im "Sacred | ProSieben |
17501 | 1107 | 1 | 22000000 | qpsk | 12544750 |
As you can see the first "How I Met Your Mother" series has correct
title but the wrong description. It has the same description like the
show running immediately before it.
The "How I Met Your Mother" series will be repeated next morning, this
time the EIT was correct in my database and the first of the two will
be recorded again (cause different description).
Whats wrong here?
--
Markus Schulz
More information about the mythtv-users
mailing list