id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
525	MythWeb replaces the search string with program descriptions	Stuart Auchterlonie	xris	"The scheduler causes SQL error whiles inserting into recordmatch
due to bad quoting of event details.

{{{
2005-10-25 17:34:48.846 DB Error (UpdateMatches):
Query was:
INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, recordid, 0) FROM record, program  INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.recordid = '208' AND program.manualid = 0 AND ( Recorded coverage of the Lords Science and Technology Committee hearing, including evidence from the Pandemic Planning Subgroup UVIG and the Health Protection Agency, from Tuesday 25th October. ) AND channel.visible = 1 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10)  OR  ((record.station = channel.callsign)   AND   ((record.type = 3)    OR   ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)      AND       ((record.type = 5)        OR       ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         )       )      )     )   )   )  ) ))
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 'coverage of the Lords Science and Technology Committee hearing,
}}}"	defect	closed	minor	0.19	mythweb	head	low	invalid	mythweb search		0