Forums › Forums › Search & Filter Pro › Search not returning any results anymore.

Tagged: , ,

Viewing 4 posts - 11 through 14 (of 14 total)
1 2
  • Ross Moderator
    (Private)  May 8, 2017 at 7:34 pm #107446

    Hi Jessie

    The issue is that WP Engine kills long queries (not time, but literally the string length of the SQL statement).

    To disable it check out this other forum post

    https://support.searchandfilter.com/forums/topic/killed-query-errors-in-log/#post-64826

    Let me know how you get on.

    Best

    Anonymous
    (Private)  May 8, 2017 at 7:35 pm #107448

    Hey guys,

    I rebuilt the entire search form from scratch, and it works. I didnt change ANY settings. So we can close this, although it is weird that a form with the exact same settings would work and the old one wouldn’t.

    Ross Moderator
    (Private)  May 8, 2017 at 7:37 pm #107450

    Hi Jessie

    As you add more content / posts, S&F queries will become longer, and there will likely be a tipping point where everything is working fine, to showing no results.

    In that event you will need to use the code linked above.

    Not sure about the exact details in your setups, but even posts having different IDs (which have a different string length in the SQL statement) could affect when this triggers in your environment.

    Let us know if this resurfaces.

    Best

    Anonymous
    (Private)  May 8, 2017 at 7:41 pm #107452

    good to know Ross! I have made that adjustment to my WP_config file as well.

  • Author
    Posts
Viewing 4 posts - 11 through 14 (of 14 total)
1 2