Opened 9 years ago

Closed 9 years ago

#12548 closed Bug Report - General (Fixed)

UK EIT fixup not applied consistently for Freesat

Reported by: lucylangthorne55@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: 0.28.1
Component: MythTV - EIT Version: 0.27.5
Severity: medium Keywords:
Cc: Ticket locked: no

Description

For UK DVB-S Freesat using OTA EIT, the EIT fixup does not seem to be applied on all titles. This means some titles have a prefix of "New:". An example is below where we detect the same program at the same time via different regional channels but some are prefixed with "New:".

Similar to #11715 which was fixed a few years ago for UK Freeview (DVB-T).

select distinct title,starttime,callsign from program P, channel C where C.chanid=P.chanid and programid='www.itv.com/806266883' and sourceid=1 and xmltvid= and useonairguide=1 order by starttime;

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

| title | starttime | callsign |

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

| Lewis | 2015-11-10 21:00:00 | ITV |

| Lewis | 2015-11-10 21:00:00 | ITV Border |

| New: Lewis | 2015-11-10 21:00:00 | ITV |

| New: Lewis | 2015-11-10 21:00:00 | ITV Wales |

| Lewis | 2015-11-10 21:00:00 | ITV Wales HD |

| Lewis | 2015-11-10 21:00:00 | ITV HD |

| Lewis | 2015-11-10 22:00:00 | ITV +1 |

| New: Lewis | 2015-11-10 22:00:00 | ITV +1 |

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

Change History (9)

comment:1 Changed 9 years ago by Stuart Auchterlonie

Milestone: unknown0.28
Owner: changed from Karl Egly to Stuart Auchterlonie
Status: newaccepted

Should be pretty straightforward to sort out

comment:2 Changed 9 years ago by Stuart Auchterlonie

So, the relevant fixups should be being called, as all the right bits are in place.

I can confirm the observation though, that there are definitely incidences of "New:" in the program data.

Master is better than fixes/0.27.

More investigation required.

comment:3 Changed 9 years ago by Stuart Auchterlonie <stuarta@…>

In e404ef45fab5fef49397ed763241d893633695c3/mythtv:

Refs #12548. Implement stripping of HTML tags from EIT data.

Can be turned on and off per service / transport / multiplex
just like the other fixups.

Also re-arranged and sorted the UK transport id maps, as there
were duplicate entries and the sorting was not in transport order

Added unit tests for stripping html tags

comment:4 Changed 9 years ago by Stuart Auchterlonie <stuarta@…>

In b399531833e80d18454948f3f87400b7c92db7f0/mythtv:

Refs #12548. Missing 1 mplex, fix overlapping definitions

comment:5 Changed 9 years ago by Stuart Auchterlonie <stuarta@…>

In b399531833e80d18454948f3f87400b7c92db7f0/mythtv:

Refs #12548. Missing 1 mplex, fix overlapping definitions

comment:6 Changed 9 years ago by Stuart Auchterlonie

Milestone: 0.280.28.1

comment:7 Changed 9 years ago by Stuart Auchterlonie <stuarta@…>

In 6865940761d0b6058720ce1d02b5fa684a6c159e/mythtv:

EIT: Refs #12548. Add several more multiplexes

comment:8 Changed 9 years ago by Stuart Auchterlonie <stuarta@…>

In 4260de4eef72583c261caa66352187e1bdfa6cf4/mythtv:

EIT: Refs #12548. Add several more multiplexes

(cherry picked from commit 6865940761d0b6058720ce1d02b5fa684a6c159e)

comment:9 Changed 9 years ago by Stuart Auchterlonie

Resolution: Fixed
Status: acceptedclosed

Marking as fixed as I now have a full set of guide data and no programs starting with New:

The following query now returns 0 rows

select chanid, serviceid, transportid, networkid, d.mplexid from channel as c, dtv_multiplex as d where c.mplexid=d.mplexid and chanid in (select chanid from program where title like '%New:%' and starttime >= now());
Note: See TracTickets for help on using tickets.