id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
7664	All Comments Missing After 2.6.1 Upgrade	lindalmuller	anonymous	"
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? 



"	defect (bug)	closed	high	2.7	Administration	2.6.1	critical	fixed	comments, categories, php myadmin