Opened 18 years ago
Closed 18 years ago
#2404 closed defect (fixed)
Mythburn.py does not like a video filename with an apostrope
Reported by: | Owned by: | paulh | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mytharchive | Version: | 0.20 |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
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 ------------------------------------------------------------
(In [11221]) Fix a couple of locations where apostrophes in filenames was causing problems. Fixes #2404