Forums › Forums › Search & Filter Pro › "All Items" returns "No Results Found"

Tagged: 

Viewing 6 posts - 31 through 36 (of 36 total)
1 2 3 4
  • Anonymous
    (Private)  January 12, 2018 at 5:10 pm #152264
    This reply has been marked as private.
    Trevor
    (Private)  January 12, 2018 at 5:25 pm #152268
    This reply has been marked as private.
    Ross Moderator
    (Private)  January 18, 2018 at 6:36 pm #153330
    This reply has been marked as private.
    Anonymous
    (Private)  January 18, 2018 at 7:44 pm #153346
    This reply has been marked as private.
    Ross Moderator
    (Private)  January 21, 2018 at 7:03 pm #153720

    Hi Art

    After going round in circles I think I see the issue you have.

    Basically, WP Engine, kills long queries (the length of the SQL statement, not duration).

    An unfiltered query is actually the longest query (because it has all the Post IDs of your results, and an unfiltered result set is the largest result set you can have).

    This actually happens with many other search related plugins, who do their own search / heavy lifting, and then provide the results as IDs to a WordPress query (making for a simple, but long SQL statement).

    There is a setting to override this though – add to wp-config:

    define('WPE_GOVERNOR', false);

    (also see here for another related support note about this – https://support.searchandfilter.com/forums/topic/killed-query-errors-in-log/#post-64826)

    I would just say though, that rather than adding this in blindly, to research and make sure this setting doesn’t adversely affect anything in your site.

    Thanks

    Anonymous
    (Private)  January 21, 2018 at 7:49 pm #153724
    This reply has been marked as private.
  • Author
    Posts
Viewing 6 posts - 31 through 36 (of 36 total)
1 2 3 4