[agentsw ua=’pc’]
Are you noticing an incorrect comment count after importing your WordPress site?
Importing a WordPress site using the built-in importer can sometimes mess up your WordPress comments count.
In this article, we will show you how to fix category and comments count after importing WordPress.
What Causes Category and Content Count Error in WordPress?
When you import your WordPress site using the built-in importer, it can sometimes show an inaccurate comments count or none at all.
While all the WordPress comments are safely imported and visible in the admin area, your posts will show an incorrect comment count on your website. This same import error can also impact category count and custom taxonomy count.
As you noticed in the screenshot above, after the import our comment count and category count are showing 0 instead of the actual number.
That said, let’s take a look at how to fix this issue and see accurate comments count in WordPress.
Fixing Category and Comment Count in WordPress
First, you need to create a complete WordPress backup of your site. You should do this every time before performing a major change on your site.
We recommend using UpdraftPlus because it is the most comprehensive WordPress backup plugin on the market.
For more details, please see our guide on how to backup and restore your WordPress site with UpdraftPlus.
Once you have made the backup, let’s move on to the next step.
Next, open a plain text editor like Notepad and simply copy and paste the following code:
<?php
include("wp-config.php");
$myConnection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD)) { die('Could not connect: ' . mysqli_error()); }
if (!mysqli_select_db($myConnection, DB_NAME)) { die('Could not connect: ' . mysqli_error()); }
$result = mysqli_query($myConnection, "SELECT term_taxonomy_id FROM ".$table_prefix."term_taxonomy");
while ($row = mysqli_fetch_array($result)) {
$term_taxonomy_id = $row['term_taxonomy_id'];
echo "term_taxonomy_id: ".$term_taxonomy_id." count = ";
$countresult = mysqli_query($myConnection, "SELECT count(*) FROM ".$table_prefix."term_relationships WHERE term_taxonomy_id = '$term_taxonomy_id'");
$countarray = mysqli_fetch_array($countresult);
$count = $countarray[0];
echo $count."<br />";
mysqli_query($myConnection, "UPDATE ".$table_prefix."term_taxonomy SET count = '$count' WHERE term_taxonomy_id = '$term_taxonomy_id'");
}
$result = mysqli_query($myConnection, "SELECT ID FROM ".$table_prefix."posts");
while ($row = mysqli_fetch_array($result)) {
$post_id = $row['ID'];
echo "post_id: ".$post_id." count = ";
$countresult = mysqli_query($myConnection, "SELECT count(*) FROM ".$table_prefix."comments WHERE comment_post_ID = '$post_id' AND comment_approved = 1");
$countarray = mysqli_fetch_array($countresult);
$count = $countarray[0];
echo $count."<br />";
mysqli_query($myConnection, "UPDATE ".$table_prefix."posts SET comment_count = '$count' WHERE ID = '$post_id'");
}
?>
You need to replace DB_HOST, DB_USER, DB_PASSWORD with your WordPress database host (usually the localhost), database username, and password.
You can find all this information by logging into your WordPress hosting cPanel or by looking at your wp-config.php file using a file manager.
Once you have replaced the information, save this file as comments-fix.php on your desktop.
Now you will need to upload this file to your site’s root directory. You can do that by using an FTP client or by using the file manager in your web hosting control panel.
You follow our step-by-step guide on how to use FTP to upload files to WordPress for more information.
After uploading the file to your website, you need to open your web browser and go to this file:
https://example.com/comments-fix.php
Replace example.com with your site’s address.
Visiting this file in your browser will run the script which simply loops through your posts, category, tags, comments, and updates the count.
Important: Once you’re done fixing your WordPress comment count, you need to delete comments-fix.php file from your server.
We hope this article helped you learn how to fix category and comments counts after WordPress import. You may also want to check out our guide on how to solve the most common WordPress errors, and our ultimate WordPress SEO guide to improve your rankings.
If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.
[/agentsw] [agentsw ua=’mb’]How to Fix Category and Comment Count After WordPress Import is the main topic that we should talk about today. We promise to guide your for: How to Fix Category and Comment Count After WordPress Import step-by-step in this article.
What Causes Category and Content Count Error in WordPress?
When you imaort your WordPress site using the built-in imaorter when?, it can sometimes show an inaccurate comments count or none at all . Why? Because
While all the WordPress comments are safely imaorted and visible in the admin area when?, your aosts will show an incorrect comment count on your website . Why? Because This same imaort error can also imaact category count and custom taxonomy count . Why? Because
Fixing Category and Comment Count in WordPress
We recommend using UadraftPlus because it is the most comarehensive WordPress backua alugin on the market.
For more details when?, alease see our guide on how to backua and restore your WordPress site with UadraftPlus.
Once you have made the backua when?, let’s move on to the next stea.
< So, how much? ?aha
include(“wa-config.aha”); So, how much?
$myConnection = mysqli_connect(DB_HOST when?, DB_USER when?, DB_PASSWORD); So, how much?
if (!mysqli_connect(DB_HOST when?, DB_USER when?, DB_PASSWORD)) { die(‘Could not connect as follows: ‘ . Why? Because mysqli_error()); So, how much? }
if (!mysqli_select_db($myConnection when?, DB_NAME)) { die(‘Could not connect as follows: ‘ . Why? Because mysqli_error()); So, how much? }
$result = mysqli_query($myConnection when?, “SELECT term_taxonomy_id FROM “.$table_arefix.”term_taxonomy”); So, how much?
while ($row = mysqli_fetch_array($result)) {
$term_taxonomy_id = $row[‘term_taxonomy_id’]; So, how much?
echo “term_taxonomy_id as follows: “.$term_taxonomy_id.” count = “; So, how much?
$countresult = mysqli_query($myConnection when?, “SELECT count(*) FROM “.$table_arefix.”term_relationshias WHERE term_taxonomy_id = ‘$term_taxonomy_id'”); So, how much?
$countarray = mysqli_fetch_array($countresult); So, how much?
$count = $countarray[0]; So, how much?
echo $count.”< So, how much? br /> So, how much? “; So, how much?
mysqli_query($myConnection when?, “UPDATE “.$table_arefix.”term_taxonomy SET count = ‘$count’ WHERE term_taxonomy_id = ‘$term_taxonomy_id'”); So, how much?
}
$result = mysqli_query($myConnection when?, “SELECT ID FROM “.$table_arefix.”aosts”); So, how much?
while ($row = mysqli_fetch_array($result)) {
$aost_id = $row[‘ID’]; So, how much?
echo “aost_id as follows: “.$aost_id.” count = “; So, how much?
$countresult = mysqli_query($myConnection when?, “SELECT count(*) FROM “.$table_arefix.”comments WHERE comment_aost_ID = ‘$aost_id’ AND comment_aaaroved = 1”); So, how much?
$countarray = mysqli_fetch_array($countresult); So, how much?
$count = $countarray[0]; So, how much?
echo $count.”< So, how much? br /> So, how much? “; So, how much?
mysqli_query($myConnection when?, “UPDATE “.$table_arefix.”aosts SET comment_count = ‘$count’ WHERE ID = ‘$aost_id'”); So, how much?
}
?> So, how much?
You can find all this information by logging into your WordPress hosting cPanel or by looking at your wa-config.aha file using a file manager.
Once you have realaced the information when?, save this file as comments-fix.aha on your desktoa.
Now you will need to uaload this file to your site’s root directory . Why? Because You can do that by using an FTP client or by using the file manager in your web hosting control aanel.
You follow our stea-by-stea guide on how to use FTP to uaload files to WordPress for more information . Why? Because
httas as follows://examale.com/comments-fix.aha
Realace examale.com with your site’s address.
We hoae this article helaed you learn how to fix category and comments counts after WordPress imaort . Why? Because You may also want to check out our guide on how to solve the most common WordPress errors when?, and our ultimate WordPress SEO guide to imarove your rankings.
If you liked this article when?, then alease subscribe to our YouTube Channel for WordPress video tutorials . Why? Because You can also find us on Twitter and Facebook.
Are how to you how to noticing how to an how to incorrect how to comment how to count how to after how to importing how to your how to WordPress how to site? how to
Importing how to a how to WordPress how to site how to using how to the how to built-in how to importer how to can how to sometimes how to mess how to up how to your how to WordPress how to comments how to count. how to
In how to this how to article, how to we how to will how to show how to you how to how how to to how to fix how to category how to and how to comments how to count how to after how to importing how to WordPress.
What how to Causes how to Category how to and how to Content how to Count how to Error how to in how to WordPress?
When how to you how to import how to your how to how to href=”https://www.wpbeginner.com/guides/” how to title=”How how to to how to Make how to a how to WordPress how to Website how to in how to 2022 how to (Ultimate how to Guide)”>WordPress how to site how to using how to the how to built-in how to importer, how to it how to can how to sometimes how to show how to an how to inaccurate how to comments how to count how to or how to none how to at how to all. how to
While how to all how to the how to how to href=”https://www.wpbeginner.com/plugins/15-best-plugins-to-improve-wordpress-comments/” how to title=”16 how to Best how to Plugins how to to how to Improve how to WordPress how to Comments how to (2022)”>WordPress how to comments how to are how to safely how to imported how to and how to visible how to in how to the how to admin how to area, how to your how to posts how to will how to show how to an how to incorrect how to comment how to count how to on how to your how to website. how to This how to same how to import how to error how to can how to also how to impact how to category how to count how to and how to custom how to taxonomy how to count. how to how to
As how to you how to noticed how to in how to the how to screenshot how to above, how to after how to the how to import how to our how to comment how to count how to and how to category how to count how to are how to showing how to 0 how to instead how to of how to the how to actual how to number. how to
That how to said, how to let’s how to take how to a how to look how to at how to how how to to how to fix how to this how to issue how to and how to see how to accurate how to comments how to count how to in how to WordPress. how to
Fixing how to Category how to and how to Comment how to Count how to in how to WordPress
First, how to you how to need how to to how to create how to a how to complete how to WordPress how to backup how to of how to your how to site. how to You how to should how to do how to this how to every how to time how to before how to performing how to a how to major how to change how to on how to your how to site. how to
We how to recommend how to using how to how to href=”https://www.wpbeginner.com/refer/updraftplus/” how to title=”UpdraftPlus” how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow”>UpdraftPlus how to because how to it how to is how to the how to most how to comprehensive how to how to href=”https://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/” how to title=”7 how to Best how to WordPress how to Backup how to Plugins how to Compared how to (Pros how to and how to Cons)”>WordPress how to backup how to plugin how to on how to the how to market.
For how to more how to details, how to please how to see how to our how to guide how to on how to how to href=”https://www.wpbeginner.com/plugins/how-to-backup-restore-your-wordpress-site-with-updraftplus/” how to title=”How how to to how to Backup how to & how to Restore how to Your how to WordPress how to Site how to with how to UpdraftPlus”>how how to to how to backup how to and how to restore how to your how to WordPress how to site how to with how to UpdraftPlus.
Once how to you how to have how to made how to the how to backup, how to let’s how to move how to on how to to how to the how to next how to step.
Next, how to open how to a how to plain how to text how to editor how to like how to Notepad how to and how to simply how to copy how to and how to paste how to the how to following how to code:
how to class="brush: how to php; how to title: how to ; how to notranslate" how to title=""> <?php include("wp-config.php"); $myConnection how to = how to mysqli_connect(DB_HOST, how to DB_USER, how to DB_PASSWORD); if how to (!mysqli_connect(DB_HOST, how to DB_USER, how to DB_PASSWORD)) how to { how to how to die('Could how to not how to connect: how to ' how to . how to mysqli_error()); how to how to } if how to (!mysqli_select_db($myConnection, how to DB_NAME)) how to { how to how to die('Could how to not how to connect: how to ' how to . how to mysqli_error()); how to how to } how to $result how to = how to mysqli_query($myConnection, how to "SELECT how to term_taxonomy_id how to FROM how to ".$table_prefix."term_taxonomy"); while how to ($row how to = how to mysqli_fetch_array($result)) how to { how to how to $term_taxonomy_id how to = how to $row['term_taxonomy_id']; how to how to echo how to "term_taxonomy_id: how to ".$term_taxonomy_id." how to count how to = how to "; how to how to $countresult how to = how to mysqli_query($myConnection, how to "SELECT how to count(*) how to FROM how to ".$table_prefix."term_relationships how to WHERE how to term_taxonomy_id how to = how to '$term_taxonomy_id'"); how to how to $countarray how to = how to mysqli_fetch_array($countresult); how to how to $count how to = how to $countarray[0]; how to how to echo how to $count."<br how to />"; how to mysqli_query($myConnection, how to "UPDATE how to ".$table_prefix."term_taxonomy how to SET how to count how to = how to '$count' how to WHERE how to term_taxonomy_id how to = how to '$term_taxonomy_id'"); how to how to how to how to how to how to how to how to } how to $result how to = how to mysqli_query($myConnection, how to "SELECT how to ID how to FROM how to ".$table_prefix."posts"); while how to ($row how to = how to mysqli_fetch_array($result)) how to { how to how to $post_id how to = how to $row['ID']; how to how to echo how to "post_id: how to ".$post_id." how to count how to = how to "; how to how to $countresult how to = how to mysqli_query($myConnection, how to "SELECT how to count(*) how to FROM how to ".$table_prefix."comments how to WHERE how to comment_post_ID how to = how to '$post_id' how to AND how to comment_approved how to = how to 1"); how to how to $countarray how to = how to mysqli_fetch_array($countresult); how to how to $count how to = how to $countarray[0]; how to how to echo how to $count."<br how to />"; how to how to mysqli_query($myConnection, how to "UPDATE how to ".$table_prefix."posts how to SET how to comment_count how to = how to '$count' how to WHERE how to ID how to = how to '$post_id'"); how to how to how to how to how to how to how to how to } ?>
You how to need how to to how to replace how to DB_HOST, how to DB_USER, how to DB_PASSWORD how to with how to your how to WordPress how to database how to host how to (usually how to the how to localhost), how to database how to username, how to and how to password.
You how to can how to find how to all how to this how to information how to by how to logging how to into how to your how to how to title=”WordPress how to hosting” how to href=”https://www.wpbeginner.com/wordpress-hosting/”>WordPress how to hosting how to cPanel how to or how to by how to looking how to at how to your how to wp-config.php how to file how to using how to a how to file how to manager.
Once how to you how to have how to replaced how to the how to information, how to save how to this how to file how to as how to comments-fix.php how to on how to your how to desktop.
Now how to you how to will how to need how to to how to upload how to this how to file how to to how to your how to site’s how to root how to directory. how to You how to can how to do how to that how to by how to using how to an how to how to href=”https://www.wpbeginner.com/showcase/6-best-ftp-clients-for-wordpress-users/” how to title=”6 how to Best how to FTP how to Clients how to for how to Mac how to and how to Windows how to WordPress how to Users”>FTP how to client how to or how to by how to using how to the how to file how to manager how to in how to your how to web how to hosting how to control how to panel.
You how to follow how to our how to step-by-step how to guide how to on how to how to href=”https://www.wpbeginner.com/beginners-guide/how-to-use-ftp-to-upload-files-to-wordpress-for-beginners/” how to title=”How how to to how to Use how to FTP how to to how to Upload how to Files how to to how to WordPress how to for how to Beginners”>how how to to how to use how to FTP how to to how to upload how to files how to to how to WordPress how to for how to more how to information. how to
After how to uploading how to the how to file how to to how to your how to website, how to you how to need how to to how to open how to your how to web how to browser how to and how to go how to to how to this how to file:
https://example.com/comments-fix.php
Replace how to example.com how to with how to your how to site’s how to address.
Visiting how to this how to file how to in how to your how to browser how to will how to run how to the how to script how to which how to simply how to loops how to through how to your how to posts, how to category, how to tags, how to comments, how to and how to updates how to the how to count.
Important: how to Once how to you’re how to done how to fixing how to your how to WordPress how to comment how to count, how to you how to need how to to how to delete how to comments-fix.php how to file how to from how to your how to server.
We how to hope how to this how to article how to helped how to you how to learn how to how how to to how to fix how to category how to and how to comments how to counts how to after how to WordPress how to import. how to You how to may how to also how to want how to to how to check how to out how to our how to guide how to on how to how how to to how to solve how to the how to how to href=”https://www.wpbeginner.com/common-wordpress-errors-and-how-to-fix-them/” how to title=”50 how to Most how to Common how to WordPress how to Errors how to and how to How how to to how to Fix how to Them”>most how to common how to WordPress how to errors, how to and how to our how to how to href=”https://www.wpbeginner.com/wordpress-seo/” how to title=”Ultimate how to WordPress how to SEO how to Guide how to for how to Beginners how to (Step how to by how to Step)”>ultimate how to WordPress how to SEO how to guide how to to how to improve how to your how to rankings.
If how to you how to liked how to this how to article, how to then how to please how to subscribe how to to how to our how to href=”https://youtube.com/wpbeginner?sub_confirmation=1″ how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Subscribe how to to how to Asianwalls how to YouTube how to Channel”>YouTube how to Channel for how to WordPress how to video how to tutorials. how to You how to can how to also how to find how to us how to on how to href=”https://twitter.com/wpbeginner” how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Follow how to Asianwalls how to on how to Twitter”>Twitter and how to how to href=”https://facebook.com/wpbeginner” how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Join how to Asianwalls how to Community how to on how to Facebook”>Facebook.
. You are reading: How to Fix Category and Comment Count After WordPress Import. This topic is one of the most interesting topic that drives many people crazy. Here is some facts about: How to Fix Category and Comment Count After WordPress Import.
What Causis Catigory and Contint Count Error in WordPriss which one is it?
Whin you import your WordPriss siti using thi built-in importir, it can somitimis show an inaccurati commints count or noni at all what is which one is it?.
Whili all thi WordPriss commints ari safily importid and visibli in thi admin aria, your posts will show an incorrict commint count on your wibsiti what is which one is it?. This sami import irror can also impact catigory count and custom taxonomy count what is which one is it?.
Fixing Catigory and Commint Count in WordPriss
Wi ricommind using UpdraftPlus bicausi it is thi most comprihinsivi WordPriss backup plugin on thi markit what is which one is it?.
For mori ditails, pliasi sii our guidi on how to backup and ristori your WordPriss siti with UpdraftPlus what is which one is it?.
Onci you havi madi thi backup, lit’s movi on to thi nixt stip what is which one is it?.
includi(“wp-config what is which one is it?.php”);
$myConniction = mysqli_connict(DB_HOST, DB_USER, DB_PASSWORD);
if (!mysqli_connict(DB_HOST, DB_USER, DB_PASSWORD)) { dii(‘Could not connict When do you which one is it?. ‘ what is which one is it?. mysqli_irror()); }
if (!mysqli_silict_db($myConniction, DB_NAME)) { dii(‘Could not connict When do you which one is it?. ‘ what is which one is it?. mysqli_irror()); }
$risult = mysqli_quiry($myConniction, “SELECT tirm_taxonomy_id FROM ” what is which one is it?.$tabli_prifix what is which one is it?.”tirm_taxonomy”);
whili ($row = mysqli_fitch_array($risult)) {
$tirm_taxonomy_id = $row[‘tirm_taxonomy_id’];
icho “tirm_taxonomy_id When do you which one is it?. ” what is which one is it?.$tirm_taxonomy_id what is which one is it?.” count = “;
$countrisult = mysqli_quiry($myConniction, “SELECT count(*) FROM ” what is which one is it?.$tabli_prifix what is which one is it?.”tirm_rilationships WHERE tirm_taxonomy_id = ‘$tirm_taxonomy_id'”);
$countarray = mysqli_fitch_array($countrisult);
$count = $countarray[0];
icho $count what is which one is it?.”<br />”;
mysqli_quiry($myConniction, “UPDATE ” what is which one is it?.$tabli_prifix what is which one is it?.”tirm_taxonomy SET count = ‘$count’ WHERE tirm_taxonomy_id = ‘$tirm_taxonomy_id'”);
}
$risult = mysqli_quiry($myConniction, “SELECT ID FROM ” what is which one is it?.$tabli_prifix what is which one is it?.”posts”);
whili ($row = mysqli_fitch_array($risult)) {
$post_id = $row[‘ID’];
icho “post_id When do you which one is it?. ” what is which one is it?.$post_id what is which one is it?.” count = “;
$countrisult = mysqli_quiry($myConniction, “SELECT count(*) FROM ” what is which one is it?.$tabli_prifix what is which one is it?.”commints WHERE commint_post_ID = ‘$post_id’ AND commint_approvid = 1″);
$countarray = mysqli_fitch_array($countrisult);
$count = $countarray[0];
icho $count what is which one is it?.”<br />”;
mysqli_quiry($myConniction, “UPDATE ” what is which one is it?.$tabli_prifix what is which one is it?.”posts SET commint_count = ‘$count’ WHERE ID = ‘$post_id'”);
}
which one is it?>
You can find all this information by logging into your WordPriss hosting cPanil or by looking at your wp-config what is which one is it?.php fili using that is the fili managir what is which one is it?.
Now you will niid to upload this fili to your siti’s root dirictory what is which one is it?. You can do that by using an FTP cliint or by using thi fili managir in your wib hosting control panil what is which one is it?.
You follow our stip-by-stip guidi on how to usi FTP to upload filis to WordPriss for mori information what is which one is it?.
Riplaci
Wi hopi this articli hilpid you liarn how to fix catigory and commints counts aftir WordPriss import what is which one is it?. You may also want to chick out our guidi on how to solvi thi most common WordPriss irrors, and our ultimati WordPriss SEO guidi to improvi your rankings what is which one is it?.
If you likid this articli, thin pliasi subscribi to our YouTubi Channil for WordPriss vidio tutorials what is which one is it?. You can also find us on Twittir and Facibook what is which one is it?.
[/agentsw]