I Want To Add Social Login in My Project

Using Django Getting Started
1

I Want To Add Social Login in My Project Then This error Comes When I Rum Comand Of python manage.py migrate. How I Solve This
PS C:\Users\Hamza Imran Khan\Desktop\Plotlisting\plotwebsite> python manage.py migrate
SystemCheckError: System check identified some issues:

ERRORS:
socialaccount.SocialApp: (fields.E180) SQLite does not support JSONFields.
PS C:\Users\Hamza Imran Khan\Desktop\Plotlisting\plotwebsite>

2

What version of Django, Python, and Sqlite are you using? Current versions of Sqlite do support JSONField.

3

Django==3.2.20
django-allauth==0.55.0
oauthlib==3.2.2
Pillow==9.5.0
platformdirs==3.10.0
pycparser==2.21
PyJWT==2.8.0
python3-openid==3.2.0
pytz==2023.3
dbsqlite3

4

What I Do Please Help Me

5

@hamzaabialal You did not provide the Python and SQLite versions you’re using but there’s a quick test to confirm whether or not your project supports JSONField.

Open Django’s shell:

python manage.py shell

Run the code below:

>>> import sqlite3
>>> conn = sqlite3.connect(':memory:')
>>> cursor = conn.cursor()
>>> cursor.execute('SELECT JSON(\'{"a": "b"}\')')

If the output looks something like this <sqlite3.Cursor at 0x...>, your project does support JSONField.

In that case, it’s possible that you’re facing a bug (already fixed on newer versions of Django) where a misconfigured DATABASES['default']['NAME'] setting causes that misleading error.

You can read more about it here: #32224 (SQLite3 bad filepath raising as JSON extension error.) – Django

1 Like
6

This Error COmes
C:\Users\Hamza Imran Khan\Desktop\Plotlisting\plotwebsite>python manage.py shell
Python 3.7.9 (tags/v3.7.9:13c94747c7, Aug 17 2020, 16:30:00) [MSC v.1900 64 bit (AMD64)] on win32
Type “help”, “copyright”, “credits” or “license” for more information.
(InteractiveConsole)

import sqlite3
conn = sqlite3.connect(‘:memory:’)
cursor = conn.cursor()
cursor.execute(‘SELECT JSON('{“a”: “b”}')’)
Traceback (most recent call last):
File “”, line 1, in
sqlite3.OperationalError: no such function: JSON

7

Ok, you likely don’t have JSON1 installed.

Here are some instructions on how to set that up: JSON1Extension – Django

The easy fix is usually upgrading to Python3.9 or above if you are on Windows.