Opened 9 years ago

Closed 9 years ago

#9788 closed Bug Report - General (Duplicate)

mythtv chokes on broken EPG data

Reported by: Peter D. <0123peter@…> Owned by: Stuart Auchterlonie
Priority: minor Milestone: unknown
Component: MythTV - EIT Version: 0.24-fixes
Severity: medium Keywords: EPG recording
Cc: Ticket locked: no

Description

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.

Change History (6)

comment:1 Changed 9 years ago by 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

comment:2 Changed 9 years ago by sphery

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

comment:3 Changed 9 years ago by 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.

comment:4 Changed 9 years ago by sphery

Which specific fields have null character?

comment:5 Changed 9 years ago by 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>

comment:6 Changed 9 years ago by sphery

Resolution: Duplicate
Status: newclosed

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.

Note: See TracTickets for help on using tickets.