WordPress.org

Make WordPress Core

Opened 4 years ago

Closed 4 years ago

#34210 closed defect (bug) (fixed)

Term Meta: Multiple primary key defined

Reported by: ocean90 Owned by: boonebgorges
Milestone: 4.4 Priority: normal
Severity: normal Version: 4.4
Component: Database Keywords:
Focuses: Cc:
PR Number:

Description

While working on #34209 I noticed the following error while upgrading the database:

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_termmeta ADD PRIMARY KEY (meta_id)

Change History (2)

#1 @ocean90
4 years ago

  • Owner set to boonebgorges
  • Status changed from new to reviewing

#2 @ocean90
4 years ago

  • Resolution set to fixed
  • Status changed from reviewing to closed

In 34936:

Term Meta: Prevent a "Multiple primary key defined" error during database upgrades.

You must have two spaces between the words PRIMARY KEY and the definition of your primary key. Yes, seriously.

See [34529].
Fixes #34210.

Note: See TracTickets for help on using tickets.