Melissa Yip asked 6 years ago
I encounter this error message when using the search feature for enums. This occurs in both versions 2.1 and 2.6. Thanks.
Abu Ghufran Staff answered 6 years ago
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.
Melissa Yip answered 6 years ago
Here’s the error message I’m getting with debug turned on. Is there a reason why we’re passing an enum to lower()?
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’)
