get_posts returns invalid data when using category= parameter

[MichaelH]

Take a new 2.3.1 install with this code:

$myposts = get_posts('category=2');

You would expect to get NO results, as an out-of-the-box install has no posts with category 2, but that code will return the "Hello World!" post.

Guessing this might be caused by get_posts not discerning between post categories and link categories (e.g. the link with link_id=1 in category 2 causes post with ID=1 to be returned).

Line #257 in post.php:

$query .= empty( $category ) ? '' :
AND ($wpdb->posts.ID = $wpdb->term_relationships.object_id
AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_taxonomy.term_id = " . $category. ") ";

This should be:

$query .= empty( $category ) ? '' :
"AND ($wpdb->posts.ID = $wpdb->term_relationships.object_id
AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_taxonomy.term_id = " . $category. "
AND $wpdb->term_taxonomy.taxonomy = 'category') ";

Changed milestone to 2.3.2, since this is an easy fix to slip in.

Kafkaesqui, thank you for your participation! Please don't change the milestones, leave that for the project leads.

+1 for getting this in 2.3.2 -- it's just one less problem to explain in the forums ;)

Patch attached.

for trunk 2.4 bleeding

(In [6490]) Fetch only post category terms in get_posts(). Props MichaelH. fixes #5317

Reopening because [6490] doesn't look to have the complete fix from the ​5317_for_24.diff.

I moved everything in the prepare(), but I think I got it all.

Missed parameter in patchset 6490 fixed.

Still not available in release 2.3.3

[6646] fixes the missing cat from [6490]. I'll milestone this for 2.3.4, in case we do another release.

2.3.x is dead, 2.5 is stable released, Marking as fixed in 2.5