Post by vibranthobbies » Thu Sep 16, 2021 3:47 am

When i try to upgrade i get the below error
Error Code(0): Error: Duplicate entry '2147483647' for key 'PRIMARY'
Error No: 1062
ALTER TABLE `oc_order` CHANGE `order_id` `order_id` INT(11) NOT NULL FIRST in /var/www/html/gamesunited/system/library/db/mysqli.php on line 48


Posts

Joined
Fri May 07, 2021 4:30 am

Post by straightlight » Thu Sep 16, 2021 5:20 am

Restore your backups. The order_id field is already a primary key and may require further troubleshooting to solve this issue. Best to install a fresh version of OC v3.0.3.8 release and integrate the data back into your database by using this free extension: https://www.opencart.com/index.php?rout ... sion_id=17 . Then, to focus on upgrading your extensions to the latest release.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by vibranthobbies » Thu Sep 16, 2021 11:35 am

Thank you,
Going for a fresh install.


Posts

Joined
Fri May 07, 2021 4:30 am
Who is online

Users browsing this forum: No registered users and 103 guests