python - FOREIGN KEY 约束失败
问题描述
使用 Django 2.0.5 我遇到了管理面板的问题。通过管理面板添加或保存数据会出现“django.db.utils.IntegrityError: FOREIGN KEY constraint failed”错误。在模型中没有可以引用的外键。
模型.py
class JobTitle(models.Model):
job_title = models.CharField(max_length=200)
管理员.py
class JobTitleAdmin(admin.ModelAdmin):
list_display = ['job_title',]
admin.site.register(JobTitle, JobTitleAdmin)
从前端使用 PUSH 添加相同的数据是有效的,只有从管理面板才会出现此错误。
编辑:
Environment:
Request Method: POST
Request URL: http://localhost:8000/admin/login_app/locations/add/
Django Version: 2.0.5
Python Version: 3.6.4
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'rest_framework',
'rest_framework.authtoken',
'login_app',
'corsheaders',
'rest_auth']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'corsheaders.middleware.CorsMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
Traceback:
File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py" in _commit
239. return self.connection.commit()
The above exception (FOREIGN KEY constraint failed) was the direct cause of the following exception:
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
35. response = get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
128. response = self.process_exception_by_middleware(e, request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
126. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/admin/options.py" in wrapper
574. return self.admin_site.admin_view(view)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/admin/sites.py" in inner
223. return view(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/admin/options.py" in add_view
1553. return self.changeform_view(request, None, form_url, extra_context)
File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py" in _wrapper
62. return bound_func(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py" in bound_func
58. return func.__get__(self, type(self))(*args2, **kwargs2)
File "/usr/local/lib/python3.6/site-packages/django/contrib/admin/options.py" in changeform_view
1450. return self._changeform_view(request, object_id, form_url, extra_context)
File "/usr/local/lib/python3.6/site-packages/django/db/transaction.py" in __exit__
212. connection.commit()
File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py" in commit
261. self._commit()
File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py" in _commit
239. return self.connection.commit()
File "/usr/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py" in _commit
239. return self.connection.commit()
Exception Type: IntegrityError at /admin/login_app/locations/add/
Exception Value: FOREIGN KEY constraint failed
解决方案
AFAIK 管理界面还提供了某种历史跟踪(例如,保存对象的时间)。
由于 FK 错误似乎没有从您的代码中弹出(基于跟踪),我相信您需要(重新)运行manage.py migrate
(甚至makemigrations
)来更新您的数据库布局。
推荐阅读
- javascript - 流类型错误:“数字 [1] 与属性 `index` 中的`Number` [2] 不兼容” - 使用 React 上下文
- c# - 当(且仅当)另一个属性为真时,有没有办法告诉 ReSharper 一个属性不为空?
- reactjs - 将状态传递给子组件时未定义状态
- couchdb - 使用 pouchdb 创建新的远程数据库时添加自定义标头
- docker - 如何处理 K8s 中的 STDOUT 日志?
- python - 如何使用 Python 制作具有两个 y 轴(x、y1 和 y2)的散点图
- python - az acr build 找不到 python 包
- javascript - WebRTC - 屏幕录制 | 音频未录制 - 问题
- node.js - 如何解析请求正文?
- apache - 使用 Apache 在 Windows 上通过 CGI 运行 Web 应用程序