Search sometimes not working

  • Resolved Forge12 Interactive GmbH

    (@forge12)


    3 years, 7 months ago

    Hey there,

    we had an issue with the Plugin (Pro) – sometimes the Products didn’t return any results. After some debugging, we noticed that you escape the LIKE statements (wpdb->escape) in the file class-aws-search.php which generates a random GUID Number for the SQL LIKE Placeholders, e.g.: term_string LIKE ‘{RANDOM_GUID}keyword{RANDOM_GUID}’. This causing the search to not return any results.

    After removing the escape statement (temporarily) everything started to work normal. Can you check this issue and solve it in further updates?

    Best Regards
    Marc

Viewing 1 replies (of 1 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    3 years, 7 months ago

    Hi,

    So I think that you are talking about the $wpdb->esc_like method. In this case this method can’t cause any issues in search results. In fact all that he does is strip characters like ‘_’ or ‘%’ if they exist inside search terms.

    About that {RANDOM_GUID} – I believe that it is just encoded ‘%’ character.

    Strange that everything starts to work after you remove this method. Can you please tell me exactly what changes and in what string number you have changed to make the search working for you?

    Regards

Viewing 1 replies (of 1 total)

The topic ‘Search sometimes not working’ is closed to new replies.