I just noticed an error with WordPress 2.5.1, which I recently upgraded to.
It says I have 4 comments waiting for approval, but when I go to the screen to approve them it says there are “No comments awaiting moderation… yet.”
Comment Error for WordPress 2.5.1
I have searched Google, I found one suggestion to make sure the comment_date_gmt field is in the wp_comments table, which it is. I turned off Brian’s Threaded Comments to see if it was a conflict with that, no luck, so it isn’t that plugin, which aside from Akismet, is the only comment related plugin I use (I turned that off as well, and no luck either).
I have now tried plugins and problems with the database structure, but no closer to a fix. Anyhow, if you leave a comment, it may be stuck in the que until a fix is found.
EDIT: Forgot to add, it shows there are no comments found if I look in the “All Comments” and the “Approved Comments” sections of the Comments tab as well. Yet, if I check a post with comments, they are there.
EDIT 2: Obviously until there is a solution, I won’t see any comments at all, so if somebody has a solution the result will have to be emailed to r underscore flagg 10 at hotmail.
EDIT 3: The problem is there even with IE, so not a Firefox bug…
EDIT 4: Fixed.
For those having the same issue. First backup your database. Then logon to your cPanel, get to the phpmyadmin screen. Check the index option on the comment_date_gmt field in the wp_comments table.