[mythtv-users] Mythweb status:There's guide data until 2038-01-09 14:24 (11274 days)

[Robin Hill]

On Tue Feb 27, 2007 at 09:10:30PM -0500, Kevin Ould wrote:

> Hi there,
> 
> I have had my Myth box running for a little over a week and so far after a
> few initial snafu's it seems to be running like a dream. I have mythweb up
> and running now as well and I noticed a weird date in my backend status
> screen. It is telling me I have guide date until 2038, I had a quick look at
> the Program table in MySQL but I didn't see a record with that date. Anyone
> have any ideas? Is it a mythweb bug or do I actually have some bad data in
> my table? I guess I could empty that table and re-run mythfilldatabase but I
> figured I better ask first. Here is exactly what mythweb is reporting.
> 
> Last mythfilldatabase run started on 2007-02-27 06:13 and ended on
> 2007-02-27 06:13. Successful.
> Suggested next mythfilldatabase run: 2007-02-28 00:03.
> There's guide data until 2038-01-09 14:24 (11274 days).
> DataDirect Status: Your subscription expires on 03/19/07 05:07:55
> 
> Everything looks good except for the 2038 thing. I partially get my data
> from DataDirect and a few channels from EIT.
> 
I've had this a few times (enough that I've got a daily script cleaning
it up) - it's not an issue in itself but it totally stuffs up mythweb
listings (as it's downloading a list of dates for the new 35 years).

Anyway, there's no need to truncate the table and start again - it's
almost certainly a single entry which has the incorrect date.  The
following SQL will remove any entries with dates more than 1 day in the
past or more that 14 days in the future:

        delete from program
        where starttime < date_sub(curdate(), interval 1 day)
        or starttime > date_add(curdate(), interval 14 day);

HTH,
        Robin
-- 
     ___        
    ( ' }     |       Robin Hill        <myth at robinhill.me.uk>  |
   / / )      | Little Jim says ....                            |
  // !!       |      "He fallen in de water !!"                 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20070228/048b6676/attachment.pgp