MySQLdbd error. Perhpas it isn't installed?

MRAB python at mrabarnett.plus.com
Tue Mar 26 20:41:19 EDT 2013


On 26/03/2013 21:24, Νίκος Γκρ33κ wrote:
> Hello today i deiced to go form python 2.6 to python 3.2.3
>
> although in 2.6 my script runs in the ht enewest python i ge this error:
>
>
> Traceback (most recent call last):
>    File "/opt/python3/lib/python3.2/site-packages/MySQL_python-1.2.3-py3.2-linux-x86_64.egg/MySQLdb/cursors.py", line 171, in execute
>      r = self._query(query)
>    File "/opt/python3/lib/python3.2/site-packages/MySQL_python-1.2.3-py3.2-linux-x86_64.egg/MySQLdb/cursors.py", line 330, in _query
>      rowcount = self._do_query(q)
>    File "/opt/python3/lib/python3.2/site-packages/MySQL_python-1.2.3-py3.2-linux-x86_64.egg/MySQLdb/cursors.py", line 294, in _do_query
>      db.query(q)
> _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 '%s' at line 1")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>    File "metrites.py", line 193, in <module>
>      cur.execute( '''SELECT hits FROM counters WHERE url = %s''', (page,) )
>    File "/opt/python3/lib/python3.2/site-packages/MySQL_python-1.2.3-py3.2-linux-x86_64.egg/MySQLdb/cursors.py", line 184, in execute
>      self.errorhandler(self, exc, value)
>    File "/opt/python3/lib/python3.2/site-packages/MySQL_python-1.2.3-py3.2-linux-x86_64.egg/MySQLdb/connections.py", line 36, 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 '%s' at line 1")
>
>
>
> you can also see it at http://superhost.gr
>
> Any ideas what might be the problem?
>
> My webhost (hostgator.com) says that The MySQLdb module is already installed for python 3 on this server.
>
> Can you please tell me what's the nature of this error?
>
> Thank you.
>
The error's in the SQL.



More information about the Python-list mailing list