On Sat, Mar 22, 2014 at 7:48 PM, [email protected] <[email protected]> wrote: > With django 1.6.2, python3 and MySQL manage.py inspectdb brings this error: > > django.db.utils.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 AND table_schema = DATABASE()\n > AND character_maximum_length IS' at line 2") > > I put some print statements in > - django/db/backends/mysql/introspection.py line 43 > - django/db/utils.py line 111, 125, 151, 154, 165, 202 > - django/db/backends/util.py line 47 > > The output with traceback shows in line 22 (from line 43 introspections.py) > the table_name auth_group > and then from util line 47 the sql statement in which the table_name should > be inserted. > > But that doesn't happened. The executed sql statement contains still %s and > not the table name. > > Any idea?
It's weird. Can you modify the execute() method in django/db/backends/mysql/base.py to verify the args argument actually contains your 'auth_user' table name? Also, what's the origin of the python-MySQLdb driver you are using? AFAIK there isn't a 1.2.3 version compatible with Python 3.x. See https://docs.djangoproject.com/en/1.6/ref/databases/#python-3 -- Ramiro Morales @ramiromorales -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAO7PdF-RfkDO-feDNZoQNLYhyNSRvDk42zNfkja_9fgJ45y9EQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
