_mysql_exceptions.ProgrammingError: 2014
MySQL database connector for Python programming
Brought to you by:
adustman
Menu
▾
▴
Hi,
I'm tryin to connect to a mysql database from a debian machine.
>>> import MySQLdb
>>> connessione = MySQLdb.connect(user="pippo",passwd="pippo",db="test",host="192.168.0.210")
But I receive
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.4/site-packages/MySQLdb/init.py", line 75, in Connect
return Connection(args, *kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 207, in init
self.autocommit(False)
_mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")
Using these lines in a different machine it doesn't work.
How can I find where is the problem?
Thank you
That shouldn't happen, or perhaps I should say, it only happens for you (never seen that happen). What versions of everything do you have? I see Python-2.4 and Debian, and that's it. Using their packages for everything?
uhm... I've done a reinstall of all python and mysql packages and now it works... (after restart)
Maybe a bug in some debian packages...
See http://bugs.mysql.com/bug.php?id=21543 and http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=383603 for more information about this.
MySQL-5.0.24a fixes the ABI incompatibility introduced in 5.0.24.