WordPress.org

Make WordPress Core

Opened 10 years ago

Closed 10 years ago

#7664 closed defect (bug) (fixed)

All Comments Missing After 2.6.1 Upgrade

Reported by: lindalmuller Owned by:
Milestone: 2.7 Priority: high
Severity: critical Version: 2.6.1
Component: Administration Keywords: comments, categories, php myadmin
Focuses: Cc:

Description

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?

Change History (9)

#1 @lindalmuller
10 years ago

  • Component changed from General to Administration
  • Summary changed from All Comments Missing After 2.6 Upgrade to All Comments Missing After 2.6.1 Upgrade

#2 @ryan
10 years ago

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?

#3 @lindalmuller
10 years ago

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

#4 @lindalmuller
10 years ago

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.

#5 @lindalmuller
10 years ago

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?

#6 @ryan
10 years ago

(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

#7 @ryan
10 years ago

(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

#8 @ryan
10 years ago

  • Milestone changed from 2.8 to 2.6.2

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

#9 @ryan
10 years ago

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.