Page 1 of 1

Error No: 1060

Posted: Thu Jul 28, 2016 5:41 am
by Printex
Hi Everyone,

I keep getting this error when im trying to upgrade from 1.5.6.4 to 2.2.0.0

Code: Select all

Error Code(0): Error: Duplicate column name 'date_added'
Error No: 1060
ALTER TABLE `oc_printex3d_12_order_recurring_transaction` CHANGE `created` `date_added` datetime NOT NULL AFTER `amount` in /www/xxxxxxxxxxxxxxxxxxx/system/library/db/mysqli.php on line 40
Please Help

Regards

Re: Error No: 1060

Posted: Thu Jul 28, 2016 6:04 am
by straightlight
Printex wrote:Hi Everyone,

I keep getting this error when im trying to upgrade from 1.5.6.4 to 2.2.0.0

Code: Select all

Error Code(0): Error: Duplicate column name 'date_added'
Error No: 1060
ALTER TABLE `oc_printex3d_12_order_recurring_transaction` CHANGE `created` `date_added` datetime NOT NULL AFTER `amount` in /www/xxxxxxxxxxxxxxxxxxx/system/library/db/mysqli.php on line 40
Please Help

Regards
Welcome to the Opencart forum. Restore backups and follow these topics for proper instructions: http://forum.opencart.com/viewtopic.php?f=141&t=165659