mythtv chokes on broken EPG data

[Peter D. <0123peter@…>]

It is a bit hard to work out exactly what is broken, but it seems that our local community TV station has something seriously wrong with its free to air electronic program guide. Information is displayed sensibly in the program guide screen, but selecting anything to be recorded from that channel, and only that channel, causes a screwup in the data base of programs to be recorded - or at least how things are displayed. Everything seems to get forgotten. I've done it twice with similar results.

I don't know how to capture or examine the raw EPG data, so I can't offer much more detail.

Possibly their EPG data is in local time when everyone else's is in GMT, but I can't verify that.

[Stuart Auchterlonie]

You can use tv_grab_dvb to grab the raw data into xml format. This will let us look at what they are sending.

We can also look at the raw data using dvbsnoop.

Stuart

[sphery]

This sounds like a dup of #8707 . Are you running a sufficiently new version of MythTV (from Apr 13 or later)?

[Peter D. <0123peter@…>]

I'm using a pre-compiled version; 0.24-20110303. So no I don't have the fixes for #8707, and yes there are nulls in the epg data of the offending channel. The symptoms are different, but that was 0.23 rather than 0.24.

Where is tv_grab_dvb? I have found dvbsnoop and am playing with that - not that I am expecting to find anything useful at this stage.

This bug is probably a duplicate.

[sphery]

Which specific fields have null character?

[Peter D. <0123peter@…>]

Basically, I only cut and pasted mysql commands from the referenced bug because I don't know how to use mysql properly, but it looks like subtitle is being set to null.

The formatting is quite wrong, but I think that you will work it out.

mysql> SELECT chanid,title,subtitle FROM program WHERE title LIKE '\0';

Empty set (0.00 sec)

mysql> SELECT chanid,title,subtitle FROM program WHERE chanid LIKE '\0';

Empty set (0.04 sec)

mysql> SELECT chanid,title,subtitle FROM program WHERE subtitle LIKE '\0';

+--------+------------------------------------------+----------+

| chanid | title | subtitle |

+--------+------------------------------------------+----------+

| 1044 | Shelf Life | |

| 1044 | The Journal | |

[big snip]

| 1044 | Masterclass in Oils | |

| 1044 | Art Studio | |

+--------+------------------------------------------+----------+

317 rows in set (0.03 sec)

mysql>

[sphery]

Closing as a dup of #8707. If, after upgrading to a version of 0.24-fixes past Apr 13, you still have issues, please re-open with a mysqldump of the program table so we can identify which field is causing issues. Thanks for getting back to us.