Difference between revisions of "OTA Daylight Savings Time Offset Not Honored"
(sudo isn't required for mythtv-setup) |
(Mark outdated, should not be needed starting with 0.26) |
||
Line 1: | Line 1: | ||
− | + | {{Outdated2|Starting with the 0.26 release, scheduled-program related timestamps are stored in [[UTC]]. This page needs review.}} | |
== Problem: Listings Time is Off == | == Problem: Listings Time is Off == | ||
Latest revision as of 00:40, 20 September 2012
Outdated: Starting with the 0.26 release, scheduled-program related timestamps are stored in UTC. This page needs review.
Problem: Listings Time is Off
Over The Air recording are off by one hour in listing and schedules two times a year.
After the recent Spring Ahead to Daylight Savings Time all the listing were off by 1 hour.
This can also happen after power outages. The method below will reset listing and upcoming recordings to the correct time.
Quick Fix
Log in to PHPMyAdmin using your browser and go to the mythconverg database
Execute the following SQL
TRUNCATE TABLE program;
To grab new data OTA (Over The Air)
From the command prompt stop the backend
sudo /etc/init.d/mythtv-backend stop
Then start myth setup.
mythtv-setup
Entering setup is not necessary unless other changes are needed (not sure stopping and restarting the backend is necessary either) As soon as the setup displays exit it. Do not run mythfilldatabase. Finally, restart the backend.
sudo /etc/init.d/mythtv-backend start
Even after these steps the data for program listing appears empty only after entering the frontend and choosing Watch TV did the listing start to repopulate.
By the way this seems to fix the scheduled recordings as well.