Hi,
I just upgraded from Alpha 6 to Beta 1 and got the following errors during the db update:
The following queries were executed
image_attach module
Update #6100
ALTER TABLE {image_attach} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0
ALTER TABLE {image_attach} CHANGE iid `iid` INT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {image_attach} DROP PRIMARY KEY
ALTER TABLE {image_attach} ADD PRIMARY KEY (nid)
Failed: ALTER TABLE {image_attach} DROP INDEX iid
ALTER TABLE {image_attach} ADD INDEX iid (iid)
Update #6101
DELETE FROM {blocks} WHERE module = 'image_attach' AND delta = 0
Update #6102
ALTER TABLE {image_attach} DROP PRIMARY KEY
ALTER TABLE {image_attach} ADD PRIMARY KEY (nid, iid)
ALTER TABLE {image_attach} ADD `weight` INT NOT NULL DEFAULT 0
image_gallery module
Update #6100
No queries
image module
Update #6100
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)
Update #6101
No queries
Update #6102
No queries
Update #6103
No queries
Any help would be appreciated. Thanks-
Comments
Comment #1
David Stosik CreditAttribution: David Stosik commentedWe can't avoid these two errors, but the update went well anyway.
See #562810: update problem from alpha4 to alpha6 (update 6100) : we need to remove then to add primary key and index for tables image and image_attach. But there may be the possibility that the key doesn't exist on your schema, depending on the upgrade path you took. Thus, db_drop_primary_key() and db_drop_index() may report a warning. They are prefixed by '@' to avoid the PHP warning, but the DB update log will show the fail.
As there's no easy way to check if the index and primary keys exist before removing them, we'll only put a note on INSTALL.TXT to tell that's not a problem.
Comment #2
joachim CreditAttribution: joachim commentedWe'll mention this in the release notes.
Comment #3
superflyman CreditAttribution: superflyman commentedThanks for the quick response. I'm glad it's nothing to worry about... An inclusion in the release notes sounds great.
Comment #4
joachim CreditAttribution: joachim commentedI've added an output message that appears along the executed queries list when you update, just to say it's harmless :)