Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 56, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 42, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 904, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 203, in get_sidebar_stats
return {“defined_cat”:cat_tags, “stats”:get_stats(stats, doctype, filters)}
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 219, in get_stats
filters = filters + [“ifnull(%s
,‘’)!=‘’” % tag], group_by = tag, as_list = True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1109, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 83, in execute
result = self.build_and_run()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 107, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 149, in sql
self._cursor.execute(query)
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
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') from tabSales Invoice
left join tabSales Invoice Item
on (`tabSales Invoi’ at line 1")
after I used pos to add customer and made the payment
I went to sales invoice to check my transaction
then the error appeared , what does this error mean ?