Problem with MySQL cursor

J. Clifford Dyer jcd at sdf.lonestar.org
Thu Oct 11 15:24:50 CEST 2007


On Thu, Oct 11, 2007 at 03:14:30PM +0200, Florian Lindner wrote regarding Problem with MySQL cursor:
> 
> Traceback (most recent call last):
>   File "manage.py", line 90, in ?
>     addDomain(domainName)
>   File "manage.py", line 27, in addDomain
>     executeSQL(sql,  DOMAIN_TABLE, DOMAIN_FIELD, domainname)
>   File "manage.py", line 22, in executeSQL
>     cursor.execute(sql, args)
>   File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in
> execute
>     self.errorhandler(self, exc, value)
>   File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35,
> in defaulterrorhandler
>     raise errorclass, errorvalue
> _mysql_exceptions.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 ''domains' ('domain') VALUES ('xgm.de')' at
> line 1")
> 
> I see the error: 2 opening quotes but only 1 closing around domains. But
> where do they come from?
> 
> Note that there are no quotes at print sql % args.
> 

No, there are no double quote issues.  The first quote is provided by the error message, and is paired with the quote after the closed parenthesis in ('xgm.de')'.  It is not part of your SQL.

Cheers,
Cliff



More information about the Python-list mailing list