Zen Cart Logo
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

Views: 2,919

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?

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 ...