[wp-trac] [WordPress Trac] #7664: All Comments Missing After 2.6 Upgrade

[WordPress Trac]

#7664: All Comments Missing After 2.6 Upgrade
--------------------------+-------------------------------------------------
 Reporter:  lindalmuller  |       Owner:  anonymous                        
     Type:  defect        |      Status:  new                              
 Priority:  high          |   Milestone:  2.8                              
Component:  General       |     Version:  2.6.1                            
 Severity:  critical      |    Keywords:  comments, categories, php myadmin
--------------------------+-------------------------------------------------
 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?

-- 
Ticket URL: <http://trac.wordpress.org/ticket/7664>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software