Hello All,
I am having the the error “Illegal SQL Query” when clicking on some fields in list view.
The error shows on Supplier and a custom doctype I created.
Kindly advise how to resolve this.
Hello All,
I am having the the error “Illegal SQL Query” when clicking on some fields in list view.
The error shows on Supplier and a custom doctype I created.
Kindly advise how to resolve this.
This is likely because you have a field or doctype name that uses a reserved SQL keyword. “CASE” is one of the most common.
There were grave and acute accent marks in the field name which were causing this error
That’ll do it. Please mark this resolved for the next person to find.