We are not able to login to erpnext portal. Kindly assist us. Any help would be of really appreciated. Thanks in advance.
website.js:161 Traceback (most recent call last):
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 58, in application
init_request(request)
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 120, in init_request
frappe.local.http_request = frappe.auth.HTTPRequest()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 51, in __init__
frappe.local.login_manager = LoginManager()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 105, in __init__
if self.login()==False: return
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 131, in login
self.post_login()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 138, in post_login
self.make_session()
File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 182, in make_session
full_name=self.full_name, user_type=self.user_type)
File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 200, in __init__
self.start()
File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 217, in start
"session_expiry": get_expiry_period(self.device),
File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 382, in get_expiry_period
exp_sec = frappe.defaults.get_global_default(key) or default
File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 105, in get_global_default
if not_in_user_permission(key, value):
File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 61, in not_in_user_permission
user_permission = get_user_permissions(user).get(frappe.unscrub(key)) or []
File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 74, in get_user_permissions
return _get_user_permissions(user)
File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/user_permission/user_permission.py", line 70, in get_user_permissions
filters=dict(user=user)):
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1293, in get_all
return get_list(doctype, *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1266, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 94, in execute
result = self.build_and_run()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 122, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 214, in sql
self._cursor.execute(query)
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, "Unknown column 'applicable_for' in 'field list'")