Custom Taxonomy Post Count Incorrect

I once had an issue where one category was reporting the incorrect number of posts – I created a new category, filtered posts by the offending category and then group added them all to the new category before deleting the offending category (hope that makes sense?!) – problem solved.

Have you tried looking in the database to ensure that the term_taxonomy table is reporting the correct number under count? If it is then you know it is a problem with your code, if the wrong number is reported then I’d suggest doing the above on 1 or two of the offending terms and seeing if that fixes it.

Thanks you all, that really helps me! But I’ve found a strange behaviour. My term count was 8, with 6 published and 2 pending posts classified under that terms. So I’ve made those steps:

1) I’ve added duffcub code to my functions.php
2) re-saved a pending post as pending (i.e. no status change)
3) term count goes down by one (as expected)

4) I’ve commented out duffcub code
5) re-saved the other pending post as pending (i.e. no status change)
6) term count goes down by one again (?!)

It seems that resaving pending posts o changing their status to draft (or to published then to pending or draft again) make terms counts update. Then the question is: why terms counts get out of sync at some point in the past?

Other details: probably those 2 post was changed to pending by my client, just before I update from wp 3.1 to wp 3.1.1. Maybe this count bug is resolved in wp 3.1.1?

PLZ don’t use my previous post. Here’s a version that works both in quick edit and full edit mode

add_action('edited_term_taxonomy','yoursite_edited_term_taxonomy',10,2);
function yoursite_edited_term_taxonomy($term,$taxonomy) {
  global $wpdb,$post;
  //in quick edit mode, $post is an array()
  //in full edit mode $post is an object
  if ( is_array( $post ))
    $posttype=$post['post_type'];
  else
    $posttype=$post->post_type;
  if ($posttype) {
    $DB_prefix=$wpdb->get_blog_prefix(BLOG_ID_CURRENT_SITE);
    $sql = "UPDATE ".$DB_prefix."term_taxonomy tt
          SET count =
          (SELECT count(p.ID) FROM  ".$DB_prefix."term_relationships tr
          LEFT JOIN ".$DB_prefix."posts p
          ON (p.ID = tr.object_id AND p.post_type = '".$posttype."' AND p.post_status = 'publish')
          WHERE tr.term_taxonomy_id = tt.term_taxonomy_id)
          WHERE tt.taxonomy = '".$taxonomy->name."'
      ";
    $wpdb->query($sql);
  }
}

@mad_max, can you help me work this code, I figure yoursite_edited_term_taxonomy is the Update Count Callback function ,

if i register a taxonomy say like this and use your modified version of duffcub’s code:

register_taxonomy(
‘genre’,
array(‘post’),
array(
‘hierarchical’ => true,
‘labels’ => $labels,
‘show_ui’ => true,
‘query_var’ => true,
‘rewrite’ => array( ‘slug’ => ‘genre’ ),
‘update_count_callback’ => ‘yoursite_edited_term_taxonomy’
)

But it dsnt seem to work

I have your code exactly like you provided in functions.php but it showing me incorrect count

Kindly help me resolve it!!