Opened 13 years ago

Closed 13 years ago

#2404 closed defect (fixed)

Mythburn.py does not like a video filename with an apostrope

Reported by: mythtv@… 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 ------------------------------------------------------------

Change History (1)

comment:1 Changed 13 years ago by paulh

Resolution: fixed
Status: newclosed

(In [11221]) Fix a couple of locations where apostrophes in filenames was causing problems. Fixes #2404

Note: See TracTickets for help on using tickets.