coffeebranlaxative

Wordpress MU Upgrade Comments Not Showing Up/Being Listed In Admin Interface

After recently upgrading my Wordpress MU 1.0 install to 2.6 I ran into some fun database problems.  In this post I will be addressing the “comment problem”.  So, here’s what happened.

I noticed the problem when I had a comment waiting to be moderated.  The admin interface was showing that there was a comment waiting to be moderated but when I went to moderate it the interface reported zero comments.  Turns out this was because of a discrepency between my really old database layout and the new layout.  Mainly, an index (comment_date_gmt) on the comment_date_gmt field of the comments table.  I also noticed there was an index (comment_approved_date_gmt) on the comment_date_gmt and comment_approved fields.  So, adding the indices fixed the problem.

Here is the link to the Wordpress Database Description: http://codex.wordpress.org/Database_Description

Here is the link to the specific indices you should have: http://codex.wordpress.org/Database_Description#Indexes