Hello. I am not sure how or why it happened, but when I go to my admin page, the red comment counter in the left-hand sidebar states that there is one comment waiting to be approved. However, when I click on the Comments link and am taken to the comments page, it states that no comments were found. I am assuming that this means that something got messed up somewhere in one of WP's database tables.
Can someone please point me to the precise table and location where I can fix this in my mySQL client?
Thanks so much.