<br><br><div><span class="gmail_quote">On 2/28/07, <b class="gmail_sendername">Robin Hill</b> <<a href="mailto:myth@robinhill.me.uk">myth@robinhill.me.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Tue Feb 27, 2007 at 09:10:30PM -0500, Kevin Ould wrote:<br><br>> Hi there,<br>><br>> I have had my Myth box running for a little over a week and so far after a<br>> few initial snafu's it seems to be running like a dream. I have mythweb up
<br>> and running now as well and I noticed a weird date in my backend status<br>> screen. It is telling me I have guide date until 2038, I had a quick look at<br>> the Program table in MySQL but I didn't see a record with that date. Anyone
<br>> have any ideas? Is it a mythweb bug or do I actually have some bad data in<br>> my table? I guess I could empty that table and re-run mythfilldatabase but I<br>> figured I better ask first. Here is exactly what mythweb is reporting.
<br>><br>> Last mythfilldatabase run started on 2007-02-27 06:13 and ended on<br>> 2007-02-27 06:13. Successful.<br>> Suggested next mythfilldatabase run: 2007-02-28 00:03.<br>> There's guide data until 2038-01-09 14:24 (11274 days).
<br>> DataDirect Status: Your subscription expires on 03/19/07 05:07:55<br>><br>> Everything looks good except for the 2038 thing. I partially get my data<br>> from DataDirect and a few channels from EIT.<br>>
<br>I've had this a few times (enough that I've got a daily script cleaning<br>it up) - it's not an issue in itself but it totally stuffs up mythweb<br>listings (as it's downloading a list of dates for the new 35 years).
<br><br>Anyway, there's no need to truncate the table and start again - it's<br>almost certainly a single entry which has the incorrect date. The<br>following SQL will remove any entries with dates more than 1 day in the
<br>past or more that 14 days in the future:<br><br> delete from program<br> where starttime < date_sub(curdate(), interval 1 day)<br> or starttime > date_add(curdate(), interval 14 day);<br><br>
HTH,<br> Robin<br>--<br> ___<br> ( ' } | Robin Hill <<a href="mailto:myth@robinhill.me.uk">myth@robinhill.me.uk</a>> |<br> / / ) | Little Jim says .... |
<br> // !! | "He fallen in de water !!" |<br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org
</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br><br><br></blockquote></div><br>Thanks, worked for me. <br><br>kevin<br>