Unable to view or moderate comments

  • Resolved jzgpe

    (@jzgpe)


    16 years, 7 months ago

    Recently upgraded to WP 2.5 and on the comments administration screen, I can neither see existing comments or moderate pending comments. There is a link that say “Awaiting Moderation (6)”, but when I click on the link, the space where the comments should show say “No comments awaiting moderation… yet.” It is the same for either “Detailed View” or “List View”. I know from email notification all 6 of these comments are SPAM so I tried clicking on the “Mark as Spam” button, but that had no effect.

    Any suggestion on where to begin looking for the issue? I’d rather not have to drill down into the code.

    Many thanks…

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter jzgpe

    (@jzgpe)

    Update…

    Tried disabling all plugins in case there was an issue there. No joy. Still cannot view existing or unmoderated comments.

    Thread Starter jzgpe

    (@jzgpe)

    Alright, I was forced to drill into the code.

    The problem was the _wp_get_comment_list function was failing (/wp-admin/includes/template.php) because no index had been created on the comments.comment_date_gmt field. Presumably, this should have happened on the upgrade to 2.5. No errors were reported during the upgrade, rather WP reported everything was successful. Once an index was created on this field, the function worked properly and I was able to properly administer comments.

    Could you explain how you created the index? Or, failing that, some other steps to fix this problem? Pretty please!

    Thanks!

    I just confirmed the missing index problem. You need to run this on your database:

    ALTER TABLE wp_comments ADD INDEX ( comment_date_gmt )

    Thanks guys. Adding the Index solved my problem too.

    Ok, so I need to do this…I guess. I think, maybe…BUT the last time I played in my database, well the whole thing crashed. Bang — blog gone — Yahoo had to reset the site. So, I am slightly anxious about doing this again. IS there some one who could walk me through this, like break it down for me Barny style> Someone I would like consider to be…oh akin to a God….

    Thanks,

    Mel
    https://mejones.net

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Unable to view or moderate comments’ is closed to new replies.