FAIR

Federated and Independent Repositories

Fix Category Count

Plugin Banner

Fix Category Count

by abda53

Download
Description

This plugin will allow you to easily repair and fix your category count for posts, pages and custom post types

You may fix specific or all post type categories that you believe are incorrect.

It is always recommended that you have a backup of your database.

Possible Upcoming Features

  • Show a report after completion of tables updated

Please Read

If you like, or hate this plugin, please rate it on WordPress. If you are having any issues with it, please leave a comment on the plugin page.

  1. To install this plugin, either upload the entire directory to your wp-content/plugins/ directory, upload the zip file in your admin plugins screen. You may also install the plugin through wordpress.org
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. The plugin may be found in the admin menu under Tools
  1. Wrong Category Count

    Wrong Category Count

  2. Fixed Category Count

    Fixed Category Count

  3. Admin view page

    Admin view page

Why does the category count get messed up?

That is a great question.

Broken

By davemc50 on August 5, 2024

WordPress 6.x , no longer works, "There has been a critical error on this website"

Nice!

By Gustav (4ever16) on July 26, 2018

Worked perfect!

Not good for large sites I think

By deadhippo on December 29, 2017

I have a site with about 30,000 posts and the custom taxonomy count was off. After running this plugin a few times the taxonomy count actually got worse. I had to run it a few times because it timed out. Not worry, though. I used the following SQL to fix the problem and it ran very quickly.
9300 rows affected. (Query took 2.9573 seconds.)
UPDATE wp_term_taxonomy SET count = (
SELECT COUNT(*) FROM wp_term_relationships rel 
    LEFT JOIN wp_posts po ON (po.ID = rel.object_id) 
    WHERE 
        rel.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id 
        AND 
        wp_term_taxonomy.taxonomy NOT IN ('link_category')
        AND 
        po.post_status IN ('publish', 'future')
)
Source: https://stackoverflow.com/questions/18669256/how-to-update-wordpress-taxonomiescategories-tags-count-field-after-bulk-impo

Many thanks!!!

By trongnghia203 on September 20, 2017

Many thanks, brother. Although I don't know how comes the wrong number of posts in category... But your plugin is saving my wordpress life...

Simple and works like a charm.

By alburse on April 9, 2017

The number of posts associated with a category may get mixed up (mine is due to the daily import and deletion of the posts with wp all import plugin) and this plugin can correct this error to the actual number of posts. It also works with custom post types. My suggestion would be the addition of wp cron functionality so it can fix the category counts automatically once in a while to ensure all the categories are up to date.

Great Plugin

By Marinos (HelpPost.gr) on September 3, 2016

Thanks !!!!!

good tool

By Mike V. Gorbunov (michael_zloi) on September 3, 2016

a must have for fixing the import bugs

Super easy and quick

By wpisawesome on September 3, 2016

Thanks! This plugin saved me a lot of time trying to do this manually. Simply. effective. Bravo.

1.2

  • This now works on the latest version of WordPress

1.1

  • Updated for WordPress 5.0+ and PHP 7.4+
  • Fixed all SQL injection vulnerabilities using prepared statements
  • Added proper input sanitization and output escaping
  • Fixed security issues with nonce verification
  • Improved code quality and WordPress coding standards compliance
  • Fixed bug in update_category_correct_count method
  • Added proper capability checks
  • Replaced short tags with proper PHP tags
  • Added text domain for internationalization

1.0

  • Initial Development
Back to top