[mythtv-users] DB Error in logs

Bill Oberman Oberman at BodyMedia.Com
Thu Dec 2 16:32:03 UTC 2004

The other night, I lost my recording of the Daily Show, so I looked in
the logs.  Directly before the Daily Show, I had recorded Chappelle's
Show.  I found this in the logs:


DB Error (LogEntry):

Query was:

INSERT INTO mythlog (module, priority, logdate, host, message, details)
values ( 'scheduler', 5, 

now(), 'obergrim', 'Finished recording','Finished recording Chappelle's
Show on channel: 1054' );

Driver error was [2/1064]:

QMYSQL3: Unable to execute query

Database error was:

You have an error in your SQL syntax near 's Show on channel: 1054' )'
at line 1


I'm running a stock 0.16 system on redhat 9 with atrpms.  Based on the
error message, I'd guess the apostrophe in Chappelle's Show wasn't
escaped, leading to invalid SQL.  Is this known and/or fixed?  Even if
it's fixed, I don't like to get into CVS builds.... any workarounds?  It
looks like built in logging related, so I could turn that off.





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20041202/b6b7bc68/attachment.htm

More information about the mythtv-users mailing list