Python3.9 django4.1 migrate出现错误(sqlite3)

最新推荐文章于 2024-05-29 11:10:24 发布

Jacky-008

最新推荐文章于 2024-05-29 11:10:24 发布

阅读量504

点赞数

分类专栏： Django 文章标签： sqlite django python

本文链接：https://blog.csdn.net/chenliang1038/article/details/126406282

版权

Django 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

@[toc](Python3.9 django4.1 migrate出现错误(sqlite3))

1、错误

# 使用django自带的数据库sqlite3
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

python manage.py makemigrations 执行该命令没有报错
python manage.py migrate # 这里报错了

(py39env) D:\PersonalProject\MMS>python manage.py makemigrations
No changes detected

(py39env) D:\PersonalProject\MMS>python manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions, users
Running migrations:
  Applying auth.0001_initial...Traceback (most recent call last):
  File "D:\PersonalProject\MMS\manage.py", line 22, in <module>
    main()
  File "D:\PersonalProject\MMS\manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "D:\py39env\lib\site-packages\django\core\management\__init__.py", line 446, in execute_from_command_line
    utility.execute()
  File "D:\py39env\lib\site-packages\django\core\management\__init__.py", line 440, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "D:\py39env\lib\site-packages\django\core\management\base.py", line 402, in run_from_argv
    self.execute(*args, **cmd_options)
  File "D:\py39env\lib\site-packages\django\core\management\base.py", line 448, in execute
    output = self.handle(*args, **options)
  File "D:\py39env\lib\site-packages\django\core\management\base.py", line 96, in wrapped
    res = handle_func(*args, **kwargs)
  File "D:\py39env\lib\site-packages\django\core\management\commands\migrate.py", line 349, in handle
    post_migrate_state = executor.migrate(
  File "D:\py39env\lib\site-packages\django\db\migrations\executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
  File "D:\py39env\lib\site-packages\django\db\migrations\executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
  File "D:\py39env\lib\site-packages\django\db\migrations\executor.py", line 255, in apply_migration
    migration_recorded = True
  File "D:\py39env\lib\site-packages\django\db\backends\sqlite3\schema.py", line 39, in __exit__
    self.connection.check_constraints()
  File "D:\py39env\lib\site-packages\django\db\backends\sqlite3\base.py", line 289, in check_constraints
    for column_name, (
ValueError: too many values to unpack (expected 2)
# ValueError:解包的值太多(预期2)，一直报这个错误

2、我改用postgresql数据库问题解决了

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'TEST',
        'USER': 'postgres',
        'PASSWORD': 'postgres',
        'HOST': '127.0.0.1',
        'PORT': '5432'
    }
}