2124 pointsLike some sort of WPMU DEV God"Mindblowingly helpful memberLifetime member
Ovidiu
Member
—
25th May 2009 (3 years ago)
2 weeks ago I migrated to a new server and everythign seemed to go smoothly. Now I noticed that when I click i.e. onto a comments table, i.e. wp_1_comments I get the following warning using phpmyadmin:
More than one INDEX key was created for column "comment_approved"
these are the existing indexes:
Indexes:
Documentation Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop comment_ID
comment_approved INDEX None Edit Drop comment_approved
comment_post_ID INDEX None Edit Drop comment_post_ID
comment_approved_date_gmt INDEX None Edit Drop comment_approved
comment_date_gmt
comment_date_gmt INDEX None Edit Drop comment_date_gmt
the problem is that all blogs I create from now on, have this problem :-( any hints?
2 weeks ago I migrated to a new server and everythign seemed to go smoothly. Now I noticed that when I click i.e. onto a comments table, i.e. wp_1_comments I get the following warning using phpmyadmin:
More than one INDEX key was created for column "comment_approved"
these are the existing indexes:
Indexes:
Documentation Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop comment_ID
comment_approved INDEX None Edit Drop comment_approved
comment_post_ID INDEX None Edit Drop comment_post_ID
comment_approved_date_gmt INDEX None Edit Drop comment_approved
comment_date_gmt
comment_date_gmt INDEX None Edit Drop comment_date_gmt
the problem is that all blogs I create from now on, have this problem :-( any hints?
There are two indexes on comment_approved (on my local install anyway), but one is part of an aggregate index with comment_date_gmt so I wonder if it's picking this up and reporting it?
Responses (3)
Member — 25th May 2009 (3 years ago) #
just found the standard wordpress DB schema: http://codex.wordpress.org/Database_Description#Table:_wp_comments and the wpmu one (partially) http://codex.wordpress.org/WPMU_Database_Description
does this now mean there is no problem? is it a false warning by phpmyadmin?
and btw. excuse me for posting here and in the regular mu forums, but not everyone reads/posts in both...
Founder & CEO — 25th May 2009 (2 years ago) #
No probs at all - have gotta say that I'm not that whole heap of useful when it comes to phpmyadmin though :/
Developer — 25th May 2009 (2 years ago) #
There are two indexes on comment_approved (on my local install anyway), but one is part of an aggregate index with comment_date_gmt so I wonder if it's picking this up and reporting it?
Shouldn't be a problem though.
Become a member