All Comments Missing After 2.6.1 Upgrade

[lindalmuller]

I upgraded to 2.6 from 2.3+ using Fantastico.

After upgrade to 2.6 all my categories were missing. So I figured an upgrade to 2.6.1 would fix it. It didn't.

Then I found the fix here and it worked.
​http://blog.cumps.be/wordpress-26-upgrade-fix-missing-categories/

Now I find that Comments are missing as well.

I found this fix on WP Forum -- instructions from eexlebots:
​http://wordpress.org/support/topic/167450?replies=24

"...I had this same exact problem and jmfolcik's solutions worked for me; from phpmyadmin I selected the database, then selected the wp_comments table and viewed it in "Structure" mode.

Once there I selected the "comments_date_gmt" field and checked the "index" option. Once I did that and it reported a success I checked my Wordpress site and comments were back with no errors..."

I made those changes in PHP MyAdmin. Resulted in only having the latest comments [2] - the ones that were awaiting approval appear. All comments from years past were gone.

Went back to PHP MyAdmin and imported my backup.

Comments are still missing from posts. They show up in sidebar [Recent Comments] but when I click on them they do not appear on the posts.

They are not listed in the Admin/Comments section either.

Can anyone help with this problem?

[ryan]

The "Key 'comment_date_gmt' doesn't exist in table" error mentioned in that thread would explain why comments wouldn't show in the admin. That key is supposed to be added during upgrade, but evidently it doesn't get added for some. That error doesn't explain the other symptoms, however. Do you see any errors in the error log?

[lindalmuller]

Last check on the site, all comments previously listed in sidebar [Recent Comments] after importing my original DB are now missing [along with Admin/Comments].

I just loaded a sitemap plugin [Dagon Design Sitemap Generator v3.14]. It is configured to list the number of comments per post - and the numbers are there.

I'm downloading my error_log and it is gigantic so it will take a while

[lindalmuller]

OK -- All my old comments from years past are gone thanks to the upgrade to 2.6 and 2.6.1. I've given up hope of ever seeing them again.

But the problems with new comments [since the upgrade] are becoming a nightmare.

1 - Comments are not showing up in the admin.

2 - Comments needing approval are noted with the "red" numbers but when I click on it the comments are not there.

3 - I am forced to go into my database via PHPMyAdmin to directly edit in my approval.

Another big problem: My Dashboard is completely blank.

Please tell me how to solve this.

[lindalmuller]

All the problems listed above are still in force. There are many others on the forums who had the same or similar reaction after upgrades to 2.5-2.6.1

Losing all comments; categories, the dashboard, and the inability to approve/delete/edit new comments via admin are not insignificant issues.

Please tell me someone is working on this?

[ryan]

(In [8813]) Lose USE INDEX on comment_date_gmt. It didn't help performance very much and some people are missing the comment_date_gmt index. see #7664

[ryan]

(In [8814]) Lose USE INDEX on comment_date_gmt. It didn't help performance very much and some people are missing the comment_date_gmt index. see #7664 for 2.6

[ryan]

That fixes the case where the edit-comments.php query would fail if the index on comment_date_gmt wasn't created.

As for the other problems, I don't know. The 2.5 to 2.6.1 upgrade doesn't touch the comments table other than trying to add the comment_date_gmt index. No destructive operations are done.

You can send me a DB backup to look at. ryan at boren dot nu