Opened 7 years ago
Closed 3 years ago
#13138 closed Bug Report - General (Trac EOL)
mythweb last recorded time showing with utc+0 instead of correct timezone
| Reported by: | Owned by: | Stuart Auchterlonie | |
|---|---|---|---|
| Priority: | minor | Milestone: | needs_triage |
| Component: | Plugin - MythWeb | Version: | Master Head |
| Severity: | medium | Keywords: | mythweb |
| Cc: | Ticket locked: | no |
Description
Running Mythtv 2:29.0+fixes.20170929.7080df5-0ubuntu0mythbuntu3
All times are shown correctly in mythfrontend for upcoming recordings and previously recorded in manage recordings. EPG is correct, current live time is correct.
All times are shown correctly in http://localhost:6544/# tv->recording rules and any other area I checked
All times are shown correctly in http://localhost/mythweb except for recording schedules-> last recorded time which when inspected shows this element: <td class="x-lastrec">2017-09-30 18:00:00</td>
The time that is shown is utc+0, my system is utc-6 and is shown correctly in all other places of mythweb, epg data, upcoming recordings, current time, recorded program airdate, etc.
I did confirm that SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC'); returns a correct utc-6 time. I had to run mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql to achieve this.
The server has been rebooted. I am happy to provide any other information I can, I am just not sure what that would entail. Thank you for the work on this excellent software.
I can confirm that in mythweb on v29 I am also seeing Last recorded time as UTC. I don't know if it was ever correct since the UTC conversion in version 0.25. To me the last recorded date is more important than the time.