Robsta Posted June 27, 2007 Share Posted June 27, 2007 Probably not a mainstream bug, but upgrading from beta1 to 2 I got an error... Error Message: 1062: Duplicate entry '1' for key 1 SQL: INSERT INTO `CubeCart_history` (`id` ,`version` ,`time`) VALUES ('1' , '4.0.0beta2', '1182935741'); Quote Link to comment Share on other sites More sharing options...
roban Posted June 27, 2007 Share Posted June 27, 2007 I get the same Quote Link to comment Share on other sites More sharing options...
vokf Posted June 27, 2007 Share Posted June 27, 2007 I'll look at this later, but this should be an SQL UPDATE - or an easy DELETE from CubeCart_history` WHERE id='1'; Jason Quote Link to comment Share on other sites More sharing options...
Guest webicon Posted June 27, 2007 Share Posted June 27, 2007 I had this - But fixed very simply - Went into database found the table 'CubeCart_history' refrenced and manually updated with the values shown in error message - works just fine now... Quote Link to comment Share on other sites More sharing options...
Guest markyvuk Posted June 27, 2007 Share Posted June 27, 2007 Being a bit thick today! Can someone advise the best way to upgrade from Beta 1 to Beta 2... Thanks Quote Link to comment Share on other sites More sharing options...
Robsta Posted June 27, 2007 Author Share Posted June 27, 2007 Being a bit thick today! Can someone advise the best way to upgrade from Beta 1 to Beta 2... ThanksIt's in the 'readme.txt' Upload, and run the setup > upgrade. Quote Link to comment Share on other sites More sharing options...
Guest rhyan Posted June 28, 2007 Share Posted June 28, 2007 I also came across this bug earlier today and I think the correct fix is changing the id value from 1 to AUTO_INCREMENT=1. This is on line 134 of setup/upgrade.php $db->misc("INSERT INTO `".$glob['dbprefix']."CubeCart_history` (`id` ,`version` ,`time`) VALUES ('AUTO_INCREMENT=1' , '".$thisVersion."', '".time()."');"); Changing that fixed it for me. Good luck! Quote Link to comment Share on other sites More sharing options...
Guest Posted June 29, 2007 Share Posted June 29, 2007 Yes I used the same fix as you rhyan - found it on the bug tracker :) Quote Link to comment Share on other sites More sharing options...
Robsta Posted June 29, 2007 Author Share Posted June 29, 2007 Yes I used the same fix as you rhyan - found it on the bug tracker As long as it's not a bug going between 4.0.0 to 4.0.1 when it happens.... the thoery is that noone will need to upgrade between betas or from betas, as betas are not a mainstream release. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.