hey there,

I upgraded from 6.x-1.0-alpha4 to 6.x-1.0-DEV and got the following messages: 

user warning: Can't DROP 'PRIMARY'; check that column/key exists query: ALTER TABLE image DROP PRIMARY KEY in /home/luco/public_html/drupal/includes/database.mysql-common.inc on line 386.
user warning: Can't DROP 'image_fid'; check that column/key exists query: ALTER TABLE image DROP INDEX image_fid in /home/luco/public_html/drupal/includes/database.mysql-common.inc on line 448.

it's not a fresh install, but definitively not one with many modules. running D6.12. I can provide more info if you folks need.

cheers,
Luciano

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Title: can't drop tables at database upgrade » Can't DROP primary key/index in database update
Category: bug » support
Status: Active » Fixed

Better title. Previous one shocked me a bit.

You can safely ignore this error. As of now, we cannot prevent it from happening, because Drupal core does not provide methods to get defined primary key and indexes of a database table.

joachim’s picture

joachim commented

Should we add something to the docs about this?

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

We should probably add a note on the project page when we publish the next release (alpha? beta? rc? first stable?)

luco’s picture

luco commented

LOL sorry for the defcon-like alarm. show and tell FAIL.

anyway, thanks for the support. I've already ignored the error, since I run Demonstration Site anyway ;]

Status: Fixed » Closed (fixed)

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

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Closed (fixed) » Fixed

Re-marking as fixed again to hopefully prevent some duplicates.

Status: Fixed » Closed (fixed)

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

Hetta’s picture

Hetta commented

marked http://drupal.org/node/559564 as duplicate.