OperationalError: (1054, "Unknown column 'tabMaterial Request.items' in 'field list'")

When am trying to add item in purchase order from Material Request
am getting and error message

Traceback (most recent call last):
File “/home/erpnext/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 40, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 896, in call
return fn(*args, **newargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/desk/search.py”, line 12, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/desk/search.py”, line 91, in search_widget
as_list=not as_dict)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 1075, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 80, in execute
result = self.build_and_run()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 104, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘tabMaterial Request.items’ in ‘field list’”)

Did you do any customizations? If not then please do bench update and try again. I am not able to replicate it on v7.2.14

getting same error again
didnt did any customization.

Same here

Seems like you have added “items” in “Search Fields” options for Material Request via Customize Form. If yes, please remove that and reload the system, it should work.

1 Like