Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    8
    Plugin Contributions
    0

    Default error adding attribute option values

    Hi, When I try to add in an option value for attributes I get the following error -

    1062 Duplicate entry '1-1' for key 1
    in:
    [insert into zen_products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) values ('1', '1', 'Black', '1')]
    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.


    I've searched the forum but can't seem to find anything, is anybody able to give me some help here?.

    I had installed a mod previously for product attribute grid but have removed the mod and still have this issue.

    i am running zen cart v1.3.9d

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: error adding attribute option values

    This maybe:

    http://www.zen-cart.com/forum/showthread.php?t=156117

    If not, search the forums for '1062' - lots of threads with similar problems.

  3. #3
    Join Date
    Jun 2010
    Posts
    8
    Plugin Contributions
    0

    Default Re: error adding attribute option values

    Have been reading a few posts but none seem to have this exact error

    1062 Duplicate entry '0' for key 1

    I have deleted my option names and then recreated a new option name succesfully, it's when i go to create a second option name that I get the error.

    I tried to run a sql script posted by DrByte but I get the following error.

    SQL query:
    ALTER TABLE upgrade_exceptions CHANGE COLUMN upgrade_exception_id upgrade_exception_id smallint( 5 ) NOT NULL AUTO_INCREMENT ;
    MySQL said:
    #1146 - Table 'c06cele_zc1.upgrade_exceptions' doesn't exist


    not sure what this means or how to fix it, or even if it's a related problem?.

  4. #4
    Join Date
    Jun 2010
    Posts
    8
    Plugin Contributions
    0

    Default Re: error adding attribute option values

    I managed to get this fixed. I did a new install of zen cart into another directory. Then matched all the product attribute settings against the new install with regard to the auto_increment.

    Once this was done i am now able to add them without any errors.

 

 

Similar Threads

  1. v155 Attribute controller - error message when adding attribute values
    By rustwood in forum General Questions
    Replies: 8
    Last Post: 11 Jul 2016, 10:26 PM
  2. Error when adding new option values
    By rdhoke in forum Setting Up Categories, Products, Attributes
    Replies: 9
    Last Post: 28 Dec 2012, 10:21 PM
  3. Replies: 7
    Last Post: 19 Sep 2012, 03:43 AM
  4. Adding all Option Values within an Option to a product
    By ktomas in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 6 Jul 2009, 03:30 AM
  5. Adding many option values and attribute price
    By violet23 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 28 Dec 2008, 12:27 AM

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