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在/ admin / polls / question / 1 / change /上没有这样的表：
main.auth_user__old请求方法：POST请求
URL： http://127.0.0.1:8000/admin/polls/question/1/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
，第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/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']
服务器时间：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

和回溯：

环境：

Environment:

请求方法：POST请求URL：
http://127.0.0.1:8000/admin/polls/question/1/change/

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.middlewa re.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 / 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）

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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py
执行
296. return 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）是
直接原因o f以下异常：

The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:

文件
/Users/gfioravante/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)

File
/ 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中的
。response = wrapd_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)

File
/ Users / gfioravante / 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/gfioravante/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 / 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.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func 44. response = view_func(request, *args, **kwargs)

文件
/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin /sites.py在内部
223中。return view（request，* 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 / 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）

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 / gfioravan te / Projects / test_app / ta_env / lib / python3.7 / site-packages / django / utils / decorators.py _wrapper
中的
45。return 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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/utils/decorators.py $ b _wrapped_view
142中的$ b。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 / gfioravante / Projects /test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options.py changeform_view
中的
1525。return 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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/contrib/admin/options。 py
in _changeform_view
1571。self.log_change（请求，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 / gfioravante /项目/ test_app / ta_en v / 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/gfioravante/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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/ db / models / manager.py
在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/manager.py" in manager_method 82. return getattr(self.get_queryset(), name)(*args, **kwargs)

文件
/Users/gfioravante/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 / gfioravante / 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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/ django / db / models / base.py save_base
748中的
。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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/base.py
在_save_table $ b中$ b831。结果= self._do_insert（cls._base_manager，使用，字段，update_pk，原始）

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 / gfioravante / 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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/manager.py
在manager_method
82中。return geta ttr（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)

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/query.py" in _insert 1136. return query.get_compiler(using=using).execute_sql(return_id)

文件
/Users/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/models/sql/compiler.py
在execute_sql
1289中。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 / gfioravante / Projects / test_app / ta_env / lib / python3.7 / site-packages / django / db / backends / utils.py
在执行
100中。return 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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py
in execute
68。返回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/gfioravante/Projects/test_app/ta_env/lib/python3.7/site-packages/django/db/backends/utils.py
在_execute_with_wrappers
中77.返回执行程序（sql，params，许多，上下文）

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)

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）

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/gfioravante/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 / 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）

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 / gfioravante / Projects / test_app / ta_env / lib / pytho n3.7 / site-packages / django / db / backends / sqlite3 / base.py
in execute
296。return 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)

异常类型：/ admin / polls / question / 1 / change /
的OperationalError异常值：无此类表：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屋！