Wordpress Posts Out Of Order after 3.1 Update

Question

The first posts I wrote are now showing on the homepage. After Googling, the problem is because I am using query_posts to exclude a certain category on the main loop.

<?php query_posts($query_string . '&cat=-4'); ?>

---

how can I still exclude this category, but not have my posts reversed?

Answer 1

Simply add orderby to your query_posts

<?php query_posts($query_string . '&cat=-4&orderby=date&order=DESC'); ?>

Update

try:

global $wp_query;
$args = array_merge( $wp_query->query, array('cat' => -4,'orderby' => 'date','order' => 'ASC'));
query_posts( $args );

and if you still get the same change ASC to DESC.

Answer 2

DING DING DING. As Otto pointed out, the problem is because the MYSQL version I'm running is 5.0.51a which is causing the bug.

Answer 3

The cat parameter is partly broken in 3.1.

Install the Hotfix plugin to fix it:

http://wordpress.org/extend/plugins/hotfix/

Answer 4

I just encountered this issue as well when upgrading a staging site to WordPress 3.1 (from 3.0.1).

The hotfix plugin didn't fix the issue.

I fixed it by upgrading MySQL to version 5.1.40 (from 5.0.51b)