Reply To: Search Results Not displaying for specific keywords

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Search Results Not displaying for specific keywords Reply To: Search Results Not displaying for specific keywords

#3900
Ernest Marcinko
Ernest Marcinko
Keymaster

The error is not acutally causes by that part, it’s this:

WordPress database error Got error ‘trailing backslash (\)’

(lower(dist_posts.post_content) REGEXP 'paraprofessional|contract\\')

It’s either someone tried to search for a phrase with backslashes or attempting an SQL injection. the “\\” string might have been something else before processing. I would say it was not on purpose, doesn’t look like a injection pattern.

Anyways, it’s harmless because the wp database layer escapes and double checks everything and returns an error after terminating the query like this if something is not right, consequently the search returns no results.

Best,
Ernest Marcinko

If you like my products, don't forget to rate them on codecanyon :)