Mysql error in logs (possibly autocomplete handler)

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Mysql error in logs (possibly autocomplete handler)

This topic contains 2 replies, has 2 voices, and was last updated by Marto Marto 6 years, 9 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #7955
    Marto
    Marto
    Participant

    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 6 years, 9 months ago by Marto Marto.
    #7960
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    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 :)


    #7979
    Marto
    Marto
    Participant

    Hi Ernest,

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

    Best regards.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.