加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > Python > 正文

django 1.9:ProgrammingError:关系“users_user”不存在

发布时间:2020-12-16 23:39:25 所属栏目:Python 来源:网络整理
导读:我在迁移时遇到了ProgrammingError,我认为这可能与 django-allauth与自定义用户的使用有关.这就是我的工作 1 /用psql创建一个新的数据库: create database dj_example; 2 / Installed_apps包含django.contrib.sites: DJANGO_APPS = ('django.contrib.auth'
我在迁移时遇到了ProgrammingError,我认为这可能与 django-allauth与自定义用户的使用有关.这就是我的工作

1 /用psql创建一个新的数据库:

create database dj_example;

2 / Installed_apps包含django.contrib.sites:

DJANGO_APPS = (
'django.contrib.auth','django.contrib.contenttypes','django.contrib.sessions','django.contrib.sites','django.contrib.messages','django.contrib.staticfiles','django.contrib.admin',)
THIRD_PARTY_APPS = (
'crispy_forms',# Form layouts
'allauth',# registration
'allauth.account',# registration
#'allauth.socialaccount',# registration
#'allauth.socialaccount.providers.twitter','djcelery',#Celery
)
LOCAL_APPS = (
'tucat.users',# custom users app
}

3 / site_id设置为1

SITE_ID = 1

4 /自定义用户模型过于简单:

# -*- coding: utf-8 -*-
from __future__ import unicode_literals,absolute_import
from django.contrib.auth.models import AbstractUser

class User(AbstractUser):
  def __unicode__(self):
    return self.username

5 / Makemigrations工作正常

# python manage.py makemigrations
Migrations for 'djcelery':
  0028_auto_20160601_1919.py:
  - Alter field status on taskmeta

6 / Migrate返回ProgrammingError:关系“users_user”不存在

# python manage.py migrate
  Operations to perform:
  Apply all migrations: auth,contenttypes,djcelery,account,admin,sessions
  Running migrations:
  Rendering model states... DONE
  Applying account.0001_initial...Traceback (most recent call last):
  File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/backends/utils.py",line 64,in execute
  return self.cursor.execute(sql,params)
psycopg2.ProgrammingError: relation "users_user" does not exist

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "manage.py",line 12,in <module>
  execute_from_command_line(sys.argv)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/core/management/__init__.py",line 353,in execute_from_command_line
  utility.execute()
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/core/management/__init__.py",line 345,in execute
  self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/core/management/base.py",line 348,in run_from_argv
  self.execute(*args,**cmd_options)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/core/management/base.py",line 399,in execute
  output = self.handle(*args,**options)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/core/management/commands/migrate.py",line 200,in handle
  executor.migrate(targets,plan,fake=fake,fake_initial=fake_initial)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/migrations/executor.py",line 92,in migrate
  self._migrate_all_forwards(plan,full_plan,line 121,in _migrate_all_forwards
  state = self.apply_migration(state,migration,line 198,in apply_migration
  state = migration.apply(state,schema_editor)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/backends/base/schema.py",line 90,in __exit__
  self.execute(sql)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/backends/base/schema.py",line 110,in execute
  cursor.execute(sql,params)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/backends/utils.py",line 79,in execute
  return super(CursorDebugWrapper,self).execute(sql,params)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/utils.py",line 95,in __exit__
  six.reraise(dj_exc_type,dj_exc_value,traceback)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/utils/six.py",line 685,in reraise
  raise value.with_traceback(tb)
File "/home/antoinet/.virtualenvs/tucat/lib/python3.4/site-packages/django/db/backends/utils.py",params)
django.db.utils.ProgrammingError: relation "users_user" does not exist

知道如何解决这个问题吗?

解决方法

您的错误是由运行迁移的顺序引起的.由于许多应用依赖于现有的用户模型,因此您必须在其他应用之前为自定义用户应用运行初始迁移.

如果更改现有项目中的默认用户模型,则可能更容易丢弃所有现有迁移(和数据库)并从头开始重建.应用迁移的顺序如下:

>核心django.contrib应用程序.
>您的自定义用户应用.
>其他自定义应用和第三方应用.

您可以使用django-admin showmigrations查看存在和计划的迁移.

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读