[Fixed v1.5.1] Fatal error: 1062:Duplicate entry '1-1' for key 1 adding option values

[videorepair]

New install of v1.50 with new database. Can not enter any option values after creating option name in admin. Just started this install but this is not my first ZC website. Get "WARNING: An Error occurred, please refresh the page and try again." on top left of a white screen.

Log error: [22-Feb-2012 00:44:54] PHP Fatal error: 1062:Duplicate entry '1-1' for key 1 :: insert into products_options_values
(products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
values ('1',
'1',
'Test Option Value',
'10') in /xxxx/xxxx/webxxx/xxxx/www.xxxx.com/public_html/includes/classes/db/mysql/query_factory.php on line 101

Running catalog in ssl mode as well as admin. (Rapidssl 256bit)
Only ad-on is CK_Edit
Already: Reset ALL Products Master Categories ID
: Optimize Database
: Update All Products' Attribute Sort Orders

Any help would be appreciated

[Ajeh]

If you have not added any Option Values yet, you can rebuild the table products_options_values with:

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

[videorepair]

Thank you very much! Works perfectly! I did not have any option values in the database. Never got past the error. Your patch did the trick!

I owe you one!

[Ajeh]

Thanks for the update that this fixed the issue for you ...

[phanmale]

Thanks for the update that this fixed the issue for you ...

I had exactly the same problem with a new build 1.5, run the SQL query and fixed it for me too!

Thank you

[desertmoon]

If you have not added any Option Values yet, you can rebuild the table products_options_values with:

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

I am having this same issue, but I have added options values, can I erase all the option values and use this? If so where does it go? Thank

[Ajeh]

Are you trying to delete all Option Names and Option Values or just Option Values associated with the Option Names?

[DrByte]

Fixes to accommodate this scenario are included in v1.5.1