Error Message when setting up Option Values

[Printcess]

I am using v1.3.9h. I am trying to set up Option Values.

I want to set up size and colour. For example 4 x 6 black and white, 4 x6 sepia...etc So for one product, I want the option of choosing 4x6 black and white OR 4 X6 sepia.

This is what I have done so far:

1. Under Catalog/Option Name Manager:

Created Size and Colour as Option Name.
Dropdown as Option Type

2. Under Catalog/Options Values:

Selected Size and Colour
Typed Sepia under Option Value
Typed 1 for default order


Error displayed:


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


I am not sure what I am doing wrong. I have deleted the Option name and tried to do it again but the same error message comes up.

Can someone help me with this?

Thanks!!

[tygerpaws11]

I'm getting this also. Please help!

[Ajeh]

Go to phpMyAdmin and see if you have anything in the table:

If not, backup your database then run these from the Tools ... Install SQL Patches ...

DROP TABLE IF EXISTS products_options_values;
CREATE TABLE products_options_values (
  products_options_values_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  products_options_values_name varchar(64) NOT NULL default '',
  products_options_values_sort_order int(11) NOT NULL default '0',
  PRIMARY KEY (products_options_values_id,language_id),
  KEY idx_products_options_values_name_zen (products_options_values_name),
  KEY idx_products_options_values_sort_order_zen (products_options_values_sort_order)
) ENGINE=MyISAM;

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

Does this correct the problem?