[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