How to solve SQLdecode error when you migrate models in django?

Question

I am new to django, I have created a project and app and I would like to connect my project to the mongodb. when I enter python manage.py migrate command , I am getting below mentioned error.

I have dropped database and cleared all migrations in the django_migration table and deleted migration files in the created migrations folder. Still getting same error.

Please help me with this. Thanks in advance

Error:

    raise TypeError("documents must be a non-empty list")
TypeError: documents must be a non-empty list

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

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

Settings.py

DATABASES = {
    'default': {
        'ENGINE': 'djongo',
        'NAME': 'DB_name',
        'HOST':'localhost',
        # 'PORT': 27017,
        # 'USER':'',
        # 'PASSWORD':''
    },

models.py

from django.db import models

# Create your models here.
class dummy(models.Model):

    name= models.CharField(max_length=100, blank=True, null= True)

The actual TypeError: documents must be a non-empty list is from the pymongo driver and means what it says, as it got an "empty list" when it expected input. Did you actually run a python manage.py makemigrations first? Because the error seems to indicate there's "nothing to do". You said you "deleted", but AFIAK you still need to run the makemigrations first. — Neil Lunn
– Neil Lunn, Commented Mar 16, 2019 at 7:25
I did python manage.py makemigrations first then run python manage.py migrate , still no luck — akhil s
– akhil s, Commented Mar 16, 2019 at 7:32

Adnan Rahman · Accepted Answer · 2019-08-20 05:48:05Z

10

After creating django project uninstall sqlparse by typing

pip3 uninstall sqlparse

Then install sqlparse version=0.2.4 by typing

pip3 install sqlparse==0.2.4

Then migrate mongodb database by typing

python3 manage.py migrate

If you are using python2 then use (pip) instead of (pip3) and (python) instead of (python3) in the command.

answered Aug 20, 2019 at 5:48

Adnan Rahman

1331 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ruli · Accepted Answer · 2021-01-04 12:05:35Z

3

I have solved this problem. The problem may be the version of sqlparse - sqlparse 0.2.4 works well, but sqlparse 0.3.0 not. Use following command:

pip install sqlparse==0.2.4 --user

edited Jan 4, 2021 at 12:05

Ruli

2,83113 gold badges36 silver badges48 bronze badges

answered Mar 17, 2019 at 3:53

binbomb

311 bronze badge

1 Comment

Diego Andrés Díaz Espinoza Over a year ago

Did this and worked. But what is saw -if I do understand well- is install last version of sqlpars. I think this because the output

Collecting sqlparse==0.2.4   Using cached https://files.pythonhosted.org/packages/65/85/20bdd72f4537cf2c4d5d005368d502b2f464ede22982e724a82c86268eda/sqlparse-0.2.4-py2.py3-none-any.whl Installing collected packages: sqlparse Successfully installed sqlparse-0.3.1

Ruli · Accepted Answer · 2021-01-04 11:50:35Z

2

I have updated djongo with pip install --upgrade djongo and I have done the migrations python manage.py migrate --fake-initial and it has been fixed.

edited Jan 4, 2021 at 11:50

Ruli

2,83113 gold badges36 silver badges48 bronze badges

answered Jan 4, 2021 at 10:01

cyrille gate

791 silver badge12 bronze badges

1 Comment

Saikat Mukherjee Over a year ago

Thanks it worked !!! , the problem in on djongo , not sqlprase

Shalini · Accepted Answer · 2020-04-02 10:14:27Z

0

Use python manage.py migrate --fake-initial the first time you migrate your project.

In setting.py add INSTALLED_APPS=[ 'APP_NAME.apps.APP_NAMEConfig', ..., ..., ]

edited Apr 2, 2020 at 10:14

answered Apr 2, 2020 at 9:44

Shalini

12 bronze badges

Comments

Qumber · Accepted Answer · 2020-08-10 11:06:28Z

0

Just install sqlprase to solve this.

Download it github sqlprase

pip install filename.zip

edited Aug 10, 2020 at 11:06

Qumber

14.7k4 gold badges24 silver badges38 bronze badges

answered Mar 19, 2019 at 10:04

Windy Wen

1

Comments

Alex Hurtado · Accepted Answer · 2020-10-04 06:57:55Z

0

I have solved it that way sqlparse==0.2.4 and djongo==1.3.3 and django==2.1.7

answered Oct 4, 2020 at 6:57

Alex Hurtado

4094 silver badges7 bronze badges

Comments

Zeeshan Liaqat · Accepted Answer · 2021-10-26 07:03:17Z

0

Please try to install the sqlparse package, using this command in the terminal.

 pip install sqlparse==0.2.4

edited Oct 26, 2021 at 7:03

answered Oct 26, 2021 at 5:51

Zeeshan Liaqat

1062 silver badges7 bronze badges

Comments

amanb · Accepted Answer · 2019-03-16 10:46:21Z

-2

I have the same issue with u, I tried with sqlite3 as the database, and the data is just like this:

so the data is not empty!!

And I tried to change the sql command as follow(line 760 at sql2mongo\query.py):

statement = statement[0]
    sm_type = statement.get_type()
    if sm_type=='INSERT':
        self._sql = 'INSERT INTO "django_migrations" ("app", "name", "applied") VALUES ("test", "windy", "2019-03-15 12:00")'

but still failed.

edited Mar 16, 2019 at 10:46

amanb

5,4713 gold badges21 silver badges39 bronze badges

answered Mar 16, 2019 at 7:50

Windy Wen

1

Collectives™ on Stack Overflow

How to solve SQLdecode error when you migrate models in django?

8 Answers 8

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related