Comments not showing in dashboard?

  • Hi all,

    I recently upgraded to WordPress 2.5 (from 2.3).
    Right now, there is no way for me to view the comments people made:

    Dashboard Screenshot

    This is a stock WP install, no modifications were made to any file.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter teckinno

    (@teckinno)

    The only way I managed to solve the issue is:
    Go to Manage > Posts and you will see there the blue’ed Comments icon, for each post that contains comments in moderation queue. Once you click on the Comment icon, you will be able to see the moderated comments.

    However, this is not a solution.
    I will upgrade to WP 2.5.1 and see if the problem was solved.

    Hi,

    I just had the same problem when upgrading from 2.3.3 to 2.5.1. It was because of this bit of SQL:

    SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments USE INDEX (comment_date_gmt)...

    The comment_date_gmt index wasn’t present in my database(s) because the WordPress user didn’t have the ALTER privilege. Some other schema changes had also silently failed.

    Cheers,
    Ian

    Thread Starter teckinno

    (@teckinno)

    Thanks for the info. I upgraded to 2.5.1 and I have even more problem. Now, I cannot see at all the comments. How do I create the index?

    I just ran a query:
    SELECT * FROM comments

    This is the error I get:
    1030 – Got error 127 from storage engine

    Thread Starter teckinno

    (@teckinno)

    Never mind, I ran a repair/optimize on comment table and it fixed the problem.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Comments not showing in dashboard?’ is closed to new replies.