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

[lucylangthorne55@…]

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)".

[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

[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

[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