Support Forums

The forums are closed and will be removed when we launch our new site.

Looking for support? You can access the support system via your account.

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
  • Art Munson
    (Private)  January 12, 2018 at 5:10 pm #152264
    This reply has been marked as private.
    Trevor Moderator
    (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.
    Art Munson
    (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

    Art Munson
    (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

The topic ‘"All Items" returns "No Results Found"’ is closed to new replies.