Re: 'MySQLdb.constants.FIELD_TYPE' has no attribute 'JSON'

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.

On Thu, Feb 18, 2021 at 1:20 PM Mohammad Anarul <mdanarul7075@gmail.com> wrote:

You can run it

pip install mysqlclient==2.0.1

On Wed, Feb 17, 2021 at 8:53 PM Brijesh Soni <ibrijeshsoni@gmail.com> wrote:

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: 

--
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+unsubscribe@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.

--
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+unsubscribe@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,

Brijesh Soni
Mobile :-> +919819855471

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAErQ6Yw_8nU6gAPRuVZCy_Mr%2BUHFDU%3DuTaZpdAxhj9w%2B8uO4%2Bg%40mail.gmail.com.