Erreur 2014 Commands out of sync; You can't run this command
MySQL database connector for Python programming
Brought to you by:
adustman
Menu
▾
▴
#203 Erreur 2014 Commands out of sync; You can't run this command
I'm not really sure I post in the right section since
this involves Zope, ZMyslDA and MySQLdb :
I had this configuration worked great last week :
- Zope-2.7.6 (with python 2.3.5)
Zope-2.8.4 (with python 2.3.5)
Zope-2.9.4 (with python 2.4.4) - ZMySQLDA 2.0.8
- MySQLdb 1.2.1_p2 install from debian package
- mySQL server 5.0.x (I put an X here, I'll explain why
later)
This on Debian Etch, running on a i386 architecture
After having updated my Etch ditrib 3 or 2 days ago (I
really don't remember when exactly...), and restarted
the Zope servers (all versions), the following error
came out when sending a query :
Programming Error 2014 Commands out of sync; You can't
run this command
I'm really sorry because I don't know exactly what have
been upgraded !
After having tried to figure out what the hell was
wrong, I manually switched back to MySQLdb 1.2.1g2
(manually installed in both python2.3 and python2.4),
and it works for all zope versions.
I don't know how to help more to solve this problem. If
it is already known please forgive me... If not, I
ready to give any other informations you may need.
Logged In: YES
user_id=1583135
How I forgot :
The mysql server version is now 5.0.24. I don't know if it
was the same before the bug appears.
Logged In: YES
user_id=71372
The error is addressed here.
https://sourceforge.net/forum/forum.php?thread_id=1559454&forum_id=70461
Apparently the MySQL ABI changed going to 5.0.24, and this
breaks things. Rebuild MySQLdb and you should be fine
(remove old build directory to force rebuild). Debian
packages are being updated. See referenced bugs in above thread.
Logged In: YES
user_id=71372
5.0.24a corrects the incompatible ABI problem.
This may be related to using compound statements which are series of semicolon-separated statements. Patch 3046730 works around this issue for MySQLdb 1.2.2 and patch 3046728 adds a smaller correction to the code of MySQLdb 1.3.0.