[mythtv-users] Re: QTime::setHMS Invalid time and same for date

[Kirby Vandivort]

On Sun, Aug 17, 2003 at 01:51:37PM -0500, Kirby Vandivort wrote:
> >From looking through the list archives, I note the following message
> from back in April (which had no responses):
> 
> > I get a bunch of these errors when I go to Program Finder
> >  
> > QTime::setYMD: Invalid date 2935/93/02
> > QTime::setHMS: Invalid time 28:00:00:00
> > 
> > What does this mean? Thanks
> 
> 
> Well, I'm noticing the exact same thing..  I'm running cvs from yesterday,
> and I was just wondering if someone could point me in the right direction
> to fix the problem.  I'm getting the exact same invalid date and time
> as this person was back in April..
> 

I'll answer my own question, kind of..

I tracked these two errors down to old 'record anytime on any channel'
recordings.

I removed the two old ones that I had, and recreated them, and the problem
went away.

FYI, I've included the old and new versions of the mysql row:

OLD, which caused the above error:

mysql> SELECT chanid,starttime,startdate,title,subtitle,description,type FROM re cord;
+--------+-----------+------------+--------------------------------------------- --+--------------------------------+-------------------------------------------- -------------------------------------------------------+------+
| chanid | starttime | startdate  | title   | subtitle                       | description                                                        | type |
+--------+-----------+------------+--------------------------------------------- --+--------------------------------+-------------------------------------------- -------------------------------------------------------+------+
|   NULL | 00:00:00  | 0000-00-00 | As Time Goes By   | NULL                           | NULL                                                        |    4 |


NEW, which doesn't:

mysql> SELECT chanid,starttime,startdate,title,subtitle,description,type FROM record;
+--------+-----------+------------+-----------------------------------------------+--------------------------------+---------------------------------------------------------------------------------------------------+------+
| chanid | starttime | startdate  | title                                         | subtitle                       | description                                      | type |
+--------+-----------+------------+-----------------------------------------------+--------------------------------+---------------------------------------------------------------------------------------------------+------+
|   1013 | 22:02:00  | 2003-08-25 | As Time Goes By                               |                                | Sandy moves into the Pargetter household.                                      |    4 |



-- 

Kirby Vandivort                      Theoretical and Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA