Hi all,
I got this error while updating
* ALTER TABLE {image} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0
* ALTER TABLE {image} CHANGE fid `fid` INT unsigned NOT NULL DEFAULT 0
* Failed: ALTER TABLE {image} DROP PRIMARY KEY
* ALTER TABLE {image} ADD PRIMARY KEY (nid, image_size)
* Failed: ALTER TABLE {image} DROP INDEX image_fid
* ALTER TABLE {image} ADD INDEX fid (fid)
Note: I have updated this module just after process the update of drupal core from 6.12 to 6.13
Comments
Comment #1
Gord_Mason commentedI have the same problem as above. My site had been in good shape. I noticed a similar post from a while ago where the poster was told to ignore the problem. Is that the same here?
Gord
Comment #2
Gord_Mason commentedSorry, should have made sure the title pointed out that it was the image.module.
Comment #3
cookiesunshinex commentedI just received the same errors when upgrading from alpha4 to alpha5.
Comment #4
Gord_Mason commentedOK, I've checked my database. All seems well, and the website seems to work well. Are these error messages just a red herring? I'd like to know soon so I can proceed with my website development with more confidence that I am not making changes that will need to be rolled back.
Comment #5
AdrianB commentedTake a look at what sun says here: http://drupal.org/node/479964
Comment #6
sun@AdrianB: Thanks! :)
Marking as duplicate of #479964: Can't DROP primary key/index in database update.
Comment #7
libre fan commentedThanks for the link,
Generally speaking;
Should we disable the image module before updating to latest version?
Should we delete all the image dir or simply overwrite?