WP 2.5 upgrade. Comments are not visible

  • I upgraded to WP 2.5 yesterday. There were minor hiccups, but things seem to have mostly proceeded without hitch.

    However, there seems to be an issue with comments. When I get an email to approve a comment and access it from the links there I can see them, and they show up both on the dashboard and in the context of a post, but not from the comment tab in the admin interface. Any ideas? I tried disabling the sezwho plugin, but that didn’t seem to have an impact.

Viewing 13 replies - 1 through 13 (of 13 total)

  • i have the same problem!

    Same problem here too. I don’t have any plugins installed that would affect comments’ display under the Comments tab. Just FeedBurner, reCAPTCHA, and Title Tag.

    Can anyone help?!

    Thread Starter mndoci

    (@mndoci)

    anyone?

    It appears that someone solved it by re-importing their comments as XML. But I can’t seem to find a way to export them to XML in the first place. Anyone have any ideas?

    Use the export option of WordPress.

    Thread Starter mndoci

    (@mndoci)

    Export exports everything. What are the risks of re-importing that?

    There’re difference in the wp_comments table database structure. comment_ID as primary key, and four index key. They’re comment_approved (comment_approved field), comment_post_ID (comment_post_ID field), comment_approved_date_gmt (comment_approved and comment_date_gmt fields), and comment_date_gmt (comment_date_gmt field).

    If you don’t set the comment_date_gmt field as index then the comments don’t appear on comment tab of admin panel.

    Thanks Wibz

    It worked!!!!

    Any example SQL-Commands on how to fix that (if any)? Maybe oreixa you can tell what you did (the “It” of “It worked!!!!”). Would be nice to have this documented. Maybe this is a Bug in the upgrade script.

    Access to your Mysql database and execute:

    create index comment_date_gmt on wp_comments(comment_date_gmt);

    it will create the index and the comments will appear.

    remember to backup the database first.

    Wibz & oreixa —

    Thanks SO much! I was getting real frustrated as my wp_comments table crashed. After dropping and rebuilding it (as well as repopulating the table – thanks to a timely backup), I was still wondering why the damn comments weren’t appearing on the Admin tab. You fixed me!

    Thread Starter mndoci

    (@mndoci)

    Worked for me too. Thanks a ton

    Just to get this complete. mndoci can you tell from which version you upgraded? And can you mark this thread as resolved, that would be nice!

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘WP 2.5 upgrade. Comments are not visible’ is closed to new replies.