No results after updating to 2.1.2

Anonymous

#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

#37197

This reply has been marked as private.

Anonymous

#37235

This reply has been marked as private.

Ross Moderator

#37326

This reply has been marked as private.

Anonymous

#37877

This reply has been marked as private.

Ross Moderator

#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

#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

#37979

Hey Jessie

Glad you found the culprit.

😀

[Author]

Posts