Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Copy All Option Values To Another Option Name Does Not Work

    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: v1.5.5]
    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!

  3. #3
    Join Date
    Jun 2007
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

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

    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

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

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

    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: v1.5.5]
    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!

 

 

Similar Threads

  1. v155 Copy Option value from one Option name to another - Failing
    By Kcin in forum General Questions
    Replies: 7
    Last Post: 7 Aug 2016, 12:54 AM
  2. Copy option value to all products with option name
    By Nick1973 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 9 Feb 2015, 07:25 PM
  3. Replies: 7
    Last Post: 19 Sep 2012, 03:43 AM
  4. Replies: 0
    Last Post: 28 Oct 2010, 07:08 PM
  5. Same Option name, Different option values for each product
    By pramod in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 2 May 2010, 11:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR