Issue Option Value to Option Name

[greglr59]

When I try to add a color option in the Option Value field to my product I get the following error message after clicking Insert.

1062 Duplicate entry '1-1' for key 'PRIMARY'
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', 'white', '0')]
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.

[Ajeh]

Go to your Control Panel for your domain to phpMyAdmin and look to see if you have any records in the table:
products_options_values

If not, run it the SQL:

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;

Then run in the SQL:

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

see if this corrects the problem ...

[greglr59]

Thanks for your reply, but yes products_options_values is in the tables. What would be my next step?

[Ajeh]

how many records are in there?

[greglr59]

this is all new to me, but when I click on Browse and look in the Options section I see 2. Line 1 says TEXT and line 2 says Black.

Should I delete both of these?

[Ajeh]

First, check this table:
products_attributes

Do you have any records in it?

If not, try running the two SQLs that I posted and see if that corrects the problem ...

[aperfecthost]

I don't know what happened to the person who asked the question, but thanks for the answer. I was experiencing the same problem and running the SQL's you provided fixed my problem!

ThANKS!