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.