Error: Illegal SQL Query

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.

image

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.

1 Like

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.