生成数据表是出错

来源：3-7 xadmin后台管理系统的配置

Y2sh

2019-03-10

Traceback (most recent call last):
File “D:\pycharm\PyCharm 2018.3.3\helpers\pycharm\django_manage.py”, line 52, in
run_command()
File “D:\pycharm\PyCharm 2018.3.3\helpers\pycharm\django_manage.py”, line 46, in run_command
run_module(manage_file, None, ‘main’, True)
File “c:\users\jia jun\appdata\local\programs\python\python37\Lib\runpy.py”, line 205, in run_module
return _run_module_code(code, init_globals, run_name, mod_spec)
File “c:\users\jia jun\appdata\local\programs\python\python37\Lib\runpy.py”, line 96, in run_module_code
mod_name, mod_spec, pkg_name, script_name)
File “c:\users\jia jun\appdata\local\programs\python\python37\Lib\runpy.py”, line 85, in run_code
exec(code, run_globals)
File “D:/program/dianshan1\manage.py”, line 15, in
execute_from_command_line(sys.argv)
File "D:\Envs\dianshan\lib\site-packages\django\core\management_init.py", line 381, in execute_from_command_line
utility.execute()
File "D:\Envs\dianshan\lib\site-packages\django\core\management_init.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “D:\Envs\dianshan\lib\site-packages\django\core\management\base.py”, line 316, in run_from_argv
self.execute(*args, **cmd_options)
File “D:\Envs\dianshan\lib\site-packages\django\core\management\base.py”, line 353, in execute
output = self.handle(*args, **options)
File “D:\Envs\dianshan\lib\site-packages\django\core\management\base.py”, line 83, in wrapped
res = handle_func(*args, **kwargs)
File “D:\Envs\dianshan\lib\site-packages\django\core\management\commands\makemigrations.py”, line 103, in handle
loader.check_consistent_history(connection)
File “D:\Envs\dianshan\lib\site-packages\django\db\migrations\loader.py”, line 281, in check_consistent_history
applied = recorder.applied_migrations()
File “D:\Envs\dianshan\lib\site-packages\django\db\migrations\recorder.py”, line 61, in applied_migrations
if self.has_table():
File “D:\Envs\dianshan\lib\site-packages\django\db\migrations\recorder.py”, line 44, in has_table
return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
File “D:\Envs\dianshan\lib\site-packages\django\db\backends\base\base.py”, line 255, in cursor
return self._cursor()
File “D:\Envs\dianshan\lib\site-packages\django\db\backends\base\base.py”, line 232, in _cursor
self.ensure_connection()
File “D:\Envs\dianshan\lib\site-packages\django\db\backends\base\base.py”, line 216, in ensure_connection
self.connect()
File “D:\Envs\dianshan\lib\site-packages\django\db\backends\base\base.py”, line 194, in connect
self.connection = self.get_new_connection(conn_params)
File “D:\Envs\dianshan\lib\site-packages\django\db\backends\sqlite3\base.py”, line 159, in get_new_connection
conn = Database.connect(**conn_params)
TypeError: ‘init_command’ is an invalid keyword argument for this function

函数出错

写回答

2回答

bobby

2019-03-17

已采纳

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': "mxonline",
        'USER': 'root',
        'PASSWORD': "root",
         'HOST': "127.0.0.1",
        "PORT":3306,
        'OPTIONS': {
            'init_command': 'SET storage_engine=INNODB,foreign_key_checks = 0,character_set_connection=utf8,collation_connection=utf8_unicode_ci;',
            # "init_command": "SET sql_mode='STRICT_TRANS_TABLES'",
        }
    }
}

拷贝以下这个代码，如果报错里面有storage_engine的错误，就将storage_engine
改成default_storage_engine再试试

Y2sh

非常感谢！

2019-03-17

共1条回复