while running update.php after updating to beta5 I get the error 

The following queries were executed
image_attach module
Update #6102

    * ALTER TABLE {image_attach} DROP PRIMARY KEY
    * ALTER TABLE {image_attach} ADD PRIMARY KEY (nid, iid)
    * Failed: ALTER TABLE {image_attach} ADD `weight` INT NOT NULL DEFAULT 0

Update #6103

    * DELETE FROM {image_attach} WHERE iid = 0

Can anybody help me with getting rid of the error (I'm not an SQL expert)? My database is mysql 5.0.51b. It would be best if phpmyadmin could be used to solve the problem.

In the table image_attach there is a field weight. The error must be in the rest of the ALTER TABLE command.

Comments

joachim’s picture

joachim commented
Status: Active » Postponed (maintainer needs more info)

Have you checked the troubleshooting FAQ?

FrankT’s picture

FrankT commented
Status: Postponed (maintainer needs more info) » Fixed

I have to admit I did not read the FAQ but searched for similar issues but the faq didn't show. I will ignore this behaviour.

joachim’s picture

joachim commented

> * Failed: ALTER TABLE {image_attach} ADD `weight` INT NOT NULL DEFAULT 0

Well do you have a weight column now or not?

FrankT’s picture

FrankT commented

Yes, I have a weight column.

Status: Fixed » Closed (fixed)

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