Post by zaklamp » Sat Dec 14, 2013 9:58 am

Dear Opencart experts,

I would like to upgrade my webstore. I uploaded 1.5.6 and tryed to upgrade, though i am getting error's i do not know what to do with it...

Notice: Error: Duplicate entry '290-18-2' for key 'PRIMARY'
Error No: 1062
ALTER TABLE `product_attribute` ADD PRIMARY KEY(`product_id`,`attribute_id`,`language_id`) in /home/zaklamp/domains/zaklampwinkel.com/public_html/system/database/mysql.php on line 50

I also got this error i fixed with this forum thread > http://forum.opencart.com/viewtopic.php?f=19&t=106677

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in /home/zaklamp/domains/zaklampwinkel.com/public_html/system/database/mysql.php on line 50

Does anyone knows if it got something to do with it?

Thank you very much!

Kind regards,

Bram Louwers

New member

Posts

Joined
Thu Jul 19, 2012 8:03 pm

Post by butte » Sun Dec 15, 2013 4:16 am

Replace the upgrade script with the one downloadable immediately above the recap of Error No. 1064 at http://forum.opencart.com/viewtopic.php ... on#p434624

Start all over, again, using your original database phpMyAdmin Export (Import it) or oc admin System / Backup (Restore it). The fileset can probably be left intact, and especially keep the two config.php files from the 1.5.1.3 store.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 3 guests