首页 文章

Django - 没有这样的表:main.auth_user__old

提问于
浏览
1

我正在关注官方Django文档中的first app tutorial,并在尝试保存通过管理页面进行的一些更改时遇到此错误 . 我做了一些研究,但我能找到的可能的解决方案,比如迁移数据库,根本行不通 . 如果您想查看我的代码的某些特定部分,请告诉我 .

以下是错误:

/ admin / polls / question / 1 /更改/没有这样的表的操作错误:main.auth_user__old请求方法:POST请求URL:http://127.0.0.1:8000 / admin / polls / items / / change / Django版本:2.1.4异常类型:OperationalError异常值:没有这样的表:main.auth_user__old异常位置:/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/ base.py in execute,第296行Python可执行文件:/ Users / gfioravante / Projects / test_app / ta_env / bin / python3 Python版本:3.7.1 Python路径:['/ Users / gfioravante / Projects / test_app / test_app','/ usr / local / Cellar / python / 3.7.1 / Frameworks / Python.framework / Versions / 3.7 / lib / python37.zip','/ usr / local / Cellar / python / 3.7.1 / Frame / Python.framework / Version /3.7/lib/python3.7','/ usr / local / Cellar / python / 3.7.1 / Frame /Python.framework / Version /3.7 / lib / python3.7 / lib-dadload','/ Users / gfioravante /Projects/test_app/ta_env/lib/python3.7/site-packages']服务器时间:2018年12月5日星期三16:45:00 0000

和追溯:

环境:请求方法:POST请求URL:http://127.0.0.1:8000 / admin / polls /question / 1 / change / Django版本:2.1.4 Python版本:3.7.1已安装的应用程序:['polls.apps .PollsConfig','django.contrib.admin','django.contrib.auth','django.contrib.contenttypes','django.contrib.sessions','django.contrib.messages','django.contrib.staticfiles ']已安装的中间件:['django.middleware.security.SecurityMiddleware','django.contrib.sessions.middleware.SessionMiddleware','django.middleware.common.CommonMiddleware','django.middleware.csrf.CsrfViewMiddleware','django .contrib.auth.middleware.AuthenticationMiddleware','django.contrib.messages.middleware.MessageMiddleware','django.middleware.clickjacking.XFrameOptionsMiddleware'] Traceback:File“/ Users / gfioravante / Projects / test_app / ta_env / lib / python3 _7 / site-packages / django / db / backends / utils.py“在_execute 85中 . 返回self.cursor.execute(sql,params)文件”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7 /站点包s / django / db / backends / sqlite3 / base.py“在执行296.返回Database.Cursor.execute(self,query,params)上面的异常(没有这样的表:main.auth_user__old)是以下的直接原因异常:内部34中的文件“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/exception.py”.response = get_response(request)File“/ Users / gfioravante / Projects / test_app / ta_env / lib / python3.7 / site-packages / django / core / handlers / base.py“in _get_response 126. response = self.process_exception_by_middleware(e,request)File”/ Users / gfioravante / Projects _test_response 124中的/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/base.py“ . response = wrapped_callback(request,* callback_args,** callback_kwargs)File”/ Users / gfioravante / Projects包装器604中的/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py“返回self.admin_site.admin_view(查看)(* args,** kwargs)文件”/ Users / gfioravante /项目/ test_app / ta_env / lib中/wthon3.7/site-packages/django/utils/decorators.py“在_wrapped_view 142. response = view_func(request,* args,** kwargs)File”/ Users / gfioravante / Projects / test_app / ta_env / lib / python3 .7 / site-packages / django / views / decorators / cache.py“in _wrapped_view_func 44. response = view_func(request,* args,** kwargs)File”/ Users / gfioravante / Projects / test_app / ta_env / lib / python3内部223中的.7 / site-packages / django / contrib / admin / sites.py“返回视图(请求,* args,** kwargs)文件”/ Users / gfioravante / Projects / test_app / ta_env / lib / python3 . 7 / site-packages / django / contrib / admin / options.py“在change_view 1640中 . 返回self.changeform_view(request,object_id,form_url,extra_context)文件”/ Users / gfioravante / Projects / test_app / ta_env / lib / python3 . 7 / site-packages / django / utils / decorators.py“在_wrapper 45中 . 返回bound_method(* args,** kwargs)文件”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages /django/utils/decorators.py“in _wrapped_view 142. response = view_func(request,* args,** k wargs)在changeform_view 1525中输入文件“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py” . return self._changeform_view(request,object_id,form_url, extra_context)_changeform_view 1571中的文件“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py”.self.log_change(request,new_object,change_message)File log_change 826中的“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py”.change_message = message,Filelog_action 35中的“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/models.py”35. change_message = change_message,File“/ Users / gfioravante / Projects / test_app在manager_method 82中的/ta_env/lib/python3.7/site-packages/django/db/models/manager.py“ . 返回getattr(self.get_queryset(),name)(* args,** kwargs)文件”/ Users创建413. obj.save(force_insert = True,using = self.db)文件中的/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/query.py“文件”/用户/ gfioravante / Projects / test_app / ta_env / lib / python3.7 / site-packages / django / db / models / base.py“在save 718中.force_update = force_update,update_fields = update_fields)文件”/ Users / gfioravante / Projects save_base 748中的/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py“ . 更新= self._save_table(raw,cls,force_insert,force_update,using,update_fields)文件”/用户/ gfioravante / Projects / test_app / ta_env / lib / python3.7 / site-packages / django / db / models / base.py“in _save_表831. result = self._do_insert(cls._base_manager,using,fields,update_pk,raw)File“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/ base.py“in _do_insert 869. using = using,raw = raw)文件”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/manager.py“in manager_method 82. return getattr(self.get_queryset(),name)(* args,** kwargs)File“/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models /query.py“在_insert 1136中 . 返回query.get_compiler(using = using).execute_sql(return_id)File”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/ models / sql / compiler.py“in execute_sql 1289. cursor.execute(sql,params)File”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils .py“in execute 100. return super() . execute(sql,params)file”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages执行68中的/django/db/backends/utils.py“ . 返回self._execute_with_wrappers(sql,params,many = False,executor = self._execute)文件”/ Users / gfioravante / Projects / test_app / ta_env / lib / python3 .7 / site-packages / django / db / backends / utils.py“在_execute_with_wrappers中77. return executor(sql,params,many,context)File”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7 _site-packages/django/db/backends/utils.py“在_execute 85中 . 返回self.cursor.execute(sql,params)文件”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site退出89中的-packages / django / db / utils.py“ . 从exc_value文件中提取dj_exc_value.with_traceback(traceback)”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db /backends/utils.py“在_execute 85中 . 返回self.cursor.execute(sql,params)文件”/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends /sqlite3/base.py“在执行296.中返回Database.Cursor.execute(self,query,params)Exception Ty pe:/ error / polls / question / 1 / change / Exception值的OperationalError:没有这样的表:main.auth_user__old

2 回答

  • 0

    打开=> /YourAppFolder/migrations/ 你会看到像' 0001_initial.py '这样的迁移文件删除所有这些文件 . 并运行以下命令1- python manage.py makemigrations 2- python manage.py migrate 希望,它必须唯一你的问题:)

  • 1

    我自己也遇到过这个问题,它看起来与https://code.djangoproject.com/ticket/29182有关 . 目前,您可以将您的sqlite版本降级到2.6之前的版本(例如2.5.1)

相关问题