Title: Fix Category Count
Author: abda53
Published: <strong>2015 年 11 月 11 日</strong>
Last modified: 2026 年 1 月 14 日

---

搜索插件

![](https://ps.w.org/fix-category-count/assets/banner-772x250.png?rev=3439373)

![](https://ps.w.org/fix-category-count/assets/icon-256x256.png?rev=3439373)

# Fix Category Count

 作者：[abda53](https://profiles.wordpress.org/abda53/)

[下载](https://downloads.wordpress.org/plugin/fix-category-count.1.2.zip)

 * [详情](https://cn.wordpress.org/plugins/fix-category-count/#description)
 * [评价](https://cn.wordpress.org/plugins/fix-category-count/#reviews)
 *  [安装](https://cn.wordpress.org/plugins/fix-category-count/#installation)
 * [开发进展](https://cn.wordpress.org/plugins/fix-category-count/#developers)

 [支持](https://wordpress.org/support/plugin/fix-category-count/)

## 描述

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.

## 屏幕截图

[⌊Wrong Category Count⌉⌊Wrong Category Count⌉[

Wrong Category Count

[⌊Fixed Category Count⌉⌊Fixed Category Count⌉[

Fixed Category Count

[⌊Admin view page⌉⌊Admin view page⌉[

Admin view 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

## 常见问题

Why does the category count get messed up?

That is a great question.

## 评价

![](https://secure.gravatar.com/avatar/0685eb955e845624ca8bb10cbc86a85c3aa0901de4d01a03f1d36774c3c988b9?
s=60&d=retro&r=g)

### 󠀁[Works Perfectly Under WordPress 6.9.1](https://wordpress.org/support/topic/works-perfectly-under-wordpress-6-9-1/)󠁿

 [Alan](https://profiles.wordpress.org/alanwhiteman/) 2026 年 2 月 20 日

After deleting thousands of spam posts, including thousands of orphan categories,
I used the latest version of Fix Categories Count to reset the number of categories
to 0. It worked flawlessly and very fast.

![](https://secure.gravatar.com/avatar/ac7fe548f03560861ff6f3b39f07fdae631a6bbc910ac77f762a9132266f30ca?
s=60&d=retro&r=g)

### 󠀁[Broken](https://wordpress.org/support/topic/broken-714/)󠁿

 [davemc50](https://profiles.wordpress.org/davemc50/) 2024 年 8 月 5 日

Wordpress 6.x , no longer works, “There has been a critical error on this website”

![](https://secure.gravatar.com/avatar/1f89772fa54e6505e49146173645c4b127f64c058d2517e7846dee6632cbdf6f?
s=60&d=retro&r=g)

### 󠀁[Nice!](https://wordpress.org/support/topic/nice-2569/)󠁿

 [Gustav](https://profiles.wordpress.org/4ever16/) 2018 年 7 月 26 日

Worked perfect!

![](https://secure.gravatar.com/avatar/4ee59095a3912d8a795e70a84f3bfb290ef14377239eb379b3ce105110e0ef09?
s=60&d=retro&r=g)

### 󠀁[Not good for large sites I think](https://wordpress.org/support/topic/not-good-for-large-sites-i-think/)󠁿

 [deadhippo](https://profiles.wordpress.org/deadhippo/) 2017 年 12 月 29 日

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

![](https://secure.gravatar.com/avatar/ffec112efe0fdcce1be61a38e9c793e162534d6ef6ef74a591e57d91e5c838b6?
s=60&d=retro&r=g)

### 󠀁[Many thanks!!!](https://wordpress.org/support/topic/many-thanks-30/)󠁿

 [trongnghia203](https://profiles.wordpress.org/trongnghia203/) 2017 年 9 月 20 
日

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…

![](https://secure.gravatar.com/avatar/1ab06d9da4bc968b059a2bed3b0721f6ae3d304644ae4be648b65e83629ad13a?
s=60&d=retro&r=g)

### 󠀁[Simple and works like a charm.](https://wordpress.org/support/topic/simple-and-work-like-a-charm/)󠁿

 [alburse](https://profiles.wordpress.org/alburse/) 2017 年 4 月 9 日

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.

 [ 阅读所有9条评价 ](https://wordpress.org/support/plugin/fix-category-count/reviews/)

## 贡献者及开发者

「Fix Category Count」是开源软件。 以下人员对此插件做出了贡献。

贡献者

 *   [ abda53 ](https://profiles.wordpress.org/abda53/)

[帮助将「Fix Category Count」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/fix-category-count)

### 对开发感兴趣吗?

您可以[浏览代码](https://plugins.trac.wordpress.org/browser/fix-category-count/)，
查看[SVN仓库](https://plugins.svn.wordpress.org/fix-category-count/)，或通过[RSS](https://plugins.trac.wordpress.org/log/fix-category-count/?limit=100&mode=stop_on_copy&format=rss)
订阅[开发日志](https://plugins.trac.wordpress.org/log/fix-category-count/)。

## 更新日志

#### 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

## 额外信息

 *  版本 **1.2**
 *  最后更新：**5 月前**
 *  活跃安装数量 **100+**
 *  WordPress 版本 ** 4.7 或更高版本 **
 *  已测试的最高版本为 **6.9.4**
 *  PHP 版本 ** 7.0 或更高版本 **
 *  语言
 * [English (US)](https://wordpress.org/plugins/fix-category-count/)
 * 标签
 * [category](https://cn.wordpress.org/plugins/tags/category/)[count](https://cn.wordpress.org/plugins/tags/count/)
   [fix](https://cn.wordpress.org/plugins/tags/fix/)[repair](https://cn.wordpress.org/plugins/tags/repair/)
 *  [高级视图](https://cn.wordpress.org/plugins/fix-category-count/advanced/)

## 评级

 4.6 星（最高 5 星）。

 *  [  7 条 5 星评价     ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=5)
 *  [  1 条 4 星评价     ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=4)
 *  [  0 条 3 星评价     ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=3)
 *  [  1 条 2 星评价     ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=2)
 *  [  0 条 1 星评价     ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/fix-category-count/reviews/#new-post)

[查看全部评论](https://wordpress.org/support/plugin/fix-category-count/reviews/)

## 贡献者

 *   [ abda53 ](https://profiles.wordpress.org/abda53/)

## 支持

有话要说吗？是否需要帮助？

 [查看支持论坛](https://wordpress.org/support/plugin/fix-category-count/)

## 捐助

您愿意支持这个插件的发展吗?

 [ 捐助此插件 ](http://www.amazon.com/gp/registry/wishlist/2IYL0Q1K48ZTM/)