Without any Doubt, WordPress is a great Solution for Newbie bloggers. However, Occasionally, you will encounter errors & Problems. Don’t panic, it happens with everybody. As you are new to WordPress, you are prone to mistakes. With time you will gain expertise. In this Article, I am providing you a solution to a problem related to Pending Comments Visibility (Not showing) in WordPress.
Fixing Pending Comments Not Showing Problem in WordPress
As you know, All Comments on your WordPress Website Should be moderated first before they are publically visible. All Comments which are not yet approved are shown in the “Pending” Section. Recently, I encountered a mind-boggling problem related to Pending Comments Visibility in WordPress.
It Started after I migrated one of the client’s website to a new hosting. Everything seemed fine until my client informed me about a weird problem. He told me that there are pending comments on his website but clicking on “Pending” Shows “No Comments Found”. To check this out, I logged into his WordPress Dashboard and clicked on “Comments”. There I could clearly see that 87 comments are pending. I Clicked on “Pending” and there was not even a single comment there. I posted a test comment on the website and the number increased to 88 but still, Pending comments were not visible.
At this time, I had no idea what went wrong? Was it due to recent migration? or was it due to any plugin? I was totally confused. I asked my client if he had made any changes recently? He told me that he had touched nothing.
Here are a few things that I tried initially :
Disabled all the Plugins: I disabled all active plugins on the Website but the problem was still there. So, this clearly indicated that this issue has nothing to do with Plugins.
Database Optimization: I used “WP-Optimize” Plugin to optimize the Database but the problem still remained.
After the above-mentioned methods didn’t work, I desperately searched for a solution on Google. Then I came through an article that explained that this could be due to a misconfiguration in the “Comments” table of the Website’s Database. As you know, complete data like WordPress Posts, Comments, etc. are saved in the Database. So, I logged into the Cpanel and Opened up “phpmyadmin”.Then, I navigated to the “Comments” Table.
Whenever Somebody types in a comment on your website, every piece of information are saved in the database (specifically in the “comments” table). This table has columns like “Comment ID, Comment_Author, Comment_author_email, Comment_author_ip, Comment_Author_Date, Comment_Content etc.). In order to Commenting system work properly, it is made sure that Every Comment has a unique ID i.e. Comment_ID. This is ensured by applying Primary Key Constraint. Also, Comment_ID should use Auto_Increment Attribute.
When I looked into the table, I came to know that Auto_Increment attribute was not enabled. I tried to enable it but it gave an Error. So, I Did this:
In the “comment_id” column, I deleted all entries with value “0”. After this, I enabled the auto_increment attribute and it worked this time.
Note: Deleting the Entries with “0” Value in Comment_ID Section will delete all the comments in the “Pending” Section.
Now, to ensure that everything works fine now, I wrote a test comment. Then, I logged into the WordPress Admin Panel and Opened up the comments Section. I clicked on “Pending” & Voila!, I could see the Pending comments now.
I have been informed that in some cases, Even After Deleting the “0” values in the Comment_ID section, the auto-increment feature is not working. To Fix this, I advise you to run this query in the “SQL Command” section:
ALTER TABLE `Table_Name` ADD INDEX(`comment_ID`);
Once this is executed, enable the auto-increment feature.
Steps to Fix WordPress Comments Not Visible Problem
If the above-mentioned steps are still not clear, here is what you need to do :
✅Login into your Hosting Cpanel Account
✅Once Logged in, Go to “phpmyadmin” section
✅Then, click on your Database Name
✅Now, Locate Table called “Comments” ( This table name will usually precede with a prefix like “wp_”). In this case, the table name is “wp_comments”. Click on the table name
Click on the “Structure” Link
✅Now Click on “Change” Corresponding to “Comment_ID” Column Name
✅Check the “A_I” i.e. Autoincrement and click on save
Note: Also Ensure that Comment_ID is the Primary Key of the table. If you see a colored Key() corresponding to this column name, this means it is the primary key.
If you see an error while applying Auto_increment attribute on comment_id column, run this command first:
ALTER TABLE `Table_Name` ADD INDEX(`comment_ID`);
After this command is executed, you can retry.
I Hope that Pending Comments Not Visible issue is now resolved. I would love to know your feedback, suggestions. If you are still experiencing any problem, feel free to write down your concern below in the comments section.