Hi all,
On ERPNext: v12.10.1 (version-12) and Frappe Framework: v12.8.3 (version-12)
Those are the errors related to process_all
{‘e’: InternalError(1054, “Unknown column ‘status’ in ‘where clause’”), ‘method_name’: ‘erpnext.accounts.doctype.subscription.subscription.process_all’, ‘log’: <function log at 0x7f40ccdb8598>, ‘retry’: 0, ‘is_async’: True, ‘user’: ‘Administrator’, ‘kwargs’: {}, ‘job_name’: ‘erpnext.accounts.doctype.subscription.subscription.process_all’, ‘event’: ‘hourly’, ‘method’: <function process_all at 0x7f40ccae4c80>, ‘site’: ‘teorlogico.angolaerp.co.ao’}
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in execute_job
method(**kwargs)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/subscription/subscription.py”, line 463, in process_all
subscriptions = get_all_subscriptions()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/subscription/subscription.py”, line 474, in get_all_subscriptions
as_dict=1
File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 171, in sql
self._cursor.execute(query)
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/lib/python3.6/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.6/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, “Unknown column ‘status’ in ‘where clause’”)
On the DB i could see that Status does not exist… now i wonder if i missed any update or the System did not update this doctype to include the missing field?