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

[Kevin Ould]

On 2/28/07, Robin Hill <myth at robinhill.me.uk> wrote:
>
> 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 !!"                 |
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
Thanks, worked for me.

kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070228/dc708eda/attachment.htm