Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jun 2011
    Location
    Fort Walton Beach, FL
    Posts
    16
    Plugin Contributions
    0

    Default 1062 Duplicate entry '1-1' for key 1

    Yesterday I started to add options to my products, but realized
    I was doing it all wrong (everything was an option title). I'd
    misunderstood the video tutorial I saw.....

    So, today, I deleted all of it to start over, following the text
    version of the tutorial here. Just a couple of problems now,
    however....

    When adding the option name, everything went smoothly.
    When I started trying to add option values, however, things
    really started to break down. I selected the option name
    ("Photo Poster Sizes" --- it's the only one) and then I
    entered the first option value (18x12 inches), and finally,
    the sort order. Then I hit "Insert". I immediately got the
    following error:

    1062 Duplicate entry '1-1' for key 1
    in:
    [insert into products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) values ('1', '1', '18x12 inches', '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 know exactly zero about database stuff, but my immediate
    guess is that this is a database error. Is that correct? And
    if so (or if not, for that matter), what can I do about it?

    Thanks,
    --jim

    EDIT: I should also point out that, even if I use a NEW
    product value (e.g., 18x12) the result is still the same.

  2. #2
    Join Date
    Jun 2011
    Location
    Fort Walton Beach, FL
    Posts
    16
    Plugin Contributions
    0

    Default Re: 1062 Duplicate entry '1-1' for key 1

    Never mind...I just reloaded ZenCart and my data (up to products...no further yet).

 

 

Similar Threads

  1. 1062 Duplicate entry '' for key 2
    By Shavelieva in forum General Questions
    Replies: 0
    Last Post: 17 Nov 2007, 06:07 AM
  2. 1062 Duplicate entry '0' for key 1
    By knitengale in forum General Questions
    Replies: 8
    Last Post: 12 Jul 2006, 12:50 AM
  3. 1062 Duplicate entry '0' for key 1
    By marckasten in forum General Questions
    Replies: 3
    Last Post: 12 Jun 2006, 06:19 PM

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