[mythtv-users] 0.21-fixes fc10 BE log 'You have an error in your SQL syntax'

[John Pilkington]

I just found the FE of my FE/BE box showing 'No recordings available' 
and a scheduled recording had not started.  A successful recording had 
ended about 5h30m earlier.  A short sample of the backend terminal 
output is shown below.

System is 0.21-fixes/bijou from ATrpms on fc10/x86_64, all up-to-date.

mysql-5.0.83-2.fc10.x86_64 from Fedora updates.

All appears to be working after a BE restart.  I haven't seen any 
similar messages before.  Any suggestions?

John P

--------------
222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz AutoExpire: ERROR: Filesystem 
Info cache is empty, unable to calculate necessary parameters.
222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (LogEntry): 

Query was: 

INSERT INTO mythlog (module, priority, logdate, host, message, details) 
values (:MODULE, :PRIORITY, now(), :HOSTNAME, :MESSAGE, :DETAILS );
Driver error was [2/1064]: 

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 ':MODULE, 
:PRIORITY, now(), :HOSTNAME, :MESSAGE, :DETAILS )' at line 1 
 


222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (DelLogEntry#1):
Query was:
SELECT logid FROM mythlog WHERE module= :MODULE ORDER BY logdate ASC ;
Driver error was [2/1064]:
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 ':MODULE 
ORDER BY logdate ASC' at line 1

222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz mythbackend: Last message 
repeated 2 times: Running housekeeping thread
222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (LogEntry): 

Query was: 

INSERT INTO mythlog (module, priority, logdate, host, message, details) 
values (:MODULE, :PRIORITY, now(), :HOSTNAME, :MESSAGE, :DETAILS );
Driver error was [2/1064]: 

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 ':MODULE, 
:PRIORITY, now(), :HOSTNAME, :MESSAGE, :DETAILS )' at line 1 
 


222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (DelLogEntry#1):
Query was:
SELECT logid FROM mythlog WHERE module= :MODULE ORDER BY logdate ASC ;
Driver error was [2/1064]:
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 ':MODULE 
ORDER BY logdate ASC' at line 1