Basically, it’s a end-user error message. For actual technical error message set:

$g->debug = 1;

where $g is jqgrid() object. And most likely it will be a SQL query issue. Check or Send that message here if not solved.

Here’s the error message I’m getting with debug turned on. Is there a reason why we’re passing an enum to lower()?

View post on imgur.com

In your enum case, it is trying to performing (case insensitive) contains search.

On enum column, you can limit equal search. To perform equal search.

$col[“searchoptions”][“sopt”] = array(“eq”);

// optionally set limited search operators
// (e.g. bw = begins with, ‘eq’,’ne’,’lt’,’le’,’gt’,’ge’,’bw’,’bn’,’in’,’ni’,’ew’,’en’,’cn’,’nc’)

Thanks, Abu. That resolved my issue.