Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Bug Reports / Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

Locked

Started by shrimp_gumbo_mmmhhh on 29 Jul 2007, 4:57 AM · Views: 2,933

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
29 Jul 2007, 4:57 AM
#1
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

Copy All Option Values To Another Option Name Does Not Work.

I get a duplicate error when copying the option values to another option name.

1062 Duplicate entry '86-1' for key 1
in:
[insert into products_options_values values ('86', '1', 'Navy', '2')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

'86' didn't exist before I clicked the UPDATE button. But does exist after I clicked the update button. The '86' value is also not linked as the value I was wanting to copy from. Meaning that when you look at it in the viewer it is associated with a different attribute name then the one I was copying from.

Thank you!

Shrimp-Gumbo

29 Jul 2007, 4:59 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

I have not seen this break before ...

Perhaps you could provide a more precise click for click on how this happened so it can be reproduced ...

Do you have add-ons in the admin?

Do you Import data?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

31 Jul 2007, 8:52 PM
#3
shrimp_gumbo_mmmhhh avatar

shrimp_gumbo_mmmhhh

Totally Zenned

Join Date:
Jun 2007
Location:
Texas, USA
Posts:
1,436
Plugin Contributions:
0

Re: Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

Thank you Ajeh,

I currently have a product option setup... Men's Colors
Men's colors has 6 colors listed each with an attribute picture.

I am trying to copy these to Women's Colors.

I pretty much just created the Women's Colors name with dropdown.

Then went to Copy ALL Option Values to another Option Name

and in the copy from option name put in Men's Colors
and in the copy to name put Women's Colors

Then clicked update and received the error.

Admin Addon's: Quickbooks Import but don't use it

For the Men's Colors I did it all through the system and didn't import it in.

Using 1.3.7 1-17-07

Thank you,

Shrimp Gumbo

1 Aug 2007, 3:39 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Copy All Option Values To Another Option Name Does Not Work for me -- duplicate entry

I cannot repeat this error ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!