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 [email protected].
To post to this group, send email to [email protected].
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/3c33a805-28a5-4ade-a3e2-702fab54ad5e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
