Forums / Setting Up Categories, Products, Attributes / 1062 Duplicate entry '1-1' for key 1

1062 Duplicate entry '1-1' for key 1

Started by spooky130 on 17 Jun 2011, 11:15 PM · Views: 910

Results 1 to 2 of 2
17 Jun 2011, 11:15 PM
#1
spooky130 avatar

spooky130

New Zenner

Join Date:
Jun 2011
Location:
Fort Walton Beach, FL
Posts:
16
Plugin Contributions:
0

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.

18 Jun 2011, 4:33 AM
#2
spooky130 avatar

spooky130

New Zenner

Join Date:
Jun 2011
Location:
Fort Walton Beach, FL
Posts:
16
Plugin Contributions:
0

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

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