[mythtv-users] Recording Scheduling - DB Error

[Fleming]

I've went and checked through the database and the recordings I've 
scheduled through the program guide are there, with a proper chanid. The 
channels in the channel table all have values for chanid, so it's not 
getting the blank value from there. Also, if I put in a value for 
record.chanid like you said, the query works fine.



>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
>>
>>    
>>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>  
>