【已解答】linux面板 Nginx+uwsgi+django死活连不上mysql数据库

linux面板 Nginx+uwsgi+django死活连不上mysql数据库,在phpmyadmin同样的设置参数是可以访问数据库的

1. 2022-11-07 12:13:35 base.py [line:1023] DEBUG: Next wakeup is due at 2022-11-07 15:48:30+08:00 (in 12894.489283 seconds)
   
2. 2022-11-07 12:13:36 log.py [line:224] ERROR: Internal Server Error: /
   
3. Traceback (most recent call last):
   
4.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
   
5.     return self.cursor.execute(sql, params)
   
6.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
   
7.     return self.cursor.execute(query, args)
   
8.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
   
9.     res = self._query(query)
   
10.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    
11.     db.query(q)
    
12.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
    
13.     _mysql.connection.query(self, query)
    
14. MySQLdb._exceptions.ProgrammingError: (1146, "Table 'mywebdata.information_article_Tags' doesn't exist")
    
15. 
    
16. The above exception was the direct cause of the following exception:
    
17. 
    
18. Traceback (most recent call last):
    
19.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
    
20.     response = get_response(request)
    
21.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
    
22.     response = wrapped_callback(request, *callback_args, **callback_kwargs)
    
23.   File "/www/wwwroot/LMathsWeb/./sitesubject/views.py", line 166, in index
    
24.     b = Article.objects.filter(id__exact=A.title).prefetch_related('Tags').only('ContentTitle', 'Author',
    
25.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 317, in __getitem__
    
26.     qs._fetch_all()
    
27.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1326, in _fetch_all
    
28.     self._prefetch_related_objects()
    
29.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 813, in _prefetch_related_objects
    
30.     prefetch_related_objects(self._result_cache, *self._prefetch_related_lookups)
    
31.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1730, in prefetch_related_objects
    
32.     obj_list, additional_lookups = prefetch_one_level(
    
33.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1872, in prefetch_one_level
    
34.     all_related_objects = list(rel_qs)
    
35.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
    
36.     self._fetch_all()
    
37.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
    
38.     self._result_cache = list(self._iterable_class(self))
    
39.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
    
40.     results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
    
41.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
    
42.     cursor.execute(sql, params)
    
43.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
    
44.     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
    
45.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
    
46.     return executor(sql, params, many, context)
    
47.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
    
48.     return self.cursor.execute(sql, params)
    
49.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
    
50.     raise dj_exc_value.with_traceback(traceback) from exc_value
    
51.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
    
52.     return self.cursor.execute(sql, params)
    
53.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
    
54.     return self.cursor.execute(query, args)
    
55.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
    
56.     res = self._query(query)
    
57.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    
58.     db.query(q)
    
59.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
    
60.     _mysql.connection.query(self, query)
    
61. django.db.utils.ProgrammingError: (1146, "Table 'mywebdata.information_article_Tags' doesn't exist")
    
62. 2022-11-07 12:13:36 log.py [line:224] ERROR: Internal Server Error: /
    
63. Traceback (most recent call last):
    
64.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
    
65.     return self.cursor.execute(sql, params)
    
66.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
    
67.     return self.cursor.execute(query, args)
    
68.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
    
69.     res = self._query(query)
    
70.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    
71.     db.query(q)
    
72.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
    
73.     _mysql.connection.query(self, query)
    
74. MySQLdb._exceptions.ProgrammingError: (1146, "Table 'mywebdata.information_article_Tags' doesn't exist")
    
75. 
    
76. The above exception was the direct cause of the following exception:
    
77. 
    
78. Traceback (most recent call last):
    
79.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
    
80.     response = get_response(request)
    
81.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
    
82.     response = wrapped_callback(request, *callback_args, **callback_kwargs)
    
83.   File "/www/wwwroot/LMathsWeb/./sitesubject/views.py", line 166, in index
    
84.     b = Article.objects.filter(id__exact=A.title).prefetch_related('Tags').only('ContentTitle', 'Author',
    
85.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 317, in __getitem__
    
86.     qs._fetch_all()
    
87.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1326, in _fetch_all
    
88.     self._prefetch_related_objects()
    
89.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 813, in _prefetch_related_objects
    
90.     prefetch_related_objects(self._result_cache, *self._prefetch_related_lookups)
    
91.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1730, in prefetch_related_objects
    
92.     obj_list, additional_lookups = prefetch_one_level(
    
93.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1872, in prefetch_one_level
    
94.     all_related_objects = list(rel_qs)
    
95.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
    
96.     self._fetch_all()
    
97.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
    
98.     self._result_cache = list(self._iterable_class(self))
    
99.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
    
100.     results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
     
101.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
     
102.     cursor.execute(sql, params)
     
103.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
     
104.     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
     
105.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
     
106.     return executor(sql, params, many, context)
     
107.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
     
108.     return self.cursor.execute(sql, params)
     
109.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
     
110.     raise dj_exc_value.with_traceback(traceback) from exc_value
     
111.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
     
112.     return self.cursor.execute(sql, params)
     
113.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute
     
114.     return self.cursor.execute(query, args)
     
115.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
     
116.     res = self._query(query)
     
117.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
     
118.     db.query(q)
     
119.   File "/www/wwwroot/LMathsWeb/d651643ec7c17a40c4e7c03b0f692b99_venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
     
120.     _mysql.connection.query(self, query)
     
121. django.db.utils.ProgrammingError: (1146, "Table 'mywebdata.information_article_Tags' doesn't exist")
     
122. [pid: 5952|app: 0|req: 1/1] 127.0.0.1 () {46 vars in 1066 bytes} [Mon Nov  7 12:13:34 2022] GET / => generated 1714 bytes in 2906 msecs (HTTP/1.0 500) 7 headers in 244 bytes (1 switches on core 0)
     
123. 2022-11-07 12:13:37 log.py [line:224] ERROR: Internal Server Error: /favicon.ico
     
124. 2022-11-07 12:13:37 log.py [line:224] ERROR: Internal Server Error: /favicon.ico
     
125. [pid: 5952|app: 0|req: 2/2] 127.0.0.1 () {44 vars in 986 bytes} [Mon Nov  7 12:13:37 2022] GET /favicon.ico => generated 1714 bytes in 1125 msecs (HTTP/1.0 500) 7 headers in 244 bytes (1 switches on core 1)
     

复制代码

您好，提示表不存在了，您检查一下

堡塔运维向樛木 发表于 2022-11-7 14:08
您好，提示表不存在了，您检查一下

其实是存在的,就是访问不了

表示存在的

宝塔用户_qrmmjq 发表于 2022-11-7 14:24
表示存在的

不好意思是这边没有详细说明，不存在和表损坏都是提示的1146