Posted 1 month 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.
Posted 1 month ago #
i have the same problem!
Posted 1 month 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?!
Posted 1 month ago #
anyone?
Posted 1 month 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?
Posted 1 month ago #
Use the export option of Wordpress.
Posted 1 month ago #
Export exports everything. What are the risks of re-importing that?
Posted 1 month 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.
Posted 1 month ago #
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.
Posted 1 month 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.
Posted 1 month 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!
Posted 1 month ago #
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!
You must log in to post.
