Server Error
Traceback (most recent call last):
File "/home/erpdev/frappe-bench/apps/frappe/frappe/app.py", line 62, in application
response = frappe.api.handle()
File "/home/erpdev/frappe-bench/apps/frappe/frappe/api.py", line 119, in handle
doctype, **frappe.local.form_dict)})
: : : : :
File "/home/erpdev/frappe-bench/env/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/erpdev/frappe-bench/env/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.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
'condition, webhook_json, request_url\n\t\t\tfrom `tabWebhook`\n\t\t\twhere `tabWebhook`.'
at line 1")
My actual request was :
{{Site}}/api/resource/Webhook
?filters=[["webhook_doctype", "=", "Sales Invoice"],
["webhook_docevent", "=", "on_change"]]
&fields=["condition", "webhook_json", "request_url"];
Clearly, "condition"
is a MariaDb reserved word, but what to do?