from _sqlite3 import * ImportError: DLL load failed: 找不到指定的子產品。

*Error creating Django application: Error on python side. Exit code: 1, err: Traceback (most recent call last):

File "manage.py", line 21, in

main()

File "manage.py", line 17, in main

execute_from_command_line(sys.argv)

File "C:\Anaconda3\envs\django\lib\site-packages\django\core\management__init__.py", line 381, in execute_from_command_line

utility.execute()

File "C:\Anaconda3\envs\django\lib\site-packages\django\core\management__init__.py", line 357, in execute

django.setup()

File "C:\Anaconda3\envs\django\lib\site-packages\django__init__.py", line 24, in setup

apps.populate(settings.INSTALLED_APPS)

File "C:\Anaconda3\envs\django\lib\site-packages\django\apps\registry.py", line 114, in populate

app_config.import_models()

File "C:\Anaconda3\envs\django\lib\site-packages\django\apps\config.py", line 211, in import_models

self.models_module = import_module(models_module_name)

File "C:\Anaconda3\envs\django\lib\importlib__init__.py", line 127, in import_module

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:\Anaconda3\envs\django\lib\site-packages\django\contrib\auth\models.py", line 2, in

from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager

File "C:\Anaconda3\envs\django\lib\site-packages\django\contrib\auth\base_user.py", line 47, in

class AbstractBaseUser(models.Model):

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\models\base.py", line 117, in new

new_class.add_to_class('_meta', Options(meta, app_label))

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\models\base.py", line 321, in add_to_class

value.contribute_to_class(cls, name)

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\models\options.py", line 204, in contribute_to_class

self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())

File "C:\Anaconda3\envs\django\lib\site-packages\django\db__init__.py", line 28, in getattr

return getattr(connections[DEFAULT_DB_ALIAS], item)

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\utils.py", line 201, in getitem

backend = load_backend(db['ENGINE'])

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\utils.py", line 110, in load_backend

return import_module('%s.base' % backend_name)

File "C:\Anaconda3\envs\django\lib\site-packages\django\db\backends\sqlite3\base.py", line 13, in

from sqlite3 import dbapi2 as Database

File "C:\Anaconda3\envs\django\lib\sqlite3__init__.py", line 23, in

from sqlite3.dbapi2 import *

File "C:\Anaconda3\envs\django\lib\sqlite3\dbapi2.py", line 27, in

from _sqlite3 import

ImportError: DLL load failed: 找不到指定的子產品。

out:

解決方法

下載下傳sqlite-tools sqlite-dll(可在sqllite官網下載下傳,注意系統版本)

下載下傳完成後解壓到環境變量含有的目錄,若不清楚放在哪裡,可直接放在python.exe所在的目錄,