django cannot connect to mysql after upgrade

After upgrade mysql from 5.0.22 to 5.0.24, django cannot
work with
mysql. The error messages as following:
Traceback (most recent call last):
  File "./manage.py", line 11, in ?
    execute_manager(settings)
  File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
line 1343, in execute_manager
    execute_from_command_line(action_mapping, argv)
  File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
line 1260, in execute_from_command_line
    action_mapping[action]()
  File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
line 448, in syncdb
    cursor = connection.cursor()
  File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/db/backends/mysql/base.py",
line 90, in cursor
    self.connection = Database.connect(**kwargs)
  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")


-- 
from czk.
My old mail boxes(czkmail163.com, czkwznc.zj.cn) have been
deprecated. Please contact with me using the following email
address
from now on: czk19790827gmail.com.
If you want to attach word/excel/powerpoint files for me,
please
convert them to pdf. because i have no money to buy
ms-office.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Hi, chen.
I got the same problems after updating my system.
Just re-install MySQLdb-python modules.


zhongke chen wrote:
> After upgrade mysql from 5.0.22 to 5.0.24, django
cannot work with
> mysql. The error messages as following:
> Traceback (most recent call last):
>   File "./manage.py", line 11, in ?
>     execute_manager(settings)
>   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> line 1343, in execute_manager
>     execute_from_command_line(action_mapping, argv)
>   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> line 1260, in execute_from_command_line
>     action_mapping[action]()
>   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> line 448, in syncdb
>     cursor = connection.cursor()
>   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/db/backends/mysql/base.py",
> line 90, in cursor
>     self.connection = Database.connect(**kwargs)
>   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")
>
>
> --
> from czk.
> My old mail boxes(czkmail163.com, czkwznc.zj.cn) have been
> deprecated. Please contact with me using the following
email address
> from now on: czk19790827gmail.com.
> If you want to attach word/excel/powerpoint files for
me, please
> convert them to pdf. because i have no money to buy
ms-office.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

There is no MySQLdb-python package in my system. There is a
package
named python-mysqldb. I reinstalled it and the problem is
still the
same.

My system is debian etch, python-mysqldb is 1.2.1, python
2.3 or
2.4(both have the same problem), django 0.95 or svn(both the
same).


On 8/22/06, Spike^ekipS <spikeekipsgmail.com> wrote:
>
> Hi, chen.
> I got the same problems after updating my system.
> Just re-install MySQLdb-python modules.
>
>
> zhongke chen wrote:
> > After upgrade mysql from 5.0.22 to 5.0.24, django
cannot work with
> > mysql. The error messages as following:
> > Traceback (most recent call last):
> >   File "./manage.py", line 11, in ?
> >     execute_manager(settings)
> >   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> > line 1343, in execute_manager
> >     execute_from_command_line(action_mapping,
argv)
> >   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> > line 1260, in execute_from_command_line
> >     action_mapping[action]()
> >   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/core/management.py",
> > line 448, in syncdb
> >     cursor = connection.cursor()
> >   File
"/usr/lib/python2.4/site-packages/Django-0.95-py2.4.eg
g/django/db/backends/mysql/base.py",
> > line 90, in cursor
> >     self.connection = Database.connect(**kwargs)
> >   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")
> >
> >
> > --
> > from czk.
> > My old mail boxes(czkmail163.com, czkwznc.zj.cn) have been
> > deprecated. Please contact with me using the
following email address
> > from now on: czk19790827gmail.com.
> > If you want to attach word/excel/powerpoint files
for me, please
> > convert them to pdf. because i have no money to
buy ms-office.
>
>
> >
>


-- 
from czk.
My old mail boxes(czkmail163.com, czkwznc.zj.cn) have been
deprecated. Please contact with me using the following email
address
from now on: czk19790827gmail.com.
If you want to attach word/excel/powerpoint files for me,
please
convert them to pdf. because i have no money to buy
ms-office.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

I thinks its a problem on mysql-client package, I haven't
made any
testing with other packages, but probably there are others
broken too.

Hopefully will be corrected soon 

Max

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GS/S d- s: a-29 C++(+++) ULAHI+++ P+ L++>+++ E--- W++ N*
o-- K- w++++
O- M-- V-- PS+ PE Y-- PGP++ t- 5- X+ R tv++ b+ DI+++ D- G++
e++ h+ r+
z**
------END GEEK CODE BLOCK------

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Just wanted to add that I got hit by that too, just now.
Hoping for a
quick fix here or in django...


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

On 8/22/06, Baczek <imbaczekgmail.com> wrote:
>
> Just wanted to add that I got hit by that too, just
now. Hoping for a
> quick fix here or in django...
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=383603

python-mysqldb_1.2.1-p2-3_i386.deb <-- Corrects the
problem

Max

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GS/S d- s: a-29 C++(+++) ULAHI+++ P+ L++>+++ E--- W++ N*
o-- K- w++++
O- M-- V-- PS+ PE Y-- PGP++ t- 5- X+ R tv++ b+ DI+++ D- G++
e++ h+ r+
z**
------END GEEK CODE BLOCK------

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Thanks. Got around that by uninstalling distro's mysqldb
and
easy_installing one.

Now I got hit by
1093 You can't specify target table 'foobar' for update
in FROM clause
The cause seems to be a query of form such as
UPDATE t1 SET column2 = (SELECT MAX(column1) FROM t1);

This seems to be a 'bug' (well, it isn't, really, it's a
problem with
mysql, but still) in the django admin:

/home/djneo/django-trunk/django/db/backends/util.py in
execute
12. return self.cursor.execute(sql, params)

sql is
'INSERT INTO `article_page`
(`article_id`,`lang`,`text`,`page_num`,`_order`) VALUES
(%s,%s,%s,%s,(SELECT COUNT(*) FROM `article_page` WHERE
`article_id` =
%s))'

which bothers mysql. This should be trivial to fix - a
locked
select-insert should suffice.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

MySQL-5.0.24 accidentally introduced an ABI-incompatibilty,
which
caused the "Commands out of sync" error;
MySQL-5.0.24a fixes this.

-- 
This message has been scanned for memes and
dangerous content by MindScanner, and is
believed to be unclean.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---