{"id":196,"date":"2008-03-09T12:33:08","date_gmt":"2008-03-09T17:33:08","guid":{"rendered":"http:\/\/www.summet.com\/blog\/2008\/03\/09\/fixing-program-guide-data-on-mythtv-after-daylight-savings-time-switch\/"},"modified":"2008-03-09T13:04:21","modified_gmt":"2008-03-09T18:04:21","slug":"fixing-program-guide-data-on-mythtv-after-daylight-savings-time-switch","status":"publish","type":"post","link":"https:\/\/www.summet.com\/blog\/2008\/03\/09\/fixing-program-guide-data-on-mythtv-after-daylight-savings-time-switch\/","title":{"rendered":"Fixing Program Guide data on MythTV after Daylight Savings Time switch"},"content":{"rendered":"<p>I&#39;m running MythTV (Subversion Trunk) on a Ubuntu 7.10 box. After the daylight savings time changeover, my mythtv box had the correct time, but the Program Guide data was still off by an hour.&nbsp; Manually running a mythfilldatabase didn&#39;t fix it. After checking to make sure that my timezone xmltv settings were set to Auto, I decided to manually erase all of the program data from the database.<\/p>\n<p>(After using mysql to connect to the database, I issued the &quot;delete from program;&quot; command to delete all of the program entries.)<\/p>\n<p>Then I re-ran mythfilldatabase and everything was fixed. (I still don&#39;t understand why this didn&#39;t automatically fix itself when the ubuntu box changed it&#39;s timezone, as all of the program data is supposed to be stored under UTC&#8230;)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#39;m running MythTV (Subversion Trunk) on a Ubuntu 7.10 box. After the daylight savings time changeover, my mythtv box had the correct time, but the Program Guide data was still off by an hour.&nbsp; Manually running a mythfilldatabase didn&#39;t fix &hellip; <a href=\"https:\/\/www.summet.com\/blog\/2008\/03\/09\/fixing-program-guide-data-on-mythtv-after-daylight-savings-time-switch\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[31,14],"class_list":["post-196","post","type-post","status-publish","format-standard","hentry","category-linux","tag-dst","tag-mythtv"],"_links":{"self":[{"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":0,"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.summet.com\/blog\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}