• 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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error on upgrade to 2.6’ is closed to new replies.