Page 1 of 1
Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Tue Jan 22, 2013 12:05 am
by SDSkisDan
I know, I know. No one should upgrade to a release as soon as it comes out, which is why this is on my development box. I just downloaded the latest 1.5.5 from Github and during the upgrade script, I get an error:
Code: Select all
Notice: Error: Duplicate entry '8-1' for key 'PRIMARY'
Error No: 1062
INSERT INTO `customer_group_description` SET `customer_group_id` = '8', `language_id` = '1', `name` = 'Default' in /home/mysite/public_html/oc/system/database/mysql.php on line 50
Is this something screwy with the upgrade SQL or just my database?
Thanks.
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Tue Jan 22, 2013 9:13 pm
by sliponera
I am trying to update from 1.5.4 and the same problem here!
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Wed Jan 23, 2013 12:53 am
by codeinacan
Same problem here.
tried the 1.5.5.1 upgrade to see if that would help and I still get the same error.
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Wed Jan 23, 2013 3:45 am
by snappyfish
Same error, Upgrading from 1.5.4.1 testing on wamp
Code: Select all
Notice: Error: Duplicate entry '8-1' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `customer_group_description` SET `customer_group_id` = '8', `language_id` = '1', `name` = 'Default' in D:\Programs\wamp\www\my_site\system\database\mysql.php on line 50
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Thu Jan 24, 2013 4:31 am
by sliponera
Anyone please?!
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Thu Jan 24, 2013 6:20 am
by conkif
I HAVE ALSO THAT PROBLEM
Notice: Error: Duplicate entry '100007-59-6' for key 'PRIMARY'
Error No: 1062
ALTER TABLE `product_attribute` ADD PRIMARY KEY(`product_id`,`attribute_id`,`language_id`) in /home/ccmania/public_html/opencshop/system/database/mysql.php on line 50
FROM 1.4.1 GOES TO 1.5.0 AND THIS PROBLEM OCCUR
ANYONE???
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Sat Jan 26, 2013 3:54 am
by sliponera
Does anyone know how to fix this???!!!
We would like to update it.
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Sat Jan 26, 2013 5:09 am
by snappyfish
Re - download 1.5.5.1 and try the upgrade again, Works for me..
Test on non live shop first.
Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error
Posted: Sat Dec 14, 2013 9:20 pm
by zaklamp
i got the same problem...
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/xxx/domains/xxxxx/public_html/system/database/mysql.php on line 50