WordPress.org

Ready to get started?Download WordPress

Forums

WP 2.5 upgrade. Comments are not visible (14 posts)

  1. mndoci
    Member
    Posted 6 years ago #

    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.

  2. henkmsncam
    Member
    Posted 6 years ago #

    i have the same problem!

  3. clearcrystalmedia
    Member
    Posted 6 years ago #

    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?!

  4. mndoci
    Member
    Posted 6 years ago #

    anyone?

  5. clearcrystalmedia
    Member
    Posted 6 years ago #

    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?

  6. oreixa
    Member
    Posted 6 years ago #

    Use the export option of WordPress.

  7. mndoci
    Member
    Posted 6 years ago #

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

  8. Wibz
    Member
    Posted 6 years ago #

    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.

  9. oreixa
    Member
    Posted 6 years ago #

    Thanks Wibz

    It worked!!!!

  10. hakre
    Member
    Posted 6 years ago #

    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.

  11. oreixa
    Member
    Posted 6 years ago #

    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.

  12. bjciii
    Member
    Posted 6 years ago #

    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!

  13. mndoci
    Member
    Posted 6 years ago #

    Worked for me too. Thanks a ton

  14. hakre
    Member
    Posted 6 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic