PDA

View Full Version : Upgrade error -> MySQL Error : Duplicate entry '0' for key 1


Hawstly
Fri 6th Apr '07, 1:29pm
ok, I am moving to a new host and thought while the site was down why not upgrade to the latest 3.6x version.

So, I move to a new host and have them import my database into a new server and I then load up the upgrade.php file.

I get through a couple of steps and the I get this error.

Can anyone advise?

Thanks in advance,

Database error in vBulletin 3.5.5:
Invalid SQL:
INSERT INTO upgradelog(script, steptitle, step, startat, perpage, dateline)
VALUES ('upgrade_360b1.php', 'Large table alterations (1/2)', 1, 0, 0, 1175875846);
MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, April 6th 2007 @ 09:10:46 AM
Script : xxx/install/upgrade_360b1.php?step=1 (http://www.bpteck.com/tahoeforum/install/upgrade_360b1.php?step=1)
Referrer :
IP Address : x.x.x.x
Username :
Classname : vb_database

Steve Machol
Fri 6th Apr '07, 1:35pm
See this page for a solution to the 'duplicate key' error:

http://www.vbulletin.com/docs/html/mysql_duplicatekey

Hawstly
Fri 6th Apr '07, 1:57pm
Excellent! thank you very much. I will give this a try when I have some time this evening.