obiscoito
Member
Posted 3 years ago #
WordPress database error: [Duplicate key name 'comment_approved']
ALTER TABLE wp_comments ADD KEY comment_approved (comment_approved)
WordPress database error: [Duplicate key name 'type_status_date']
ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID)
is what it said after I clicked the upgrade database button...thoughts?
Anonymous
Unregistered
Posted 3 years ago #
i got a similar error
i thought it prevented me from logging in to the admin pages, but it seems ok now
WordPress database error Duplicate key name 'comment_approved' for query ALTER TABLE pp_comments ADD KEY comment_approved (comment_approved) made by dbdelta WordPress database error Duplicate key name 'type_status_date' for query ALTER TABLE pp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID) made by dbdelta
i did back up before upgrading. so fingers crossed nothing too drastic.
fyi, we're discussing this issue in topic 172244, too.
(the original post there was made after a 2.5.1 upgrade, but i'm seeing the same error after the 2.6 upgrade.)