python - Django Migrating DB django.db.utils.ProgrammingError: 关系“django_site”不存在
问题描述
为 Django 进行站点升级,现在当我尝试将其推送到服务器时python manage.py makemigrations
出现此错误
(kpsga) sammy@kpsga:~/webapps/kpsga$ python manage.py makemigrations
Traceback (most recent call last):
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "django_site" does not exist
LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si...
^
The above exception was the direct cause of the following exception:
...
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/home/sammy/webapps/kpsga/kpsga/urls.py", line 27, in <module>
path('blog', include('blog.urls')),
...
File "/home/sammy/webapps/kpsga/blog/urls.py", line 2, in <module>
from blog.views import LatestBlogEntries, blog_archive, blog_entry_by_id, blog_entry
File "/home/sammy/webapps/kpsga/blog/views.py", line 10, in <module>
class LatestBlogEntries(Feed):
File "/home/sammy/webapps/kpsga/blog/views.py", line 11, in LatestBlogEntries
current_site = Site.objects.get_current()
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/contrib/sites/models.py", line 58, in get_current
return self._get_site_by_id(site_id)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/contrib/sites/models.py", line 30, in _get_site_by_id
site = self.get(pk=site_id)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/query.py", line 425, in get
num = len(clone)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/query.py", line 269, in __len__
self._fetch_all()
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/sammy/webapps/envs/kpsga/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "django_site" does not exist
LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si...
虽然我已将这些添加到设置文件中
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
#additional django
'django.contrib.sites',
]
SITE_ID = 1
最新课程
class LatestBlogEntries(Feed):
current_site = Site.objects.get_current()
title = current_site.name + " - Latest News"
link = "/news/"
description = "Latest news and updates from " + current_site.domain
def items(self):
return BlogEntry.objects.all()[:10]
def item_title(self, item):
return item.title
def item_description(self, item):
return item.description
解决方案
你不应该Site.objects.get_current()
在LatestBlogEntries
课堂上打电话。它需要数据库查找,这会relation does not exist
在您尚未运行初始迁移时导致错误。
您可以使用title
和的方法description
。这样,在Site.objects.get_current()
访问提要时运行,而不是在 Django 启动时运行。
class LatestBlogEntries(Feed):
def title(self, obj):
current_site = Site.objects.get_current()
return current_site.name + " - Latest News"
link = "/news/"
def description(self, obj):
current_site = Site.objects.get_current()
return "Latest news and updates from " + current_site.domain
def items(self):
return BlogEntry.objects.all()[:10]
def item_title(self, item):
return item.title
def item_description(self, item):
return item.description
推荐阅读
- octopus-deploy - 变量名中的通配符
- javascript - 在将它们保存到数据库之前检查重复项
- javascript - 为什么 PrismJs 没有突出显示我的 React 代码编辑器组件?
- django - 如何使用外键模型之间的相关名称呈现反向字段
- deep-learning - WGAN 和 WGAN-GP 的区别(梯度惩罚)
- javascript - 如何在javascript中通过网络调用可靠地更新数据列表?
- javascript - 如何使用 JavaScript 将逗号添加到来自 API 的数千个数字
- c# - 如何以最佳性能明智地将右表中的列加入左列表
- aws-lambda - AWS Statemachine 无法将输入 json 数据传递给第一个 Lambda
- javascript - 使用页面语言(WordPress)动态更新按钮href