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.


Reply With Quote
