[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