[mythtv-users] MythLog : Invalid Characters in Program name
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
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):
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