Difference between revisions of "OTA Daylight Savings Time Offset Not Honored"

From MythTV Official Wiki
Jump to: navigation, search
(Quick Fix)
(Quick Fix)
Line 20: Line 20:
  
 
To grab new data OTA (Over The Air)
 
To grab new data OTA (Over The Air)
From the command prompt  
+
From the command prompt stop the backend
  
 
     sudo /etc/init.d/mythtv-backend stop
 
     sudo /etc/init.d/mythtv-backend stop
 +
 +
Then start myth setup.
  
 
     sudo mythtv-setup
 
     sudo mythtv-setup

Revision as of 14:26, 3 July 2012

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.

   sudo 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.