Error while upgrading duplicate entry

General Installation & Upgrade
1

This is the error I get when upgrading from 1.3.5 sp4 to 2.0.8:


Database error: Duplicate entry '16777215-7' for key 1 (1062)
Invalid query: ALTER TABLE `cscart_new_orders` CHANGE `order_id` `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0' first, CHANGE `user_id` `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `order_id`, COMMENT='', DEFAULT CHARSET='utf8';

Backtrace:
File: /var/www/vhosts/boatbox.be/httpdocs/core/fn.database.php
Line: 311
Function: db_error
File: /var/www/vhosts/boatbox.be/httpdocs/upgrade135sp4-208.php
Line: 197
Function: db_query

2

I got exactly the same error…



Someone have a solution for this?



Thanks in advance!

3

The error is fixed when i deleted all the orders and did the upgrade again…Now i’m looking for a solution to get the orders into the new site…