<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Oct 31, 2018, at 4:54 PM, Tom Dexter <<a href="mailto:digitalaudiorock@gmail.com" class="">digitalaudiorock@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">On 10/31/18, Jay Harbeston (ISeePeople) <</span><a href="mailto:jharbestonus@gmail.com" style="font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">jharbestonus@gmail.com</a><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">> wrote:</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><blockquote type="cite" style="font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">Looks like the date is getting interpreted as being in the future?<br class=""><br class="">Maybe time zone settings are incorrect..<br class=""><br class="">Just a theory<br class=""><br class=""><blockquote type="cite" class=""><blockquote type="cite" class=""><br class=""></blockquote>The following recordings will be deleted<br class="">mythback: Judge Judy - Random Vandalism or Hilary Clinton Attack?<br class=""> 1021_20181031203000.ts<br class=""><br class=""> Count: 1<br class="">Are you sure you want to continue?<br class=""><blockquote type="cite" class="">yes<br class=""></blockquote>Traceback (most recent call last):<br class="">File "./find_orphans.py", line 230, in <module><br class=""> main()<br class="">File "./find_orphans.py", line 214, in main<br class=""> opt[1](opt[2])<br class="">File "./find_orphans.py", line 129, in delete_recs<br class=""> rec.delete(True, True)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/dataheap.py", line<br class="">375, in delete<br class=""> return self.getProgram().delete(force, rerecord)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/dataheap.py", line<br class="">387, in getProgram<br class=""> return Program.fromRecorded(self)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line<br class="">946, in fromRecorded<br class=""> return be.getRecording(rec.chanid, rec.starttime)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line<br class="">647, in getRecording<br class=""> return Program(res[1:], db=self.db)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line<br class="">875, in __init__<br class=""> DictData.__init__(self, raw)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 148,<br class="">in __init__<br class=""> data = self._process(data)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 164,<br class="">in _process<br class=""> data[i] = self._trans[self._field_type[i]](v)<br class="">File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 104,<br class="">in <lambda><br class=""> lambda x: datetime.fromtimestamp(x, datetime.UTCTZ())\<br class="">File "/usr/lib/python2.7/site-packages/MythTV/utility/dt.py", line<br class="">304, in fromtimestamp<br class=""> obj = super(datetime, cls).fromtimestamp(float(timestamp), tz)<br class="">ValueError: timestamp out of range for platform time_t<br class=""><br class="">Here's the record in the recorded table...nothing wrong there:<br class=""><br class="">mysql> select * from recorded where title='judge judy'\G<br class="">*************************** 1. row ***************************<br class=""> chanid: 1021<br class=""> starttime: 2018-10-31 20:30:00<br class=""> endtime: 2018-10-31 20:31:00<br class=""> title: Judge Judy<br class=""> subtitle: Random Vandalism or Hilary Clinton Attack?<br class=""> description: A stranger allegedly keys a six-foot scratch on the<br class="">side of a car that has a Clinton bumper sticker on it.<br class=""> season: 0<br class=""> episode: 0<br class=""> category: Reality<br class=""> hostname: mythback<br class=""> bookmark: 0<br class=""> editing: 0<br class=""> cutlist: 0<br class=""> autoexpire: 1<br class=""> commflagged: 0<br class=""> recgroup: Default<br class=""> recordid: 8308<br class=""> seriesid: EP00188710<br class=""> programid: EP001887106287<br class=""> inetref:<br class=""> lastmodified: 2018-10-31 16:30:00<br class=""> filesize: 35206384<br class=""> stars: 0<br class="">previouslyshown: 0<br class="">originalairdate: 2018-10-31<br class=""> preserve: 0<br class=""> findid: 0<br class="">deletepending: 0<br class=""> transcoder: 0<br class=""> timestretch: 1<br class=""> recpriority: 0<br class=""> basename: 1021_20181031203000.ts<br class=""> progstart: 2018-10-31 20:00:00<br class=""> progend: 2018-10-31 20:30:00<br class=""> playgroup: Default<br class=""> profile: Default<br class=""> duplicate: 1<br class=""> transcoded: 0<br class=""> watched: 0<br class=""> storagegroup: Default<br class="">bookmarkupdate: 0000-00-00 00:00:00<br class=""> recgroupid: 1<br class=""> recordedid: 5582<br class=""> inputname: HDHR 1<br class="">1 row in set (0.01 sec)<br class=""><br class="">Tom<br class=""></blockquote></blockquote><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">You're just seeing the UTC times in the database which are correct (4</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">hours after EDT here):</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">date</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Wed Oct 31 16:52:34 EDT 2018</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">date -u</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Wed Oct 31 20:52:37 UTC 2018</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""></div></blockquote><br class=""></div><div>I agree with what you mentioned, but I bet there is still something fishy about time zone. Would be interesting to see what happens when you try this utility in 4+ hours. I am guessing the date will be in the past and will work fine.</div><div><br class=""></div><br class=""></body></html>