Hi,
In the Sales Order Report Builder, when I am trying to add the Item Code from Sales Order Item, I am getting this error. Even though, the report goes through when I add the column. Once I log off and re-login, the report is giving errors.
Traceback (most recent call last):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 879, in call
return fn(*args, **newargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 16, in get
data = compress(execute(**args))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 79, in execute
result = self.build_and_run()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 103, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘tabSales Order Item.name as ‘Sales Order Item:name’’ in ‘field list’”)
Can you please help me to resolve this error?
Thanks
Uma