Mysql error in logs (possibly autocomplete handler)

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 10 years, 2 months ago by Marto.