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.”

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.
Posts of Interest
Most of the family is probably here for Ari and Sidd udpates.
Other top posts:
For those getting spam from BrianAThomas.com, it has been faked, some details in I am Not a Spammer.
Political posts have been removed from the front page, but can be reached via that link. Meanwhile enjoy the site.Now Reading
Planned books:
- The Dark River (Fourth Realm Trilogy, Book 2) by John Twelve Hawks
- A Rulebook for Arguments by Anthony Weston
- Feed (Newsflesh, Book 1) by Mira Grant
Current books:
Recent books:
- Consider Phlebas by Iain M. Banks
- Dune, 40th Anniversary Edition (Dune Chronicles, Book 1) by Frank Herbert
- The Copywriter’s Handbook, Third Edition: A Step-By-Step Guide To Writing Copy That Sells by Robert W. Bly
- The Traveler (Fourth Realm Trilogy, Book 1) by John Twelve Hawks
- Jonathan Strange by Susanna Clarke
My Amazon Wishlist
Brian's WishlistBrian's Boardgame List
Ari's Wishlist
Sidd's Wishlist
Critical Thinking List
Sara's Wishlist
Not a Wishlist, but stuff for you to get stuff at Amazon for yourself.



I never thought i will find this much information on Odd Comment Error With WordPress 2.5.1 today. Nice post mate – keep up the good work.