[v7] Unable to delete Supplier


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"
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
  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
  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": "/"

depending on whether any entries for this supplier exists it might be not possible to just delete it.
If that’s your scenario the way to go to make it invisible on your system would be to de-activate that supplier.


Thank you. It worked great after a bench update. All good now!