[wp-testers] Re: [wp-hackers] Beware Trunk

[Ryan Boren]

On 5/24/07, spencerp <spencerp1 at gmail.com> wrote:

> Okay. I did the table drop for table: term_relationships, then bumped DB
> Version in version.php file. Went to localhost/wp-admin/upgrade.php
>
> Clicked next button or whatever.. then got these two:
>
> WordPress database error: [Multiple primary key defined]
> ALTER TABLE wp02_term_relationships ADD PRIMARY KEY (object_id,
> term_taxonomy_id)
>
> WordPress database error: [Multiple primary key defined]
> ALTER TABLE wp02_term_taxonomy ADD PRIMARY KEY (term_taxonomy_id)
>
> Upgrade Complete
>
> Hmmm..



Every time you upgrade you'll get duplicate keys inserted.  Everything
should still work though.  dbDelta() needs to be fixed to avoid this.

You can delete the dupes with phpymyadmin or the like.

Ryan