OperationalError at /onetoone和no such table: auth_use错误处理

发表于 2019-01-02 更新于 2024-09-20 分类于技术文章

CommandError: Can’t find xgettext. Make sure you have GNU gettext tools 0.15 or newer installed.

下载： http://gnuwin32.sourceforge.net/packages/gettext.htm

配置环境变量

C:\Program Files (x86)\GnuWin32\bin

输出以下结果，就ok了，记得重启命令行

C:\Users\admin>xgettext xgettext: no input file given Try `(null) –help’ for more information.

django会爆出这样的错误，我检查了代码并没有发现什么问题，最后发现是因为没有进行数据库映射导致的，makemigrations和migrate操作一下

Not Found: / [02/Jan/2019 11:35:42] “GET / HTTP/1.1” 404 2032 Internal Server Error: /onetoone Traceback (most recent call last):

sqlite3.OperationalError: no such table: auth_user

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

django.db.utils.OperationalError: no such table: auth_user

Request Method:

GET

Request URL:

http://127.0.0.1:8000/onetoone

Django Version:

2.1.4

Exception Type:

OperationalError

Exception Value:

no such table: auth_user

Exception Location:

C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\sqlite3\base.py in execute, line 296

Python Executable:

C:\Users\Administrator\PycharmProjects\untitled\venv\Scripts\python.exe

Python Version:

3.7.1

Python Path:

[‘C:\\Users\\Administrator\\PycharmProjects\\untitled1’,
‘C:\\Users\\Administrator\\PycharmProjects\\untitled1’,
‘C:\\Users\\Administrator\\PycharmProjects\\untitled\\venv\\Scripts\\python37.zip’,
‘C:\\Users\\Administrator\\AppData\\Local\\Programs\\Python\\Python37\\DLLs’,
‘C:\\Users\\Administrator\\AppData\\Local\\Programs\\Python\\Python37\\lib’,
‘C:\\Users\\Administrator\\AppData\\Local\\Programs\\Python\\Python37’,
‘C:\\Users\\Administrator\\PycharmProjects\\untitled\\venv’,
‘C:\\Users\\Administrator\\PycharmProjects\\untitled\\venv\\lib\\site-packages’,
‘C:\\Users\\Administrator\\PycharmProjects\\untitled\\venv\\lib\\site-packages\\setuptools-39.1.0-py3.7.egg’,
‘C:\\Program Files\\JetBrains\\PyCharm ‘
‘2018.1.4\\helpers\\pycharm_matplotlib_backend’]

Server time:

Wed, 2 Jan 2019 03:35:56 +0000

Traceback Switch to copy-and-paste view

C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in _execute
1. ```
             return self.cursor.execute(sql, params)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\sqlite3\base.py in execute
1. ```
     return Database.Cursor.execute(self, query, params)
```
```
...
```
▶ Local vars
The above exception (no such table: auth_user) was the direct cause of the following exception:
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\core\handlers\exception.py in inner
1. ```
         response = get\_response(request)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\core\handlers\base.py in _get_response
1. ```
             response = self.process\_exception\_by\_middleware(e, request)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\core\handlers\base.py in _get_response
1. ```
             response = wrapped\_callback(request, \*callback\_args, \*\*callback\_kwargs)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled1\front\views.py in one_view
1. ```
 user = User.objects.create(username='zhiliao1',email='2115445@qq.com')
```
  …
▼ Local vars

Variable

Value

request

<WSGIRequest: GET ‘/onetoone’>
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\manager.py in manager_method
1. ```
             return getattr(self.get\_queryset(), name)(\*args, \*\*kwargs)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\query.py in create
1. ```
     obj.save(force\_insert=True, using=self.db)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\contrib\auth\base_user.py in save
1. ```
     super().save(\*args, \*\*kwargs)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\base.py in save
1. ```
                    force\_update=force\_update, update\_fields=update\_fields)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\base.py in save_base
1. ```
         updated = self.\_save\_table(raw, cls, force\_insert, force\_update, using, update\_fields)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\base.py in _save_table
1. ```
         result = self.\_do\_insert(cls.\_base\_manager, using, fields, update\_pk, raw)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\base.py in _do_insert
1. ```
                            using=using, raw=raw)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\manager.py in manager_method
1. ```
             return getattr(self.get\_queryset(), name)(\*args, \*\*kwargs)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\query.py in _insert
1. ```
     return query.get\_compiler(using=using).execute\_sql(return\_id)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\models\sql\compiler.py in execute_sql
1. ```
             cursor.execute(sql, params)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in execute
1. ```
         return super().execute(sql, params)
```
```
...
```
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in execute
1. ```
     return self.\_execute\_with\_wrappers(sql, params, many=False, executor=self.\_execute)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in _execute_with_wrappers
1. ```
     return executor(sql, params, many, context)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in _execute
1. ```
             return self.cursor.execute(sql, params)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\utils.py in __exit__
1. ```
             raise dj\_exc\_value.with\_traceback(traceback) from exc\_value
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\utils.py in _execute
1. ```
             return self.cursor.execute(sql, params)
```
  …
▶ Local vars
C:\Users\Administrator\PycharmProjects\untitled\venv\lib\site-packages\django\db\backends\sqlite3\base.py in execute
1. ```
     return Database.Cursor.execute(self, query, params)
```
```
...
```
▶ Local vars

Traceback Switch to copy-and-paste view

The above exception (no such table: auth_user) was the direct cause of the following exception: