Hi
I got an error
Traceback (innermost last):
File "/home/mainul/m-store/apps/frappe/frappe/app.py", line 69, in application
response = frappe.handler.handle()
File "/home/mainul/m-store/apps/frappe/frappe/handler.py", line 77, in handle
execute_cmd(cmd)
File "/home/mainul/m-store/apps/frappe/frappe/handler.py", line 94, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/mainul/m-store/apps/frappe/frappe/__init__.py", line 798, in call
return fn(*args, **newargs)
File "/home/mainul/m-store/apps/frappe/frappe/desk/reportview.py", line 14, in get
return compress(execute(**get_form_params()))
File "/home/mainul/m-store/apps/frappe/frappe/desk/reportview.py", line 17, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File "/home/mainul/m-store/apps/frappe/frappe/model/db_query.py", line 50, in execute
result = self.build_and_run()
File "/home/mainul/m-store/apps/frappe/frappe/model/db_query.py", line 67, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File "/home/mainul/m-store/apps/frappe/frappe/database.py", line 146, in sql
self._cursor.execute(query)
File "/home/mainul/m-store/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/mainul/m-store/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabDocType._starred_by' in 'field list'")
I fixed it by change
def get_form_params():
"""Stringify GET request parameters."""
data = frappe._dict(frappe.local.form_dict)
del data["cmd"]
if isinstance(data.get("filters"), basestring):
data["filters"] = json.loads(data["filters"])
if isinstance(data.get("fields"), basestring):
data["fields"] = json.loads(data["fields"])
if isinstance(data.get("docstatus"), basestring):
data["docstatus"] = json.loads(data["docstatus"])
# queries must always be server side
data.query = None
return data
to
def get_form_params():
"""Stringify GET request parameters."""
data = frappe._dict(frappe.local.form_dict)
del data["cmd"]
if isinstance(data.get("filters"), basestring):
data["filters"] = json.loads(data["filters"])
if isinstance(data.get("fields"), basestring):
data["fields"] = json.loads(data["fields"])
if data.get('doctype') and data['doctype'] not in ["Comment", "Communication"] and '`tab{}`.`_starred_by`'.format(data['doctype']) in data['fields']:
data.fields.remove('`tab{}`.`_starred_by`'.format(data['doctype']))
if isinstance(data.get("docstatus"), basestring):
data["docstatus"] = json.loads(data["docstatus"])
# queries must always be server side
data.query = None
return data
in “/apps/frappe/frappe/desk/reportview.py” file
Thanks