Forums › Forums › Search & Filter Pro › No results after updating to 2.1.2

Tagged: ,

Viewing 8 posts - 1 through 8 (of 8 total)
  • Anonymous
    (Private)  February 17, 2016 at 2:49 am #37176

    I haven’t changed any of the settings but all of a sudden I get “No Results” when I add ANY filters. Here are my settings:

    Products post type
    posts per page: -1
    maintain search form state : 1
    AND relationship
    Update search form on user interaction
    On: Post type Archives, Tag, Category & taxonomy archives

    Not sure what other information you might need. here is a link to our site:
    http://goldengoodsusa.com/our-bodystyles/

    PLEASE LET ME KNOW ASAP what else you might need or what I can do. I tried rebuilding the cache – it had no effect.

    Ross Moderator
    (Private)  February 17, 2016 at 12:11 pm #37197
    This reply has been marked as private.
    Anonymous
    (Private)  February 17, 2016 at 5:56 pm #37235
    This reply has been marked as private.
    Ross Moderator
    (Private)  February 18, 2016 at 2:05 pm #37326
    This reply has been marked as private.
    Anonymous
    (Private)  February 24, 2016 at 10:44 pm #37877
    This reply has been marked as private.
    Ross Moderator
    (Private)  February 25, 2016 at 12:31 pm #37933

    Hi Jessie

    It looks like something might be modifying the S&F query making it invalid.

    Can you disable other plugins and test on another theme to see if you get the same issue?

    I ran the query through an SQL checker, and the error seems to be on this part of the query:

    ORDER BY wp_ffjq_posts.menu_order ASC,

    This is because the end of the statement has a comma, an SQL query should not finish with a comma – so somehow this is related to the ordering possibly.

    This can’t really be S&F doing this, because we just use the WP_Query API, so S&F doesn’t write any SQL here at all… very odd.

    Thanks

    Anonymous
    (Private)  February 25, 2016 at 6:35 pm #37978

    you are right! Sorry I should have tested out the other plugins first, it just seemed to coincide so much with the update. It was a plugin called Anything Order that allowed us to drag and drop posts into the order we want without having to change the date or other info on the post. I guess we will have to find a new way to order the posts.

    Thanks for the help!

    Ross Moderator
    (Private)  February 25, 2016 at 6:56 pm #37979

    Hey Jessie

    Glad you found the culprit.

    😀

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)