Since yesterday, my testing server facing this error:
Traceback (most recent call last):
File “apps/frappe/frappe/app.py”, line 55, in application
init_request(request)
File “apps/frappe/frappe/app.py”, line 129, in init_request
frappe.local.http_request = frappe.auth.HTTPRequest()
File “apps/frappe/frappe/auth.py”, line 34, in init
self.set_session()
File “apps/frappe/frappe/auth.py”, line 70, in set_session
frappe.local.login_manager = LoginManager()
File “apps/frappe/frappe/auth.py”, line 110, in init
if self.login() is False:
File “apps/frappe/frappe/auth.py”, line 135, in login
self.authenticate(user=user, pwd=pwd)
File “apps/frappe/frappe/auth.py”, line 238, in authenticate
user = User.find_by_credentials(user, pwd)
File “apps/frappe/frappe/core/doctype/user/user.py”, line 643, in find_by_credentials
check_password(user[“name”], password, delete_tracker_cache=False)
File “apps/frappe/frappe/utils/password.py”, line 101, in check_password
frappe.qb.from_(Auth)
File “apps/frappe/frappe/query_builder/utils.py”, line 76, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “apps/frappe/frappe/database/database.py”, line 219, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 158, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 325, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 779, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1157, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 729, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, “Table ‘_3be215ac3b13152e.__Auth’ doesn’t exist”)
This happen when I click “Login” on my webpage then it stuck showing “Verifying” and go no where.
I check on my database, no table named “_Auth” but in my other ERPNext instance, where the login works, also no “_auth” table. so why my testing server facing this error?