V7 Report View Error


Just upgraded to latest v7 on master. Got this error when viewing report view on Stock Entry

Traceback (most recent call last):
  File "/home/vef1/frappe-bench/apps/frappe/frappe/app.py", line 55, in application
    response = frappe.handler.handle()
  File "/home/vef1/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle
  File "/home/vef1/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/vef1/frappe-bench/apps/frappe/frappe/__init__.py", line 876, in call
    return fn(*args, **newargs)
  File "/home/vef1/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 16, in get
    data = compress(execute(**args))
  File "/home/vef1/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 21, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
  File "/home/vef1/frappe-bench/apps/frappe/frappe/model/db_query.py", line 79, in execute
    result = self.build_and_run()
  File "/home/vef1/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/vef1/frappe-bench/apps/frappe/frappe/database.py", line 148, in sql
  File "/home/vef1/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/vef1/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabStock Entry Detail.name as 'Stock Entry Detail:name'' in 'field list'")

Can’t replicate the issue. Can you please update again and check?

@nabinhait Still the same…it happens to all doctypes… the cause is there’s always empty column at the end if we click Pick Columns under menu. so I have to remove the empty column first…Do you have any clues what cause this?