error in inserting a longblob data

wes weston wweston at att.net
Tue Feb 24 15:20:04 CET 2004


ketulp_baroda at yahoo.com,

    Is it possible that the error is caused by a string
that has an ' in it? Thus yielding something like
'abc'xyz' - a string with an embedded '. The listed
're looks suspecious; like it was the end of you're
maybe.

wes

ketulp_baroda at yahoo.com wrote:
> Hi
> I am storing the attachment in the database. For some file the data
> gets stored in the database but for other files it gives a MySql
> error. For eg. when I am trying to attach the file say foo.txt it gets
> stored in database correctly whereas the file bar.txt gives an error.
> The error given is:
> 
> 
> Traceback (most recent call last):
>   File "fakeloginserver.py", line 567, in _doRequest
>     _handleRequest(_wfile)
>   File "fakeloginserver.py", line 812, in _handleRequest
>     response.body=_theMethod(**(request.paramMap))
>   File "fakeloginserver.py", line 92, in invokeAddAttachment
>     add.addAttachment(v,filename,values)
>   File "C:\Python23\Lib\site-packages\cherrypy\code\Attachment_Model.py",
> line 26, in addAttachment
>     n=cursor.execute("insert into attachments
> values('%s','%s','%s','%s','%s','%s','%s','%s','%s')"
> %(Attachment_Model.projectid[0],values['issueid'],attachID,datetime,values['attachmentdescription'],contenttype,filename,values['attachmentpath'],submitterID))
>   File "C:\PYTHON23\Lib\site-packages\MySQLdb\cursors.py", line 95, in
> execute
>     return self._execute(query, args)
>   File "C:\PYTHON23\Lib\site-packages\MySQLdb\cursors.py", line 114,
> in _execute
>     self.errorhandler(self, exc, value)
>   File "C:\PYTHON23\Lib\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 're just getting started with CherryPy, read the
> tutorial (in do")
> 
> 
> values['attachmentpath'] contains the file data.
> The data type of the file data is LONGBLOB in MySql.
> I am not getting why it works for some file but not for others.How can
> I make it work for all files??




More information about the Python-list mailing list