May we see some of your files..precisely settings.py...and have you properly configured your MySQL app...either workbench or xampp? On Apr 12, 2020 20:53, "Andrew Fetting" <[email protected]> wrote:
> Have you tried > pip3 install mysqlclient > > On Sun, Apr 12, 2020, 7:36 AM Arun Sharma <[email protected]> > wrote: > >> python manage.py runserver >> >> >> >> Watching for file changes with StatReloader >> Exception in thread django-main-thread: >> Traceback (most recent call last): >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\backends\mysql\base.py", line 16, in >> <module> >> import MySQLdb as Database >> ModuleNotFoundError: No module named 'MySQLdb' >> >> The above exception was the direct cause of the following exception: >> >> Traceback (most recent call last): >> File >> "C:\Users\Arunkumar\AppData\Local\Programs\Python\Python37-32\lib\threading.py", >> line 926, in _bootstrap_inner >> self.run() >> File >> "C:\Users\Arunkumar\AppData\Local\Programs\Python\Python37-32\lib\threading.py", >> line 870, in run >> self._target(*self._args, **self._kwargs) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\utils\autoreload.py", line 53, in wrappe >> r >> fn(*args, **kwargs) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\core\management\commands\runserver.py", >> line 109, in inner_run >> autoreload.raise_last_exception() >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\utils\autoreload.py", line 76, in raise_ >> last_exception >> raise _exception[1] >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\core\management\__init__.py", line 357, >> in execute >> autoreload.check_errors(django.setup)() >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\utils\autoreload.py", line 53, in wrappe >> r >> fn(*args, **kwargs) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\__init__.py", line 24, in setup >> apps.populate(settings.INSTALLED_APPS) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\apps\registry.py", line 114, in populate >> >> app_config.import_models() >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\apps\config.py", line 211, in import_mod >> els >> self.models_module = import_module(models_module_name) >> File "C:\Users\Arunkumar\AppData\Local\Programs\Python\ >> Python37-32\lib\importlib\__init__.py", line 127, in import_m >> odule >> return _bootstrap._gcd_import(name[level:], package, level) >> File "<frozen importlib._bootstrap>", line 1006, in _gcd_import >> File "<frozen importlib._bootstrap>", line 983, in _find_and_load >> File "<frozen importlib._bootstrap>", line 967, in >> _find_and_load_unlocked >> File "<frozen importlib._bootstrap>", line 677, in _load_unlocked >> File "<frozen importlib._bootstrap_external>", line 728, in exec_module >> File "<frozen importlib._bootstrap>", line 219, in >> _call_with_frames_removed >> File "C:\Users\Arunkumar\PycharmProjects\app2\project\models.py", line >> 4, in <module> >> class Project(models.Model): >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\models\base.py", line 121, in __new__ >> >> new_class.add_to_class('_meta', Options(meta, app_label)) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\models\base.py", line 325, in add_to_ >> class >> value.contribute_to_class(cls, name) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\models\options.py", line 208, in cont >> ribute_to_class >> self.db_table = truncate_name(self.db_table, connection.ops.max_name_ >> length()) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\__init__.py", line 28, in __getattr__ >> >> return getattr(connections[DEFAULT_DB_ALIAS], item) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\utils.py", line 207, in __getitem__ >> backend = load_backend(db['ENGINE']) >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\utils.py", line 111, in load_backend >> return import_module('%s.base' % backend_name) >> File "C:\Users\Arunkumar\AppData\Local\Programs\Python\ >> Python37-32\lib\importlib\__init__.py", line 127, in import_m >> odule >> return _bootstrap._gcd_import(name[level:], package, level) >> File "<frozen importlib._bootstrap>", line 1006, in _gcd_import >> File "<frozen importlib._bootstrap>", line 983, in _find_and_load >> File "<frozen importlib._bootstrap>", line 967, in >> _find_and_load_unlocked >> File "<frozen importlib._bootstrap>", line 677, in _load_unlocked >> File "<frozen importlib._bootstrap_external>", line 728, in exec_module >> File "<frozen importlib._bootstrap>", line 219, in >> _call_with_frames_removed >> File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\ >> site-packages\django\db\backends\mysql\base.py", line 21, in >> <module> >> ) from err >> django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb >> module. >> Did you install mysqlclient? >> >> >> >> >> >> >> >> >> >> >> pip install mysqlclient >> Collecting mysqlclient >> Using cached https://files.pythonhosted.org/packages/d0/97/ >> 7326248ac8d5049968bf4ec708a5d3d4806e412a42e74160d7f266a3e >> 03a/mysqlclient-1.4.6.tar.gz >> Installing collected packages: mysqlclient >> Running setup.py install for mysqlclient ... error >> Complete output from command C:\Users\Arunkumar\ >> PycharmProjects\app2\venv\Scripts\python.exe -u -c "import setupto >> ols, tokenize;__file__='C:\\Users\\ARUNKU~1\\AppData\\Local\\ >> Temp\\pip-install-5yg5lx4_\\mysqlclient\\setup.py';f=geta >> ttr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', >> '\n');f.close();exec(compile(code, __file__, 'exec >> '))" install --record >> C:\Users\ARUNKU~1\AppData\Local\Temp\pip-record-9s3l9mgb\install-record.txt >> --single-version-ext >> ernally-managed --compile --install-headers C:\Users\Arunkumar\ >> PycharmProjects\app2\venv\include\site\python3.7\mysqlc >> lient: >> running install >> running build >> running build_py >> creating build >> creating build\lib.win32-3.7 >> creating build\lib.win32-3.7\MySQLdb >> copying MySQLdb\__init__.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\_exceptions.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\compat.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\connections.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\converters.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\cursors.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\release.py -> build\lib.win32-3.7\MySQLdb >> copying MySQLdb\times.py -> build\lib.win32-3.7\MySQLdb >> creating build\lib.win32-3.7\MySQLdb\constants >> copying MySQLdb\constants\__init__.py -> build\lib.win32-3.7\MySQLdb\ >> constants >> copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.7\MySQLdb\ >> constants >> copying MySQLdb\constants\CR.py -> build\lib.win32-3.7\MySQLdb\ >> constants >> copying MySQLdb\constants\ER.py -> build\lib.win32-3.7\MySQLdb\ >> constants >> copying MySQLdb\constants\FIELD_TYPE.py -> >> build\lib.win32-3.7\MySQLdb\constants >> copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.7\MySQLdb\ >> constants >> running build_ext >> building 'MySQLdb._mysql' extension >> creating build\temp.win32-3.7 >> creating build\temp.win32-3.7\Release >> creating build\temp.win32-3.7\Release\MySQLdb >> C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\ >> Tools\MSVC\14.25.28610\bin\HostX86\x86\cl.exe /c >> /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,4,6,'final',0) >> -D__version__=1.4.6 "-IC:\Program Files (x86)\MySQL >> \MySQL Connector C 6.1\include\mariadb" -IC:\Users\Arunkumar\ >> PycharmProjects\app2\venv\include -IC:\Users\Arunkumar\Ap >> pData\Local\Programs\Python\Python37-32\include >> -IC:\Users\Arunkumar\AppData\Local\Programs\Python\Python37-32\include >> "-IC:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\ >> Tools\MSVC\14.25.28610\include" "-IC:\Program Fi >> les (x86)\Windows Kits\10\include\10.0.17134.0\ucrt" "-IC:\Program Files >> (x86)\Windows Kits\10\include\10.0.17134.0\sh >> ared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\um" >> "-IC:\Program Files (x86)\Windows Kits\10\inc >> lude\10.0.17134.0\winrt" "-IC:\Program Files (x86)\Windows >> Kits\10\include\10.0.17134.0\cppwinrt" /TcMySQLdb/_mysql.c >> /Fobuild\temp.win32-3.7\Release\MySQLdb/_mysql.obj /Zl >> /D_CRT_SECURE_NO_WARNINGS >> _mysql.c >> MySQLdb/_mysql.c(29): fatal error C1083: Cannot open include file: >> 'mysql.h': No such file or directory >> error: command 'C:\\Program Files (x86)\\Microsoft Visual >> Studio\\2019\\BuildTools\\VC\\Tools\\MSVC\\14.25.28610\\ >> bin\\HostX86\\x86\\cl.exe' failed with exit status 2 >> >> ---------------------------------------- >> Command "C:\Users\Arunkumar\PycharmProjects\app2\venv\Scripts\python.exe >> -u -c "import setuptools, tokenize;__file__=' >> C:\\Users\\ARUNKU~1\\AppData\\Local\\Temp\\pip-install- >> 5yg5lx4_\\mysqlclient\\setup.py';f=getattr(tokenize, 'open', op >> en)(__file__);code=f.read().replace('\r\n', >> '\n');f.close();exec(compile(code, >> __file__, 'exec'))" install --record C: >> \Users\ARUNKU~1\AppData\Local\Temp\pip-record-9s3l9mgb\install-record.txt >> --single-version-externally-managed --compil >> e --install-headers C:\Users\Arunkumar\PycharmProjects\app2\venv\ >> include\site\python3.7\mysqlclient" failed with error >> code 1 in C:\Users\ARUNKU~1\AppData\Local\Temp\pip-install- >> 5yg5lx4_\mysqlclient\ >> >> >> >> >> >> >> >> >> >> >> >> -- >> 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 [email protected]. >> To view this discussion on the web visit https://groups.google.com/d/ >> msgid/django-users/c788f1bd-0873-469b-ac3f-7eba6089f7a1% >> 40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/c788f1bd-0873-469b-ac3f-7eba6089f7a1%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/django-users/CAOn-ttimiyTTqz%3DCQmEDLsGpHKC1y_ > oYehf1nF_F-aorEEjzYw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAOn-ttimiyTTqz%3DCQmEDLsGpHKC1y_oYehf1nF_F-aorEEjzYw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPsfuodQhL6mWhhSDEUybmoyVb%2Bbk5%3Dz_QL-XMT9_H2%2BPE1cgA%40mail.gmail.com.
