Current time: 10-05-2022, 06:37 PM Hello There, Guest! (LoginRegister)


Post Reply 
RC2c to RC3 Database update fail primary key
Author Message
achioo Offline
Junior Member
*

Posts: 76
Joined: Nov 2006
Reputation: 0
Post: #1
RC2c to RC3 Database update fail primary key
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.
(This post was last modified: 02-21-2008 10:49 AM by achioo.)
02-21-2008 10:48 AM
Find all posts by this user Quote this message in a reply
juerg Offline
Junior Member
*

Posts: 95
Joined: Aug 2007
Reputation: 0
Post: #2
RE: RC2c to RC3 Database update fail primary key
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
(This post was last modified: 02-21-2008 05:56 PM by juerg.)
02-21-2008 05:54 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #3
RE: RC2c to RC3 Database update fail primary key
or add an "IGNORE" on the right places in the sql statements...

in general - use the search function of the forum
02-21-2008 07:21 PM
Visit this user's website Find all posts by this user Quote this message in a reply
achioo Offline
Junior Member
*

Posts: 76
Joined: Nov 2006
Reputation: 0
Post: #4
RE: RC2c to RC3 Database update fail primary key
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.
02-22-2008 02:49 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #5
RE: RC2c to RC3 Database update fail primary key
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...
02-22-2008 02:55 AM
Visit this user's website Find all posts by this user Quote this message in a reply
achioo Offline
Junior Member
*

Posts: 76
Joined: Nov 2006
Reputation: 0
Post: #6
RE: RC2c to RC3 Database update fail primary key
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.
02-22-2008 03:03 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)