Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#12024 closed Bug Report - General (fixed)

record.last_record is not upgraded from local time to UTC

Reported by: faginbagin <mythtv@…> Owned by: danielk
Priority: minor Milestone: 0.27.1
Component: MythTV - Mythtv-setup Version: 0.27-fixes
Severity: medium Keywords: schema upgrade
Cc: Ticket locked: no

Description

I used mythconverg_restore.pl to restore an 0.23 database with schema version 1254, and ran mythtv-setup which upgraded the schema to 1317. The system seems to be functioning normally. But when I look at the "Recording Rules" screen, it is odd to see "Last Recorded" entries that predate the upgrade are off by 4 to 5 hours depending on DST. For example, I've got a recording rule for "The Americans" that displays a "Last Recorded" date/time of "Wed 2013-05-01, 6:00 pm" but when I look at the last "Previously Recorded" entry it shows a date/time of "Wed 2013-05-01, 10:00 - 11:06 pm". Maybe it's only a cosmetic problem, but maybe it could cause problems elsewhere?

Change History (3)

comment:1 Changed 6 years ago by David Engel <dengel@…>

Resolution: fixed
Status: newclosed

In e523eedc7fb884eaa147b77091aa30ff52c54929/mythtv:

Update record.last_record/deleted to UTC.

These were missed in the upgrade to schema version 1303. Note that
this change only works for those who haven't yet upgraded. It's too
difficult to impossible to fix this for those who have already
upgraded.

Fixes #12024

comment:2 Changed 6 years ago by David Engel <dengel@…>

In 5a5e1cd52906e10a1aa15c207764b8bdcab8caa6/mythtv:

Update record.last_record/deleted to UTC.

Backport to fixes/0.27.

These were missed in the upgrade to schema version 1303. Note that
this change only works for those who haven't yet upgraded. It's too
difficult to impossible to fix this for those who have already
upgraded.

Fixes #12024

(cherry picked from commit e523eedc7fb884eaa147b77091aa30ff52c54929)

comment:3 Changed 6 years ago by gigem

Milestone: unknown0.27.1
Note: See TracTickets for help on using tickets.