WP Category Posts and WordPress 2.3

just open up the plugin and change this:

$get_posts_in_cat = "SELECT $wpdb->posts.ID, $wpdb->posts.post_title, ";
$get_posts_in_cat .= "$wpdb->post2cat.post_id, $wpdb->post2cat.category_id ";
$get_posts_in_cat .= "FROM $wpdb->posts, $wpdb->post2cat ";
$get_posts_in_cat .= "WHERE $wpdb->posts.ID = $wpdb->post2cat.post_ID ";
$get_posts_in_cat .= "AND $wpdb->post2cat.category_id = '$catID' ";
$get_posts_in_cat .= "AND $wpdb->posts.post_status = 'publish' ";
$get_posts_in_cat .= "ORDER BY $wpdb->posts.post_title ";

to this:

$tp = $wpdb->prefix;
$get_posts_in_cat = "SELECT ID, {$tp}term_taxonomy.term_id as category_id, post_title
FROM {$tp}posts, {$tp}term_relationships, {$tp}term_taxonomy
WHERE {$tp}posts.ID = {$tp}term_relationships.object_id
AND {$tp}term_relationships.term_taxonomy_id = {$tp}term_taxonomy.term_taxonomy_id
AND {$tp}term_taxonomy.taxonomy = 'category'
AND {$tp}term_taxonomy.term_id = '$catID'
AND post_status = 'publish'
AND post_type = 'post'
ORDER BY post_title ";

should work just fine (works for me ;))

Thank you CrazySerb, I was looking for this too. You saved me a lot of time!

Thank you for providing this code. I upgraded to WordPress 2.3 and got the same error message as above. I dropped your code into the plugin file and it corrected the problem. Thank you so much!

CrazySerb you are a genius! Thank you for helping us!!!

I solved problem by changing the Theme.Previous
Theme was incompatible with WordPress 2.3.3.