[mythtv-users] mysql error, escaping ' characters?

[Rob Walker]

I noticed in my mysql logfile the following messages:

2004-11-20 21:00:02 Started recording "Retrosexual: The '80s" on channel: 1044 
on cardid: 1, sourceid 1
DB Error (LogEntry):
Query was:
INSERT INTO mythlog (module, priority, logdate, host, message, details) values 
( 'scheduler', 5, now(), 'hostname', 'Schedule Change','Started recording 
"Retrosexual: The '80s" on channel: 1044 on cardid: 1, sourceid 1' );
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 '80s" on channel: 
1044 on cardid: 1, sourceid 1' )' at line 1

2004-11-20 21:00:03 scheduler: Schedule Change
2004-11-20 21:00:03 Changing from None to RecordingOnly
2004-11-20 22:00:00 Finished recording Retrosexual: The '80s on channel: 1044
DB Error (LogEntry):
Query was:
INSERT INTO mythlog (module, priority, logdate, host, message, details) values 
( 'scheduler', 5, now(), 'hostname', 'Finished recording','Finished recording 
Retrosexual: The '80s on channel: 1044' );
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 '80s on channel: 
1044' )' at line 1

rob