Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by SDSkisDan » Tue Jan 22, 2013 12:05 am

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.
SDSkisDan
New member
Posts
26
Joined
Fri Nov 25, 2011 3:59 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by sliponera » Tue Jan 22, 2013 9:13 pm

I am trying to update from 1.5.4 and the same problem here!
Last edited by sliponera on Wed Jan 23, 2013 1:32 am, edited 1 time in total.

http://www.slippers4you.com - women's mules and sheepskin slippers for men

sliponera
New member
Posts
21
Joined
Wed Aug 08, 2012 6:42 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by codeinacan » Wed Jan 23, 2013 12:53 am

Same problem here.
tried the 1.5.5.1 upgrade to see if that would help and I still get the same error.
codeinacan
Newbie
Posts
11
Joined
Sun Nov 20, 2011 7:31 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by snappyfish » Wed Jan 23, 2013 3:45 am

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
snappyfish
Active Member
Posts
123
Joined
Thu Apr 14, 2011 4:36 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by sliponera » Thu Jan 24, 2013 4:31 am

Anyone please?! ???

http://www.slippers4you.com - women's mules and sheepskin slippers for men

sliponera
New member
Posts
21
Joined
Wed Aug 08, 2012 6:42 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by conkif » Thu Jan 24, 2013 6:20 am

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???
conkif
Newbie
Posts
1
Joined
Thu Jan 24, 2013 6:16 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by sliponera » Sat Jan 26, 2013 3:54 am

Does anyone know how to fix this???!!!

We would like to update it.

http://www.slippers4you.com - women's mules and sheepskin slippers for men

sliponera
New member
Posts
21
Joined
Wed Aug 08, 2012 6:42 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by snappyfish » Sat Jan 26, 2013 5:09 am

Re - download 1.5.5.1 and try the upgrade again, Works for me..

Test on non live shop first.
snappyfish
Active Member
Posts
123
Joined
Thu Apr 14, 2011 4:36 am
Top

Re: Upgrade 1.5.3.1 -> 1.5.5.0 Duplicate SQL Entry Error

Quote

Post by zaklamp » Sat Dec 14, 2013 9:20 pm

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
zaklamp
New member
Posts
23
Joined
Thu Jul 19, 2012 8:03 pm
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 15 guests