Django - 没有这样的表:main.auth_user__old [英] Django - No such table: main.auth_user__old
问题描述
我正在关注官方 Django 文档中的第一个应用教程，并且尝试保存通过管理页面所做的一些更改时出现此错误.我对其进行了一些研究，但我能够找到的可能解决方案(例如迁移数据库)根本行不通.如果您想查看我代码的某些特定部分，请告诉我.
I was following the first app tutorial from the official Django docs and got this error when trying to save some changes made through the admin page. I did some research on it, but the possible solutions I was able to find, such as migrating the db, simply won't work. Just let me know if you want to see some specific part of my code.
以下是错误:
OperationalError at/admin/polls/question/1/change/没有这样的表:main.auth_user__old 请求方式:POST 请求网址:http://127.0.0.1:8000/admin/polls/question/1/change/ Django版本:2.1.4 异常类型:OperationalError 异常值:无这样的表: main.auth_user__old 异常位置:/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py在执行中，第 296 行 Python可执行文件:/Users/gfiorvante/Projects/test_app/ta_env/bin/python3Python 版本:3.7.1 Python 路径:
['/Users/gfiorvante/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/Frameworks/Python.framework/Versions/3.7/lib/python3.7','/usr/local/Cellar/python/3.7.1/Frameworks/Python.framework/Versions/3.7/lib/python3.7/lib-dynload','/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages']服务器时间:2018 年 12 月 5 日星期三 16:45:00 +0000
OperationalError at /admin/polls/question/1/change/ no such table: main.auth_user__old Request Method: POST Request URL: http://127.0.0.1:8000/admin/polls/question/1/change/ Django Version: 2.1.4 Exception Type: OperationalError Exception Value: no such table: main.auth_user__old Exception Location: /Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 296 Python Executable: /Users/gfioravante/Projects/test_app/ta_env/bin/python3 Python Version: 3.7.1 Python Path:
['/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/Frameworks/Python.framework/Versions/3.7/lib/python3.7', '/usr/local/Cellar/python/3.7.1/Frameworks/Python.framework/Versions/3.7/lib/python3.7/lib-dynload', '/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages'] Server time: Wed, 5 Dec 2018 16:45:00 +0000
和回溯:
环境:
请求方法:POST 请求 URL:http://127.0.0.1:8000/admin/polls/question/1/改变/
Request Method: POST Request 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']
Django Version: 2.1.4 Python Version: 3.7.1 Installed Applications: ['polls.apps.PollsConfig', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles'] Installed Middleware: ['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']
追溯:
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py"在 _execute85. 返回 self.cursor.execute(sql, params)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute 85. return self.cursor.execute(sql, params)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py"在执行296. 返回 Database.Cursor.execute(self, query, params)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute 296. return Database.Cursor.execute(self, query, params)
上述异常(没有这样的表:main.auth_user__old)是以下异常的直接原因:
The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/exception.py"在内部34. response = get_response(request)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner 34. response = get_response(request)
文件/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/base.py"在 _get_response 中126. response = self.process_exception_by_middleware(e, 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)
文件/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/base.py"在 _get_response 中124. 响应=wrapped_callback(request, *callback_args, **callback_kwargs)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py"在包装中604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py" in wrapper 604. return self.admin_site.admin_view(view)(*args, **kwargs)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.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/utils/decorators.py" in _wrapped_view 142. response = view_func(request, *args, **kwargs)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/views/decorators/cache.py"在 _wrapped_view_func 中44. 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)
文件内部的/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/sites.py"223.返回视图(请求，*args，**kwargs)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/sites.py" in inner 223. return view(request, *args, **kwargs)
文件/Users/gfiorvante/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)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py" in change_view 1640. return self.changeform_view(request, object_id, form_url, extra_context)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/utils/decorators.py"在_wrapper45. 返回 bound_method(*args, **kwargs)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/utils/decorators.py" in _wrapper 45. return bound_method(*args, **kwargs)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.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/utils/decorators.py" in _wrapped_view 142. response = view_func(request, *args, **kwargs)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py"在 changeform_view 中1525. 返回 self._changeform_view(request, object_id, form_url, extra_context)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py" in changeform_view 1525. return self._changeform_view(request, object_id, form_url, extra_context)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py"在_changeform_view中1571. self.log_change(request, new_object, change_message)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py" in _changeform_view 1571. self.log_change(request, new_object, change_message)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py"在 log_change 中826.change_message=message,
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py" in log_change 826. change_message=message,
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/models.py"在 log_action 中35.change_message=change_message,
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/models.py" in log_action 35. change_message=change_message,
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/manager.py"在 manager_method82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/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)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/query.py"在创造413.obj.save(force_insert=True, using=self.db)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/query.py" in create 413. obj.save(force_insert=True, using=self.db)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py"在保存718.force_update=force_update,update_fields=update_fields)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py" in save 718. force_update=force_update, update_fields=update_fields)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py"在 save_base748.updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py" in save_base 748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py"在_save_table中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 _save_table 831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py"在 _do_insert 中869.using=using, raw=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/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/manager.py"在 manager_method82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/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)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/query.py"在_插入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/query.py" in _insert 1136. return query.get_compiler(using=using).execute_sql(return_id)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/sql/compiler.py"在执行_sql1289. cursor.execute(sql, params)
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)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py"在执行100. 返回 super().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)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py"在执行68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
文件/Users/gfiorvante/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" in _execute_with_wrappers 77. return executor(sql, params, many, context)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py"在 _execute85. 返回 self.cursor.execute(sql, params)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute 85. return self.cursor.execute(sql, params)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/utils.py"在出口89. 从 exc_value 提高 dj_exc_value.with_traceback(traceback)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/utils.py" in exit 89. raise dj_exc_value.with_traceback(traceback) from exc_value
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py"在 _execute85. 返回 self.cursor.execute(sql, params)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute 85. return self.cursor.execute(sql, params)
文件/Users/gfiorvante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py"在执行296. 返回 Database.Cursor.execute(self, query, params)
File "/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute 296. return Database.Cursor.execute(self, query, params)
异常类型:OperationalError at/admin/polls/question/1/change/异常值:没有这样的表:main.auth_user__old
Exception Type: OperationalError at /admin/polls/question/1/change/ Exception Value: no such table: main.auth_user__old
推荐答案
我自己刚遇到这个，它看起来与 https://code.djangoproject.com/ticket/29182.目前，您可以将您的 sqlite 版本降级到 2.6 之前的版本(例如 2.5.1)
I just came across this myself, it looks to be related to https://code.djangoproject.com/ticket/29182. For now, you can just downgrade your version of sqlite to a version prior to 2.6 (e.g. 2.5.1)
这篇关于Django - 没有这样的表:main.auth_user__old的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
