This really is super strange in my experience. I've got a custom Wordpress query inside a theme's shortcode, that was working fine until lately. We have made a few changes towards the server since that time, but I am confident I have disabled these for testing reasons but the issue continues.
I left the Wordpress_Query object, and that is in which the weirdnress starts. The SQL it creates appears correct, so when I run it in phpMyAdmin, it provides the listing of posts within the correct order. Here's the SQL which seems to become working:
SELECT wp_2_posts.* FROM wp_2_posts INNER JOIN wp_2_term_relationships ON (wp_2_posts.ID = wp_2_term_relationships.object_id) INNER JOIN wp_2_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_id) WHERE 1=1 AND ( wp_2_term_relationships.term_taxonomy_id IN (4) ) AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish') AND (wp_2_postmeta.meta_key = 'Order' ) GROUP BY wp_2_posts.ID ORDER BY wp_2_posts.post_date ASC
When I stated, after i by hand run this from the DB, it pulls in the appropriate listing of posts. However, around the publish page (that is really a 'page' which utilizes a shortcode to create and display a custom query, within our situation all posts of the certain category), Publish #7 is displayed first, then #2, #3, #4, #5, #6 and lastly #7 again. Publish #1 isn't displayed, and publish #7 shows instead. Publish #7 shows two times.
Whether it helps, within the Wordpress_Query object which i left (out of this custom query), the posts are listed within the
[posts] array within the incorrect order. The SQL appears to operate properly, however the posts Wordpress is operating on are improperly purchased.
Recent changes towards the server include setting up APC (Advanced PHP Cache), that when I disabled and examined again, didn't have effect.
Also, there exists a user who edited a few of the posts, usually the
excerpt fields. We 'updated the network' towards the latest version of Wordpress, and up-to-date our membership wordpress plugin (WishList Member). On top of that I can not think about something that has transformed.
I'd appreciate any assist with this problem -- it's driving me crazy!