Forums › Forums › Search & Filter Pro › No results after updating to 2.1.2
Tagged: error, No results
- This topic has 7 replies, 2 voices, and was last updated 9 years, 6 months ago by
Ross.
-
Ross Moderator(Private) February 17, 2016 at 12:11 pm #37197This 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 #37978you 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 #37979Hey Jessie
Glad you found the culprit.
😀
-
AuthorPosts