在Django ProgrammingError的/profile/edit/1/早期版本中,我使用了sqlite3数据库,但当我更改为postgresql时,它导致了这个问题

2024-06-16 10:32:50 发布

您现在位置:Python中文网/ 问答频道 /正文

enter image description here在/profile/edit/1处出现编程错误/ 关系“auth\u user”不存在 第1行:…用户“.”处于活动状态“,”身份验证用户“,”加入日期“,”来自“身份验证用户…”

内部服务器错误:/profile/edit/1/

Traceback (most recent call last):
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "auth_user" does not exist
LINE 1: ...user"."is_active", "auth_user"."date_joined" FROM "auth_user...
                                                             ^


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

Traceback (most recent call last):
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\core\handlers\exception.py", line 47, in inner
    response = get_response(request)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\contrib\auth\decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\jobapp\permission.py", line 21, in wrap
    return function(request, *args, **kwargs)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\account\views.py", line 208, in employee_edit_profile
    user = get_object_or_404(User, id=id)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\shortcuts.py", line 76, in get_object_or_404
    return queryset.get(*args, **kwargs)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\models\query.py", line 431, in get
    num = len(clone)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\models\query.py", line 262, in __len__
    self._fetch_all()
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\models\query.py", line 1324, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\models\query.py", line 51, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\models\sql\compiler.py", line 1169, in execute_sql
    cursor.execute(sql, params)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 98, in execute
    return super().execute(sql, params)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 66, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\Joych\Downloads\Backup JobB\Job-B\Job-Portal-Django-master\xb\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "auth_user" does not exist
LINE 1: ...user"."is_active", "auth_user"."date_joined" FROM "auth_user...

我不知道为什么我在点击按钮更新信息时会出现这个错误编辑表单打开时工作正常在处理sqlite3数据库时我已经正确地完成了迁移所以当我迁移到postgresql时出现了这个错误应用程序中的其他功能工作正常仅此编辑不工作但我它还说,已经正确地完成了迁移

django.db.utils.ProgrammingError:关系“auth_user”不存在 第1行:…用户“.”处于活动状态“,”身份验证用户“,”加入日期“,”来自“身份验证用户…”


Tags: djangoinpymasterdownloadslinejobusers