duffcub

Using the standard [wp-favorite-posts] shortcode solved this for me

Hi,

After further digging, I think I have a workaround which while not exactly solving the problem, does add a function which corrects the count whenever posts are trashed.

Add this to your functions.php file, and all should be good. I’ve tested it on my site and it appears to be working as expected.

/*
 * Corrects count in term_taxonomy table for terms which are are not in published posts
 */

add_action('edited_term_taxonomy','yoursite_edited_term_taxonomy',10,2);
function yoursite_edited_term_taxonomy($term,$taxonomy) {
  global $wpdb;
  $sql = "UPDATE wp_term_taxonomy tt
        SET count =
        (SELECT count(p.ID) FROM  wp_term_relationships tr
        LEFT JOIN wp_posts p
        ON (p.ID = tr.object_id AND p.post_type = '[post_type]' AND p.post_status = 'publish')
        WHERE tr.term_taxonomy_id = tt.term_taxonomy_id)
        WHERE tt.taxonomy = '[taxonomy_name]'
    ";
  $wpdb->query($sql);
}

With thanks to http://wordpress.stackexchange.com/questions/3166/custom-taxonomies-incorrectly-counting-revisions