Sometimes, due to errors with your mysql database, when you goto wordpress admin and look into “comments” section of your wordpress backend, you’re welcomed with a message saying:
No Comments found.
Well, it happened with me too, more than once.
I was pretty much sure that the comments do exist and the content is there, there is some issue with database.
How to fix wordpress “no comments found” error
Fixing this error is simple. We simply need to “repair” our blogs mysql database.
This can be done by either going to cpanel > phpmyadmin > select your database > select all tables > repair
Or can also be achieved by using various plugins directly from your wordpress admin.
Tip: I used wp-dbmanager for this , and after repair also optimize your database, make it your habit to do it once in a while.
thanks.. i faced the same problem. followed your instructions and it solved the issue. in my case i could see comments in pending comments section but not in spam and approved comments section…
did you backup your database earlier?
Also make a backup of your current WordPress database first
Then try repairing and optimizing the tables again