⚠ In case you've missed it we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠

key-insensitive search not working

grocery crud kei insensitive search function bugs

  • Please log in to reply
No replies to this topic

#1 matteo94s



  • Members
  • Pip
  • 3 posts

Posted 26 October 2018 - 07:09 AM


i'm using groceryCRUD with postgresql and it works fine for me but if i search something with the exact same character as the word i have to search, it works(key sensitive search). if i perform a key insensitive search it doesn't work. i tried to replace LIKE with ILIKE , which in postgresql stand for key insensitive search, and it works with some fields (like name and surname) but it throws error 500 for other fields (like country and city).

I replaced LIKE in /DB_query_builder.php.

the error looks like this:


jquery-1.11.1.min.js:4 POST 500 (Internal Server Error)


Can somebody help me?


Thanks a lot

Also tagged with one or more of these keywords: grocery crud, kei insensitive, search function, bugs

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users