SQLDecodeError: FAILED SQL: INSERT INTO "django_migrations"

[XD-Windy]

SQLDecodeError occurs when Starting admin app

Python script

python manage.py migrate

Environment

mongodb v4.0.4 djongo v1.2.31 django v2.1.7

Traceback

File "D:/program/python/VideoWeb/manage.py", line 15, in execute_from_command_line(['manage.py', 'migrate']) File "C:\Anaconda3\lib\site-packages\django\core\management_init_.py", line 381, in execute_from_command_line utility.execute() File "C:\Anaconda3\lib\site-packages\django\core\management_init_.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Anaconda3\lib\site-packages\django\core\management\base.py", line 316, in run_from_argv self.execute(*args, **cmd_options) File "C:\Anaconda3\lib\site-packages\django\core\management\base.py", line 353, in execute output = self.handle(*args, **options) File "C:\Anaconda3\lib\site-packages\django\core\management\base.py", line 83, in wrapped res = handle_func(*args, **kwargs) File "C:\Anaconda3\lib\site-packages\django\core\management\commands\migrate.py", line 203, in handle fake_initial=fake_initial, File "C:\Anaconda3\lib\site-packages\django\db\migrations\executor.py", line 117, in migrate state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial) File "C:\Anaconda3\lib\site-packages\django\db\migrations\executor.py", line 147, in _migrate_all_forwards state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) File "C:\Anaconda3\lib\site-packages\django\db\migrations\executor.py", line 250, in apply_migration self.recorder.record_applied(migration.app_label, migration.name) File "C:\Anaconda3\lib\site-packages\django\db\migrations\recorder.py", line 71, in record_applied self.migration_qs.create(app=app, name=name) File "C:\Anaconda3\lib\site-packages\django\db\models\query.py", line 413, in create obj.save(force_insert=True, using=self.db) File "C:\Anaconda3\lib\site-packages\django\db\models\base.py", line 718, in save force_update=force_update, update_fields=update_fields) File "C:\Anaconda3\lib\site-packages\django\db\models\base.py", line 748, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "C:\Anaconda3\lib\site-packages\django\db\models\base.py", line 831, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "C:\Anaconda3\lib\site-packages\django\db\models\base.py", line 869, in _do_insert using=using, raw=raw) File "C:\Anaconda3\lib\site-packages\django\db\models\manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "C:\Anaconda3\lib\site-packages\django\db\models\query.py", line 1136, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "C:\Anaconda3\lib\site-packages\django\db\models\sql\compiler.py", line 1289, in execute_sql cursor.execute(sql, params) File "C:\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 100, in execute return super().execute(sql, params) File "C:\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "C:\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "C:\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "C:\Anaconda3\lib\site-packages\djongo\cursor.py", line 53, in execute params) File "C:\Anaconda3\lib\site-packages\djongo\sql2mongo\query.py", line 706, in init self.parse() File "C:\Anaconda3\lib\site-packages\djongo\sql2mongo\query.py", line 789, in parse raise exe from e djongo.sql2mongo.SQLDecodeError: FAILED SQL: INSERT INTO "django_migrations" ("app", "name", "applied") VALUES (%(0)s, %(1)s, %(2)s)

[vickyboston20]

djongo.sql2mongo.SQLDecodeError: FAILED SQL: INSERT INTO "django_migrations" ("app", "name", "applied") VALUES (%(0)s, %(1)s, %(2)s) Version: 1.2.31

Im also getting same error while migrating pls guide me to solve this error.

[FurlanV]

I was having the same problem. Just downgrade the sqlparse library to 0.2.4 and it will be solved.

https://github.com/andialbrecht/sqlparse/releases

[vickyboston20]

@FurlanV its working!.

Just what i was looking for Thanks!!!!! You are awesome

[XD-Windy]

@FurlanV its working!.

Just what i was looking for Thanks!!!!! You are awesome

I was having the same problem. Just downgrade the sqlparse library to 0.2.4 and it will be solved.

https://github.com/andialbrecht/sqlparse/releases

Thanks a lot!!! It's really helpful!!!

[fcharmy]

Can anyone explain a little bit? django_migrations table should not migrate to mongodb if router.allow_migrate return False, why it is still trying to create or insert into mongodb?

[rajat45mishra]

djongo.sql2mongo.SQLDecodeError: FAILED SQL: CREATE TABLE "payment_checkout" ("id" int32 NOT NULL PRIMARY KEY AUTOINCREMENT, "check_out_date_time" date NULL)

[rajat45mishra]

please help me to resolve this issue

[artemnesterenko]

I was having the same problem. Just downgrade the sqlparse library to 0.2.4 and it will be solved.

https://github.com/andialbrecht/sqlparse/releases

Having the same problem even with sqlparse 0.2.4 and djongo 1.2.32 and 1.2.31 and django from 2.1.7 to 2.2.1

[artemnesterenko]

I've found what's the problem https://github.com/nesdis/djongo/issues/274#issuecomment-496844652

[kunci115]

i've strange issue, i use sqlparse 0.2.4 and djongo 1.2.33 in local it run without trouble, but since i deploy it via docker to the server, its not work. its very strange, is it because OS dependency of mongo db? because local i'm using macos and docker is linux, same issue with you guys, but only in docker

[umairlakhani]

same issue.. downgraded to sqlparse==0.2.4 and django==1.2.31. but still same error...

[harem234]

Django==3.0.5 sqlparse==0.2.4 djongo==1.3.3 still have issue migrate on docker.

[cuongdaovan]

I was having the same problem. Just downgrade the sqlparse library to 0.2.4 and it will be solved.

https://github.com/andialbrecht/sqlparse/releases no luck

[rishabhrawat4]

Same issue Downgraded sqlparse but still error is happening

[developervick]

Downgraded sqlsparse but getting same error.

[developervick]

I have re-created new fresh project.

I noticed the User model in my app causing that error.

So i changed the name of model User -> user

than i ran only makemigrations myapp commad instead of makemigrations.

And its working fine