hello @all
When I connect dropbox for the first time backup was taking successfully everyday, but
After restoring my database in a new erpnext, erpnext couldn’t take backup anymore it shows this error in the background as failed jobs.
Traceback (most recent call last):
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py", line 793, in perform_job
rv = job.perform()
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/rq/job.py", line 599, in perform
self._result = self._execute()
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/rq/job.py", line 605, in _execute
return self.func(*self.args, **self.kwargs)
File "/opt/bench/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 116, in execute_job
log(method_name, message=repr(locals()))
File "/opt/bench/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 207, in log
d = frappe.new_doc("Error Log")
File "/opt/bench/frappe-bench/apps/frappe/frappe/__init__.py", line 642, in new_doc
return get_new_doc(doctype, parent_doc, parentfield, as_dict=as_dict)
File "/opt/bench/frappe-bench/apps/frappe/frappe/model/create_new.py", line 20, in get_new_doc
frappe.local.new_doc_templates[doctype] = make_new_doc(doctype)
File "/opt/bench/frappe-bench/apps/frappe/frappe/model/create_new.py", line 41, in make_new_doc
set_user_and_static_default_values(doc)
File "/opt/bench/frappe-bench/apps/frappe/frappe/model/create_new.py", line 51, in set_user_and_static_default_values
user_permissions = get_user_permissions()
File "/opt/bench/frappe-bench/apps/frappe/frappe/core/doctype/user_permission/user_permission.py", line 49, in get_user_permissions
fields=['allow', 'for_value', 'skip_for_doctype'], filters=dict(user=user)):
File "/opt/bench/frappe-bench/apps/frappe/frappe/__init__.py", line 1211, in get_all
return get_list(doctype, *args, **kwargs)
File "/opt/bench/frappe-bench/apps/frappe/frappe/__init__.py", line 1184, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File "/opt/bench/frappe-bench/apps/frappe/frappe/model/db_query.py", line 87, in execute
result = self.build_and_run()
File "/opt/bench/frappe-bench/apps/frappe/frappe/model/db_query.py", line 111, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File "/opt/bench/frappe-bench/apps/frappe/frappe/database.py", line 209, in sql
self._cursor.execute(query)
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
result.read()
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
first_packet = self.connection._read_packet()
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
packet.check_error()
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/opt/bench/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (1054, u"Unknown column 'skip_for_doctype' in 'field list'")
even I delete the existing app in drop box and create a new one, that didn’t help, this time when I click on take backup now button job does not queue in the background.