id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
2404	Mythburn.py does not like a video filename with an apostrope	mythtv@…	paulh	"The aprostrophe neeeds to be escaped in the sql request.

2006-09-16 13:15:54 Pre-processing file '/video/videos/Reno 911/Season1/106 - Reno 911 - Jones Gets Suspended.avi' of type 'video'
2006-09-16 13:15:54           106 - Reno 911 - Jones Gets Suspended
2006-09-16 13:15:55 Video resolution is 448 by 384
2006-09-16 13:15:55 Pre-processing file '/video/videos/Reno 911/Season1/107 - Reno 911 - Clementine's Pregnant.avi' of type 'video'
2006-09-16 13:15:55 ------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/share/mythtv/mytharchive/scripts/mythburn.py"", line 3392, in ?
    processJob(job)
  File ""/usr/share/mythtv/mytharchive/scripts/mythburn.py"", line 3168, in processJob
    preProcessFile(node,folder)
  File ""/usr/share/mythtv/mytharchive/scripts/mythburn.py"", line 1059, in preProcessFile
    getFileInformation(file, os.path.join(folder, ""info.xml""))
  File ""/usr/share/mythtv/mytharchive/scripts/mythburn.py"", line 907, in getFileInformation
    cursor.execute(sqlstatement)
  File ""/usr/lib/python2.4/site-packages/MySQLdb/cursors.py"", line 137, in execute
    self.errorhandler(self, exc, value)
  File ""/usr/lib/python2.4/site-packages/MySQLdb/connections.py"", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1064, ""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 's Pregnant.avi'' at line 3"")
2006-09-16 13:15:55 ------------------------------------------------------------
"	defect	closed	minor	unknown	mytharchive	0.20	medium	fixed			0