id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 5853 Convert MythTV (database, protocol, etc.) to use UTC times Nick Morrott beirdo "First let me add that danielk has advised on IRC that this bug is not likely to be resolved due to a lack of developer time, and the ticket will be closed due to this. However, this is a real issue which could affect any user of MythTV if their country employs daylight savings times during the year. My feeling is that a valid bug should be listed on trac irrespective of whether current capacity dictates that it will not be resolved in a timely fashion. That said: MythTV does not currently store programme timings with a UTC offset to indicate the 'absolute' time a programme is broadcast. This requirement is a fundamental requirement during DST changeovers to be able to determine exactly when a programme should be scheduled for recording. I use the XMLTV tv_grab_uk_rt grabber, which like most XMLTV grabbers, outputs programme data including UTC offsets. Data for tonight's UK DST changeover (2008-10-26 0100 +0000) for The Hallmark Channel includes: {{{ Hustle Drama serial about a team of con artists. Albert is attacked in Las Vegas so the team plot revenge in the form o Adrian Lester Marc Warren Robert Glenister Jaime Murray Robert Vaughn Drama Law & Order: Criminal Intent Stress Position Crime drama series that looks inside the minds of criminals. Goren and Eames investigate when a prison guard is Vincent D'Onofrio Kathryn Erbe Courtney B Vance Jamey Sheridan Drama Law & Order: Special Victims Unit Privilege Drama series about an elite force based in New York which investigates sexually orientated crimes, while dealing Christopher Meloni Mariska Hargitay Dann Florek Richard Belzer Ice-T Stephanie March Drama }}} One will note that the programme ""LAO:CI Stress Position"" has a start time given in BST, and an end time given in GMT. Importantly, the three programmes follow one after the other, with no timing gaps when UTC offsets are taken into account. When the XMLTV data is imported into MythTV via mythfilldatabase, these programme entries end up as: {{{ INSERT INTO `program` (`chanid`, `starttime`, `endtime`, `title`, `subtitle`, `description`, `category`, `category_type`, `airdate`, `stars`, `previouslyshown`, `title_pronounce`, `stereo`, `subtitled`, `hdtv`, `closecaptioned`, `partnumber`, `parttotal`, `seriesid`, `originalairdate`, `showtype`, `colorcode`, `syndicatedepisodenumber`, `programid`, `manualid`, `generic`, `listingsource`, `first`, `last`, `audioprop`, `subtitletypes`, `videoprop`) VALUES (2190, '2008-10-26 00:00:00', '2008-10-26 01:00:00', 'Hustle', '', 'Drama serial about a team of con artists. Albert is attacked in Las Vegas so the team plot revenge in the form of their most sophisticated con yet. Will they succeed in targeting a $5million fruit machine jackpot without attracting unwanted attention?', 'Drama', '', 2008, 0, 0, '', 0, 0, 0, 0, 0, 0, '83667749', '0000-00-00', '', '', '', '', 0, 0, 0, 1, 1, '', '', ''), (2190, '2008-10-26 01:00:00', '2008-10-26 02:00:00', 'Law & Order: Criminal Intent : Law & Order: Special Victims Unit', 'Privilege', 'Crime drama series that looks inside the minds of criminals. Goren and Eames investigate when a prison guard is murdered. : Drama series about an elite force based in New York which investigates sexually orientated crimes, while dealing with the effects that their investigations have on their personal lives. A student appears to have committed suicide, but the circumstances seem suspicious.', 'Drama', '', 2008, 0, 0, '', 0, 0, 0, 0, 0, 0, '80615876', '0000-00-00', '', '', '', '', 0, 0, 0, 1, 1, '', '', ''), }}} One will see that the two Law and Order episodes are concatenated into a single entry in mythconverg.program - causing any regular recording schedules to fail if they are based on these titles. This issue rears its ugly head for me twice a year (my first mention of this issue on the users list was in 2005 - http://www.gossamer-threads.com/lists/mythtv/users/157557). I updated the tv_grab_uk_rt grabber to output correct programme timings during these changeover periods, but we need to have them handled correctly in MythTV. This will not be a trivial task, but it needs to be done, and should not be swept under the carpet." task closed minor unknown MythTV - General unknown medium invalid mythtv mythfilldatabase daylight savings utc offset 0