[mythtv-users] Recording Scheduling - DB Error

Mike Depot mdepot at comcast.net
Sat Oct 4 10:49:27 EDT 2003


Use (record.chanid = NULL) or put a value there to test against...

----- Original Message ----- 
From: "Fleming" <flemingp at bigpond.net.au>
To: <mythtv-users at mythtv.org>
Sent: Monday, October 06, 2003 1:35 AM
Subject: [mythtv-users] Recording Scheduling - DB Error


> Hi everybody, I get this error when manually scheduling a recording and 
> when I choose Start from the instant recording screen. Scheduling from 
> the program guide doesn't work either, but I think that's a different 
> problem.
> 
> DB Error (loadByProgram):
> Query was:
> SELECT recordid FROM record WHERE record.title = "test " AND 
> ((record.type = 4)  OR  ((record.chanid =  )   AND   ((record.type = 
> 3)    OR   (((TIME_TO_SEC(record.starttime) = 
> TIME_TO_SEC('14:45:19'))       AND      (TIME_TO_SEC(record.endtime) = 
> TIME_TO_SEC('15:45:19'))     )    AND     ((record.type = 2)      OR     
> ((DAYOFWEEK(record.startdate) = DAYOFWEEK('2003-10-04')       AND       
> ((record.type = 5)        OR        ((TO_DAYS(record.startdate) = 
> TO_DAYS('2003-10-04'))         AND         (TO_DAYS(record.enddate) = 
> TO_DAYS('2003-10-04'))         )       )      )     )    )   )  ) ));
> Driver error was [2/-1]:
> QMYSQL3: Unable to execute query
> Database error was:
> You have an error in your SQL syntax.  Check the manual that corresponds 
> to your MySQL server version for the right syntax to use near ')   AND   
> ((record.type = 3)    OR   (((TIME_TO_SEC(record.star
> 
> Now it seems pretty obvious that the problem is the (record.chanid =  ) 
> part. How can I get this working?
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 


More information about the mythtv-users mailing list