I get the following errors when updating from 6.x-2.0:

* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE feedback DROP PRIMARY KEY in /Users/john/Sites/journalfire/src/includes/database.mysql-common.inc on line 386.
* user warning: Multiple primary key defined query: ALTER TABLE feedback CHANGE `fid` `fid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (fid) in /Users/john/Sites/journalfire/src/includes/database.mysql-common.inc on line 520.

Below is the update.php report:

The following queries were executed
feedback module
Update #6100

* Failed: ALTER TABLE {feedback} DROP PRIMARY KEY
* Failed: ALTER TABLE {feedback} CHANGE `fid` `fid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (fid)

Update #6101

* ALTER TABLE {feedback} ADD `url` TEXT DEFAULT NULL
* ALTER TABLE {feedback} CHANGE `url` `url` TEXT NOT NULL
* UPDATE {feedback} SET url = location

Comments

xibun’s picture

xibun commented

same here

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Fixed

You can safely ignore this error.

There's no sane way to prevent it, because Drupal's database API in D6 does not allow to check for existing primary keys and indexes on a table. Therefore, the module update just tries to add it. In your case, the primary key already existed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.