Mysql error in logs (possibly autocomplete handler)

[MartoParticipant]

Dear All,

We have noted the below errors thrown when queries contain ‘ (apostrophe sign punctuation mark) :

quote

[08-Mar-2016 10:22:22 UTC] Error of WordPress database You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘entendre%’ AND
(wp_posts.post_type IN (‘post’) ) AND
‘ at line 6 for the query
SELECT
ID as id,
post_title as title
FROM wp_posts
WHERE
post_title LIKE ‘s\\’entendre%’ AND
(wp_posts.post_type IN (‘post’) ) AND
post_status = ‘publish’
LIMIT 10
made by do_action(‘ASP_nopriv_ajaxsearchpro_autocomplete’), call_user_func_array, WD_ASP_Autocomplete_Handler->handle, wpd_keywordSuggest->getKeywords, wpd_titlesKeywordSuggest->getKeywords, wpd_titlesKeywordSuggest->getResults

unquote

We have autocomplete enabled and our index table is currently being built / completed as well.

We would appreciate your support,

Many thanks,

Best regards

• This topic was modified 8 years, 6 months ago by  Marto.

[Ernest MarcinkoKeymaster]

Hi Marto!

This is indeed an issue related to some special characters which need escaping. I have got reports earlier this week about the same problem, I will investigate and fix them for the upcoming update. Luckily it’s not a security issue, as the problem is caused by escaping the special characters twice by accident, instead of once. Unfortunately MySql can’t deal with that, so the query with the special character is simply not executed.

Keep an eye for the upcoming update, this problem should be fixed with it’s release!

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

[MartoParticipant]

Hi Ernest,

Thank you for your reply and looking forward to the next update,

Best regards.

[Author]

Posts