'MySQLdb.constants.FIELD_TYPE' has no attribute 'JSON'
1,255 views
Skip to first unread message
Brijesh Soni
Feb 17, 2021, 9:53:23 AM2/17/21
to Django users
Hello All,
I have Install the Python 3.6 32Bit with My SQL 32bit and Install the mysqlclient==1.3.11
but when I am starting the Django with the
runserver command, I am getting below Error
Thanks in Advance.
===============
Error occurred while reading WSGI handler:
Traceback (most recent call last):
File "d:\StockMarketPy\venv36\Lib\site-packages\wfastcgi.py", line 791, in main
env, handler = read_wsgi_handler(response.physical_path)
File "d:\StockMarketPy\venv36\Lib\site-packages\wfastcgi.py", line 633, in read_wsgi_handler
handler = get_wsgi_handler(os.getenv("WSGI_HANDLER"))
File "d:\StockMarketPy\venv36\Lib\site-packages\wfastcgi.py", line 600, in get_wsgi_handler
handler = __import__(module_name, fromlist=[name_list[0][0]])
File "D:\StockMarketPy\src\root\wsgi.py", line 16, in <module>
application = get_wsgi_application()
File "d:\StockMarketPy\venv36\lib\site-packages\django\core\wsgi.py", line 12, in get_wsgi_application
django.setup(set_prefix=False)
File "d:\StockMarketPy\venv36\lib\site-packages\django\__init__.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "d:\StockMarketPy\venv36\lib\site-packages\django\apps\registry.py", line 114, in populate
app_config.import_models()
File "d:\StockMarketPy\venv36\lib\site-packages\django\apps\config.py", line 211, in import_models
self.models_module = import_module(models_module_name)
File "c:\python36-32\lib\importlib\__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "D:\StockMarketPy\src\common\models.py", line 4, in <module>
from django.contrib.auth.models import AbstractBaseUser, PermissionsMixin, UserManager
File "d:\StockMarketPy\venv36\lib\site-packages\django\contrib\auth\models.py", line 2, in <module>
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "d:\StockMarketPy\venv36\lib\site-packages\django\contrib\auth\base_user.py", line 48, in <module>
class AbstractBaseUser(models.Model):
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\models\base.py", line 122, in __new__
new_class.add_to_class('_meta', Options(meta, app_label))
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\models\base.py", line 326, in add_to_class
value.contribute_to_class(cls, name)
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\models\options.py", line 206, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\__init__.py", line 28, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\utils.py", line 214, in __getitem__
backend = load_backend(db['ENGINE'])
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "c:\python36-32\lib\importlib\__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\backends\mysql\base.py", line 29, in <module>
from .introspection import DatabaseIntrospection # isort:skip
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\backends\mysql\introspection.py", line 16, in <module>
class DatabaseIntrospection(BaseDatabaseIntrospection):
File "d:\StockMarketPy\venv36\lib\site-packages\django\db\backends\mysql\introspection.py", line 27, in DatabaseIntrospection
FIELD_TYPE.JSON: 'JSONField',
AttributeError: module 'MySQLdb.constants.FIELD_TYPE' has no attribute 'JSON'
StdOut:
StdErr:
Mohammad Anarul
Feb 18, 2021, 2:50:02 AM2/18/21
to django...@googlegroups.com
You can run it
pip install mysqlclient==2.0.1--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/323d7da8-a17d-4e8e-b6a9-84adc0499f89n%40googlegroups.com.
Brijesh Soni
Feb 18, 2021, 3:32:29 AM2/18/21
to django...@googlegroups.com
Hello Sir,
while installing the mysqlclient 2.0.1 I am getting below error:
pip install mysqlclient==2.0.1
Collecting mysqlclient==2.0.1
Downloading mysqlclient-2.0.1.tar.gz (87 kB)
|████████████████████████████████| 87 kB 725 kB/s
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (setup.py) ... error
ERROR: Command errored out with exit status 1:
command: 'D:\StockMarketPy\venv36\Scripts\python.exe' -u -c 'import sys, setu
ptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pi
p-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';
__file__='"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\my
sqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';f=getattr(tokenize, '"
'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"'
);f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Us
ers\NRSoni\AppData\Local\Temp\pip-wheel-fj39j6k9'
cwd: C:\Users\NRSoni\AppData\Local\Temp\pip-install-udaqqr6h\mysqlclient_
5cc9bbcc19934c03ad04cc767ca22602\
Complete output (23 lines):
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win32-3.6
creating build\lib.win32-3.6\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\_exceptions.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\connections.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\converters.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\release.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\times.py -> build\lib.win32-3.6\MySQLdb
creating build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.6\MySQLdb\constan
ts
copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.6\MySQLdb\constants
running build_ext
building 'MySQLdb._mysql' extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsof
t C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
----------------------------------------
ERROR: Failed building wheel for mysqlclient
Running setup.py clean for mysqlclient
Failed to build mysqlclient
Installing collected packages: mysqlclient
Attempting uninstall: mysqlclient
Found existing installation: mysqlclient 1.3.11
Uninstalling mysqlclient-1.3.11:
Successfully uninstalled mysqlclient-1.3.11
Running setup.py install for mysqlclient ... error
ERROR: Command errored out with exit status 1:
command: 'D:\StockMarketPy\venv36\Scripts\python.exe' -u -c 'import sys, se
tuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\
pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"
'; __file__='"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\
mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';f=getattr(tokenize,
'"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'
"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C
:\Users\NRSoni\AppData\Local\Temp\pip-record-hm46y_k1\install-record.txt' --sing
le-version-externally-managed --compile --install-headers 'D:\StockMarketPy\venv
36\include\site\python3.6\mysqlclient'
cwd: C:\Users\NRSoni\AppData\Local\Temp\pip-install-udaqqr6h\mysqlclien
t_5cc9bbcc19934c03ad04cc767ca22602\
Complete output (23 lines):
running install
running build
running build_py
creating build
creating build\lib.win32-3.6
creating build\lib.win32-3.6\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\_exceptions.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\connections.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\converters.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\release.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\times.py -> build\lib.win32-3.6\MySQLdb
creating build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win32-3.6\MySQLdb\constan
ts
copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.6\MySQLdb\const
ants
copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.6\MySQLdb\constants
running build_ext
building 'MySQLdb._mysql' extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Micros
oft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
----------------------------------------
Rolling back uninstall of mysqlclient
Moving to d:\stockmarketpy\venv36\lib\site-packages\__pycache__\_mysql_excepti
ons.cpython-36.pyc
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-0qfgluzu\_mysql_excepti
ons.cpython-36.pyc
Moving to d:\stockmarketpy\venv36\lib\site-packages\_mysql.cp36-win32.pyd
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-_iiwx7fr\_mysql.cp36-wi
n32.pyd
Moving to d:\stockmarketpy\venv36\lib\site-packages\_mysql_exceptions.py
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-_iiwx7fr\_mysql_excepti
ons.py
Moving to d:\stockmarketpy\venv36\lib\site-packages\mysqlclient-1.3.11.dist-in
fo\
from d:\stockmarketpy\venv36\lib\site-packages\~ysqlclient-1.3.11.dist-info
Moving to d:\stockmarketpy\venv36\lib\site-packages\mysqldb\
from d:\stockmarketpy\venv36\lib\site-packages\~ysqldb
ERROR: Command errored out with exit status 1: 'D:\StockMarketPy\venv36\Scripts\
python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\User
s\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934
c03ad04cc767ca22602\\setup.py'"'"'; __file__='"'"'C:\\Users\\NRSoni\\AppData\\Lo
cal\\Temp\\pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\s
etup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().r
eplace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"
'exec'"'"'))' install --record 'C:\Users\NRSoni\AppData\Local\Temp\pip-record-hm
46y_k1\install-record.txt' --single-version-externally-managed --compile --insta
ll-headers 'D:\StockMarketPy\venv36\include\site\python3.6\mysqlclient' Check th
e logs for full command output.
Collecting mysqlclient==2.0.1
Downloading mysqlclient-2.0.1.tar.gz (87 kB)
|████████████████████████████████| 87 kB 725 kB/s
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (setup.py) ... error
ERROR: Command errored out with exit status 1:
command: 'D:\StockMarketPy\venv36\Scripts\python.exe' -u -c 'import sys, setu
ptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pi
p-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';
__file__='"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\my
sqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';f=getattr(tokenize, '"
'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"'
);f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Us
ers\NRSoni\AppData\Local\Temp\pip-wheel-fj39j6k9'
cwd: C:\Users\NRSoni\AppData\Local\Temp\pip-install-udaqqr6h\mysqlclient_
5cc9bbcc19934c03ad04cc767ca22602\
Complete output (23 lines):
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win32-3.6
creating build\lib.win32-3.6\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\_exceptions.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\connections.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\converters.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\release.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\times.py -> build\lib.win32-3.6\MySQLdb
creating build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.6\MySQLdb\constan
ts
copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.6\MySQLdb\constants
running build_ext
building 'MySQLdb._mysql' extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsof
t C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
----------------------------------------
ERROR: Failed building wheel for mysqlclient
Running setup.py clean for mysqlclient
Failed to build mysqlclient
Installing collected packages: mysqlclient
Attempting uninstall: mysqlclient
Found existing installation: mysqlclient 1.3.11
Uninstalling mysqlclient-1.3.11:
Successfully uninstalled mysqlclient-1.3.11
Running setup.py install for mysqlclient ... error
ERROR: Command errored out with exit status 1:
command: 'D:\StockMarketPy\venv36\Scripts\python.exe' -u -c 'import sys, se
tuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\
pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"
'; __file__='"'"'C:\\Users\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\
mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\setup.py'"'"';f=getattr(tokenize,
'"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'
"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C
:\Users\NRSoni\AppData\Local\Temp\pip-record-hm46y_k1\install-record.txt' --sing
le-version-externally-managed --compile --install-headers 'D:\StockMarketPy\venv
36\include\site\python3.6\mysqlclient'
cwd: C:\Users\NRSoni\AppData\Local\Temp\pip-install-udaqqr6h\mysqlclien
t_5cc9bbcc19934c03ad04cc767ca22602\
Complete output (23 lines):
running install
running build
running build_py
creating build
creating build\lib.win32-3.6
creating build\lib.win32-3.6\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\_exceptions.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\connections.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\converters.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\release.py -> build\lib.win32-3.6\MySQLdb
copying MySQLdb\times.py -> build\lib.win32-3.6\MySQLdb
creating build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win32-3.6\MySQLdb\constan
ts
copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win32-3.6\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.6\MySQLdb\const
ants
copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.6\MySQLdb\constants
running build_ext
building 'MySQLdb._mysql' extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Micros
oft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
----------------------------------------
Rolling back uninstall of mysqlclient
Moving to d:\stockmarketpy\venv36\lib\site-packages\__pycache__\_mysql_excepti
ons.cpython-36.pyc
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-0qfgluzu\_mysql_excepti
ons.cpython-36.pyc
Moving to d:\stockmarketpy\venv36\lib\site-packages\_mysql.cp36-win32.pyd
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-_iiwx7fr\_mysql.cp36-wi
n32.pyd
Moving to d:\stockmarketpy\venv36\lib\site-packages\_mysql_exceptions.py
from C:\Users\NRSoni\AppData\Local\Temp\pip-uninstall-_iiwx7fr\_mysql_excepti
ons.py
Moving to d:\stockmarketpy\venv36\lib\site-packages\mysqlclient-1.3.11.dist-in
fo\
from d:\stockmarketpy\venv36\lib\site-packages\~ysqlclient-1.3.11.dist-info
Moving to d:\stockmarketpy\venv36\lib\site-packages\mysqldb\
from d:\stockmarketpy\venv36\lib\site-packages\~ysqldb
ERROR: Command errored out with exit status 1: 'D:\StockMarketPy\venv36\Scripts\
python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\User
s\\NRSoni\\AppData\\Local\\Temp\\pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934
c03ad04cc767ca22602\\setup.py'"'"'; __file__='"'"'C:\\Users\\NRSoni\\AppData\\Lo
cal\\Temp\\pip-install-udaqqr6h\\mysqlclient_5cc9bbcc19934c03ad04cc767ca22602\\s
etup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().r
eplace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"
'exec'"'"'))' install --record 'C:\Users\NRSoni\AppData\Local\Temp\pip-record-hm
46y_k1\install-record.txt' --single-version-externally-managed --compile --insta
ll-headers 'D:\StockMarketPy\venv36\include\site\python3.6\mysqlclient' Check th
e logs for full command output.
You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/ZEi_IkplsCk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAE59x8eh%3D0Ef7B2bvF8WKAjAMTWrRe2DNQEekfdO7MTMORJtPA%40mail.gmail.com.
Thanks and Regards,
Reply all
Reply to author
Forward
0 new messages