Re: django.db.utils.OperationalError: near ")": syntax error ERROR at $ python3 manage.py migrate

Hello Peter,

That looks like https://code.djangoproject.com/ticket/24424

Simon

Le lundi 14 novembre 2016 12:06:41 UTC-5, Peter Sels a écrit :

Dear Django-ers,

I ran into a problem with Django.

--

Situation:

--

I am using version 1.10.3 of Django.

For the fifth time I updated my table related classes in models.py.

The 4 previous time this ran well all through

(1) The server ran and did not complain about syntax errors or anything else.

and

(2) $ python3 manage.py makemigrations

but in

(3) $ python3 manage.py migrate

I get the problem mentioned below when running 

The log of (2) and (3) is given below.

--

Questions:

--

Any tips on how to solve it?

How can I relate this to my own code in models.py?

Do I really need to revert back to my previously (checked in) version of models.py?

And then do small incremental steps again?

Or is there a better way?

(Unluckily I cannot share the models.py file.)

thanks and best regards,

Peter

------------

(2)

$ python3 manage.py makemigrations

Migrations for 'market':

  market/migrations/0006_auto_20161114_1741.py:

    - Alter field code on bidstate

    - Alter field code on coordinationschemevariant

    - Alter field code on networktype

    - Alter field code on segmenttype

Herettix:SmartNet peter$ 

(3)

Herettix:SmartNet peter$ python3 manage.py makemigrations

Did you rename the market.SegmentType model to SegmentSlope? [y/N] y

Did you rename qbiddataarray.segmentType to qbiddataarray.segmentSlope (a ForeignKey)? [y/N] y

Migrations for 'market':

  market/migrations/0007_auto_20161114_1742.py:

    - Rename model SegmentType to SegmentSlope

    - Rename field segmentType on qbiddataarray to segmentSlope

Herettix:SmartNet peter$ 

Herettix:SmartNet peter$ 

Herettix:SmartNet peter$ python3 manage.py migrate

Operations to perform:

  Apply all migrations: admin, auth, contenttypes, market, sessions

Running migrations:

  Applying market.0005_auto_20161114_1254...Traceback (most recent call last):

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute

    return Database.Cursor.execute(self, query, params)

sqlite3.OperationalError: near ")": syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File "manage.py", line 22, in <module>

    execute_from_command_line(sys.argv)

  File "/usr/local/lib/python3.4/site-packages/django/core/management/__init__.py", line 367, in execute_from_command_line

    utility.execute()

  File "/usr/local/lib/python3.4/site-packages/django/core/management/__init__.py", line 359, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/usr/local/lib/python3.4/site-packages/django/core/management/base.py", line 294, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/usr/local/lib/python3.4/site-packages/django/core/management/base.py", line 345, in execute

    output = self.handle(*args, **options)

  File "/usr/local/lib/python3.4/site-packages/django/core/management/commands/migrate.py", line 204, in handle

    fake_initial=fake_initial,

  File "/usr/local/lib/python3.4/site-packages/django/db/migrations/executor.py", line 115, in migrate

    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)

  File "/usr/local/lib/python3.4/site-packages/django/db/migrations/executor.py", line 145, in _migrate_all_forwards

    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

  File "/usr/local/lib/python3.4/site-packages/django/db/migrations/executor.py", line 244, in apply_migration

    state = migration.apply(state, schema_editor)

  File "/usr/local/lib/python3.4/site-packages/django/db/migrations/migration.py", line 129, in apply

    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

  File "/usr/local/lib/python3.4/site-packages/django/db/migrations/operations/fields.py", line 147, in database_forwards

    schema_editor.remove_field(from_model, from_model._meta.get_field(self.name))

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/sqlite3/schema.py", line 249, in remove_field

    self._remake_table(model, delete_fields=[field])

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/sqlite3/schema.py", line 199, in _remake_table

    self.quote_name(model._meta.db_table),

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/base/schema.py", line 112, in execute

    cursor.execute(sql, params)

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/utils.py", line 79, in execute

    return super(CursorDebugWrapper, self).execute(sql, params)

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.4/site-packages/django/db/utils.py", line 94, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/local/lib/python3.4/site-packages/django/utils/six.py", line 685, in reraise

    raise value.with_traceback(tb)

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute

    return Database.Cursor.execute(self, query, params)

django.db.utils.OperationalError: near ")": syntax error

Herettix:SmartNet peter$ 

The line 337 of 

File "/usr/local/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py"

is the return statement on the last line below:

class SQLiteCursorWrapper(Database.Cursor):

    """

    Django uses "format" style placeholders, but pysqlite2 uses "qmark" style.

    This fixes it -- but note that if you want to use a literal "%s" in a query,

    you'll need to use "%%s".

    """

    def execute(self, query, params=None):

        if params is None:

            return Database.Cursor.execute(self, query)

        query = self.convert_query(query)

        return Database.Cursor.execute(self, query, params)

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/ce92e431-d2bf-4208-a686-1a7449488914%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.