SQLite可以运行，但是PostgreSQL迁移的数据库导致错误

编程入门行业动态更新时间:2024-10-27 19:24:27

本文介绍了SQLite可以运行，但是PostgreSQL迁移的数据库导致错误-Django 3.0的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

情况

我已经用几个应用程序构建了Django 3.0，PostgreSQL 11，macOS项目.
我已基于以下课程，它是 github
比我通过身份验证 acc
所有这些操作均已在 SQLite 数据库中完成
以前，我已经为运行良好的早期应用程序试用了 PostgreSQL 数据库
但是现在当我在settings.py文件中将 SQLite 切换为 PostgreSQL 时，错误，我尝试登录
如果我将settings.py切换回 SQLite ，则一切运行正常(例如:身份验证，使用用户登录，用户自己在网站上进行操作设置)
我使用decorators.py来保持登录用户的访问登录和注册页面，并且当我切换到postgresql时会出错.我在这里仅使用错误消息包含的 HttpResponse

I have built Django 3.0, PostgreSQL 11, macOS project with a couple of applications.
I have created the accounts app based on following course and it's github
Than I have created an application fro authentication acc
All this has been done in an SQLite database
Previously I have tried out a PostgreSQL database for the early application that was working fine
but now when I switch of in the settings.py file the SQLite to PostgreSQL I get an error i I try to log in
If I switch back the settings.py to SQLite everything works perfectly (ex.: authentication, logging in with user, user doing things on the website with it's own settings)
I use decorators.py to keep logged in users visiting the login and signup pages and that gives error when I switch to postgresql. I only use here HttpResponse that the error message contains

decorators.py

from django.http import HttpResponse from django.shortcuts import redirect def unauthenticated_user(view_func): def wrapper_func(request, *args, **kwargs): if request.user.is_authenticated: return redirect('home') else: return view_func(request, *args, **kwargs) return wrapper_func def allowed_users(allowed_roles=[]): def decorator(view_func): def wrapper_func(request, *args, **kwargs): group = None if request.user.groups.exists(): group = request.user.groups.all()[0].name if group in allowed_roles: return view_func(request, *args, **kwargs) else: return HttpResponse('Authorized') return wrapper_func return decorator

错误

如果我在settings.py使用 PostgreSQL 时登录.如果我注销，一切都会恢复正常.如果我使用SQL lite，则可以登录，并且一切运行正常

If I log in while settings.py uses PostgreSQL. If I log out everything works out fine again. If I use SQL lite I can log in and everything works perfectly

ValueError at / The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead. Request Method: GET Request URL: localhost... Django Version: 3.0 Exception Type: ValueError Exception Value: The view accounts.decorators.wrapper_function didn't return an HttpResponse object. It returned None instead. Exception Location: /Users/.../python3.7/site-packages/django/core/handlers/base.py in _get_response, line 126 Python Executable: /Users/.../bin/python3 Python Version: 3.7.3 ..... Request information USER MYUSERNAME GET No GET data POST No POST data FILES No FILES data COOKIES ... ...

试图解决

我遵循的指南创建了在迁移后同样完成的用户组postgreSQL数据库，但在注释部分我仍然收到与USER1相同的错误.

这是视频底部的推荐
"USER1我找到了，我忘记了更改用户的组！
-> USER2转到管理面板，然后在您的用户部分中将客户添加到所选的组部分中."
我确实做到了这一点，但没有奏效，唯一的区别是，我使用了迁移的postgresql，并且他们使用了原始的SQLight，如果我使用的话，那么整个事情对我也适用，但是我想做到这一点使用PostgreSQL.
The guide that I follow created user groups that I have done as well in my migrated postgreSQL database, but I have still received the same error as USER1 in the comment section.
- This was the recommendation in the bottom section of the video
- "USER1 i find it, i forgot to change the user's group!
- --> USER2 go to admin panel and in you user section add customer in the chosen group section".
- I have done exactly that and it did not worked the only difference is that I have used a migrated postgresql and they used the original SQLight that if I use than the whole thing works for me as well, but I want to make it work with PostgreSQL.
- 我还创建了课程负责人这样的AWS RDS postgreSQL数据库，将其迁移并连接到服务器和设置中，但仍然遇到相同的错误.
- 我也查看了用户组权限，并且源代码SQLight数据库没有与我的postgresql一样在管理"选项卡中给出的权限
- 创建了一个全新的Django 3项目，全新的虚拟环境0，我仅从上一个项目中复制了所有内容作为文本，从以前的数据库中迁移了所有内容，我得到了相同的错误