WordPress.org
Get WordPress

Make WordPress Core

Opened 15 years ago

Closed 15 years ago

#13079 closed defect (bug) (invalid)

Database errors during 3.0b1 upgrade

Reported by: solarissmoke's profile solarissmoke Owned by: dd32's profile dd32
Milestone: Priority: normal
Severity: normal Version: 3.0
Component: Upgrade/Install Keywords:
Focuses: Cc:

Description

Hi,

I'm getting the following two database errors every time I upgrade my 3.0b install to the latest nightly:

WordPress database error Duplicate key name 'comment_approved' for query ALTER TABLE wp_comments ADD KEY comment_approved (comment_approved) made by wp_upgrade, make_db_current_silent, dbDelta
WordPress database error Duplicate key name 'type_status_date' for query ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID) made by wp_upgrade, make_db_current_silent, dbDelta

It seems like dbDelta is not detecting that these keys already exist in the table before trying to insert them...

Change History (1)

#1 @solarissmoke
15 years ago

  • Milestone 3.0 deleted
  • Resolution set to invalid
  • Status changed from new to closed

This problem seems to have magically disappeared during my last two upgrades. I'm going to close it for now.

Note: See TracTickets for help on using tickets.