[mythtv-users] MythLog : Invalid Characters in Program name

Blammo [doh] blammo.doh at gmail.com
Fri Sep 17 15:08:37 EDT 2004


Myth 0.16 atrpms.net build.

Not a dev, should probably wade into this myself. 

I found a problem with MythLogging in which invalid characters in the
name of the program prevent the insert from working correctly. Take a
look...


2004-09-17 12:03:31 Started Commercial Flagging for "Mister Rogers'
Neighborhood" recorded from channel 1008 at Fri Sep 17 11:30:00 2004

DB Error (LogEntry):
Query was:

INSERT INTO mythlog (module, priority, logdate, host, message,
details) values ( 'commflag', 5, now(), 'backend1', 'Commercial
Flagging Started','Started Commercial Flagging for "Mister Rogers'
Neighborhood" recorded from channel 1008 at Fri Sep 17 11:30:00 2004'
);

Driver error was [2/-1]:
QMYSQL3: Unable to execute query

Database error was:
You have an error in your SQL syntax near 'Neighborhood" recorded from
channel 1008 at Fri Sep 17 11:30:00 2004' )' at line 1

It appears the extra ' in the title is borking the insert statement.
Those ' characters should likely either be translated to something
else or dropped,.


More information about the mythtv-users mailing list