RC2c to RC3 Database update fail primary key

[achioo]

Get the following error when running the update script.

Code:

Upgrading database structure...ERROR 1068 (42000) at line 54: Multiple primary key defined failed!

SQL Update failed.

[juerg]

achioo Wrote:Get the following error when running the update script.

Code:

Upgrading database structure...ERROR 1068 (42000) at line 54: Multiple primary key defined failed!

SQL Update failed.

Delete this line 54 in your update-file. (/var/www/ispcp/engine/setup/ispcp1.0.0rc2-ispcp.sql) Then update again. If you got another fail like this, delete again... and again...
It worked here :-)

juerg

[joximu]

or add an "IGNORE" on the right places in the sql statements...

in general - use the search function of the forum

[achioo]

joximu from reading what you said about "IGNORE" it appeared that it would only work with inserts... It wasn't an insert that was the issue but an alter. So I just amended the .sql file and added a -- before each line that broke it. Everything ran fine after that.

[joximu]

ok, sure. You're right. Ignore was for the inserts....

But you had a newer version than rc2c, right? otherwise the db update should have gone through without problems...

[achioo]

nope I had rc2c... I didn't/wouldn't upgrade to nightly... would be too painful... but in the end it worked so all is not lost.