[mythtv-users] Recording Scheduling - DB Error

Fleming flemingp at bigpond.net.au
Mon Oct 6 16:05:07 EDT 2003


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?



More information about the mythtv-users mailing list