运行时报错Unknown system variable 'storage_engine'"
来源:3-1 项目初始化

叉歪叉
2017-10-10
Performing system checks...
Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x03BC8A50>
Traceback (most recent call last):
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
self.connect()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\MySQLdb\connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1193, "Unknown system variable 'storage_engine'")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\utils\autoreload.py", line 228, in wrapper
fn(*args, **kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\core\management\commands\runserver.py", line 125, in inner_run
self.check(display_num_errors=True)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\core\management\base.py", line 359, in check
include_deployment_checks=include_deployment_checks,
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\core\management\base.py", line 346, in _run_checks
return checks.run_checks(**kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\core\checks\registry.py", line 81, in run_checks
new_errors = check(app_configs=app_configs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\core\checks\model_checks.py", line 30, in check_all_models
errors.extend(model.check(**kwargs))
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\base.py", line 1284, in check
errors.extend(cls._check_fields(**kwargs))
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\base.py", line 1359, in _check_fields
errors.extend(field.check(**kwargs))
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\fields\__init__.py", line 913, in check
errors = super(AutoField, self).check(**kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\fields\__init__.py", line 219, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\fields\__init__.py", line 322, in _check_backend_specific_checks
return connections[db].validation.check_field(self, **kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\validation.py", line 49, in check_field
field_type = field.db_type(self.connection)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\models\fields\__init__.py", line 644, in db_type
return connection.data_types[self.get_internal_type()] % data
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\base.py", line 174, in data_types
if self.features.supports_microsecond_precision:
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\features.py", line 53, in supports_microsecond_precision
return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\base.py", line 385, in mysql_version
with self.temporary_connection() as cursor:
File "D:\Python34\Lib\contextlib.py", line 59, in __enter__
return next(self.gen)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 591, in temporary_connection
cursor = self.cursor()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 254, in cursor
return self._cursor()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 229, in _cursor
self.ensure_connection()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
self.connect()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\utils\six.py", line 685, in reraise
raise value.with_traceback(tb)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
self.connect()
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\django\db\backends\mysql\base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Users\xyx\Envs\VueShop\lib\site-packages\MySQLdb\connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
我用的是3.4的python,下载的mysqlclient-1.3.12-cp34-cp34m-win32.whl这个包
1回答
-
叉歪叉
提问者
2017-10-10
已解决 刚看到有同学分享了解决办法 设置的语句改为 SET default_storage_engine=INNODB就可以了
012017-10-11
Python前后端分离开发Vue+Django REST framework实战
2880 学习 · 2467 问题
相似问题