Python Flask：如何解决"应用程序中的错误：异常/[GET]"？

Question

我一直在开发一个带有基本登录系统的小论坛网站。我的Flask应用程序在登录时正常工作，但每当我使用"return redirect(url_fo("index"(("时，我的Fla斯克中似乎会出现异常问题，导致应用程序停止。它产生的错误是：

ERROR in app: Exception on / [GET]
Traceback (most recent call last):
File "MY DIRECTORYapp.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "MY DIRECTORYapp.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "MY DIRECTORYapp.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "MY DIRECTORY_compat.py", line 39, in reraise
raise value
File "MY DIRECTORYapp.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "MY DIRECTORYapp.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "MY FLASK APP FILEapp.py", line 16, in index
cursor = mydb.cursor()
File "MY FLASK APP FILElibsite-packagesmysqlconnectorconnection.py", line 1022, in cursor
self.handle_unread_result()
File "MY FLASK APP FILElibsite-packagesmysqlconnectorconnection.py", line 1286, in handle_unread_result
raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

我该如何防止这种情况发生，我想我需要用GET做点什么，但我不确定。

Answer 1

您似乎在使用mysql连接器。若要解决此问题，请更改光标对象的属性。

cursor = <connection-name>.cursor(buffered=True)

这一定能解决你的问题。