Opened 16 months ago

Closed 9 months ago

Last modified 9 months ago

#13213 closed Bug Report - General (fixed)

SchedulesDirect/xmltv originalairdate for movies is always 0 in recorded table

Reported by: lucylangthorne55@… Owned by: Peter Bennett
Priority: minor Milestone: 30.0
Component: MythTV - General Version: v29-fixes
Severity: low Keywords: xmltv mythfilldatabase
Cc: Ticket locked: no

Description

Mentioned in forum https://forum.mythtv.org/viewtopic.php?f=9&t=2285 and I was requested to raise a bug.

I recently switched from OTA listings to SchedulesDirect? (SD) xmltv.

Prior to the switch, my mythtv recorded table contained an originalairdate for recorded movies such as '2015-01-01' (always 1st Jan). Now I only have 0000-00-00 for all newly recorded movies.

The recorded table doesn't contain an "airdate" field, only an "originalairdate", whereas program table contain both.

The SD xmltv data for the movie contains year like this:

<date>2013</date>
<previouslyshown />

This is set in to the airdate in the program table by mythfilldatabase, but originalairdate is always NULL in the program table for movies (not set) since "previouslyshown" for SD movies never contains a date.

I think OTA used to copy the year 2013 in to both airdate and originalairdate which then caused it to be available in the recorded table.

However, for SD, the null originalairdate means that when a program is recorded, it copies the null originalairdate from the program table to the recorded table and loses the year information from airdate.

I think it would be useful to have the movie year information in the recorded table.

I had a script that would generate additional processing based on "title (year)", though I have changed it to extract information direct from the SD database instead.

However, by having the data persisted it could mean it is passed through the API to other frontends that lookup data based on "movie (year)".

Change History (6)

comment:1 Changed 16 months ago by Peter Bennett

Owner: set to Peter Bennett
Status: newassigned

comment:2 Changed 13 months ago by Peter Bennett

Owner: changed from Peter Bennett to Peter Bennett

comment:3 Changed 9 months ago by Peter Bennett <pbennett@…>

Resolution: fixed
Status: assignedclosed

In 6ae22acae/mythtv:

In recordings if originalairdate is unvailable use airdate

Airdate is only year, so the originalairdate is set to 1/1 of that year.

Fixes #13213

comment:4 Changed 9 months ago by Peter Bennett <pbennett@…>

In 6ae22acae/mythtv:

In recordings if originalairdate is unvailable use airdate

Airdate is only year, so the originalairdate is set to 1/1 of that year.

Fixes #13213

comment:5 Changed 9 months ago by Peter Bennett <pbennett@…>

In 6ae22acae/mythtv:

In recordings if originalairdate is unvailable use airdate

Airdate is only year, so the originalairdate is set to 1/1 of that year.

Fixes #13213

comment:6 Changed 9 months ago by Stuart Auchterlonie

Milestone: needs_triage30.0
Note: See TracTickets for help on using tickets.