WordPress.org

Ready to get started?Download WordPress

Forums

Database error on upgrade to 2.6 (3 posts)

  1. obiscoito
    Member
    Posted 6 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?

  2. Anonymous
    Unregistered
    Posted 6 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.

  3. dtek
    Member
    Posted 6 years ago #

    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.)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags