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.