[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