Hi,
We are unable to delete supplier and are faced with the following error :
App Versions { "accounts_custom": "0.0.1", "buying_custom": "0.0.1", "crm_custom": "0.0.1", "erpnext": "7.0.1", "frappe": "7.0.2", "hr_custom": "0.0.1", "projects_custom": "0.0.1", "support_custom": "0.0.1" } Route
List/Supplier Error Report
Traceback (most recent call last): File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 55, in application response = frappe.handler.handle() File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle execute_cmd(cmd) File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd ret = frappe.call(method, **frappe.form_dict) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 876, in call return fn(*args, **newargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 138, in delete_items frappe.delete_doc(doctype, d) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 613, in delete_doc ignore_permissions, flags) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/delete_doc.py", line 93, in delete_doc check_if_doc_is_linked(doc) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/delete_doc.py", line 172, in check_if_doc_is_linked ["name", "parent", "parenttype", "docstatus"], as_dict=True) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 410, in get_value ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug, cache=cache) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 451, in get_values out = self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 563, in _get_values_from_table conditions, order_by), values, as_dict=as_dict, debug=debug, update=update) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 137, in sql self._cursor.execute(query, values) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'supplier' in 'where clause'") Request Data
{ "type": "POST", "args": { "items": "[\"sup1\"]", "doctype": "Supplier", "cmd": "frappe.desk.reportview.delete_items" }, "freeze": true, "url": "/" }