[resolved] Awaiting moderation keeps on 18 comments

I had the same problem as you and I found the fix: somehow the updater failed to create an index in the comment_date_gmt column of the wp_comments table. Go to your preferred MySQL interface (like phpMyAdmin) and add an index to that column, reload your comment management page, and you’re done. Cheers!
by akosma

1. wp_commentsテーブルを選択
2.Indexesのリストの下の方にあるCreate Indexボタンをおす。
3. comment_date_gmtフィールドに対してIndexを作る。

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s