ERROR message help 1062 Duplicate entry '1-1' for key 1

[worshamdesigns]

I am getting the following error message when i try to add a option values.

msg:

1062 Duplicate entry '1-1' for key 1
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', '$25', '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.

##########_

I am using zen cart v. 1.3.9h - I just upgraded from 1.3.9g a few days ago.

I looked through the forum for answers and didn't find anything.

Thank you so much for anyone who can direct me in this problem :)

[DrByte]

That means you're trying to enter a record in the database, but that record already exists.

[worshamdesigns]

Thank you for your quick response!

I don't have any attributes at all. Do you know what file i need to delete it from?

[DrByte]

What option names do you have set up?
What other option values are showing? Either in the Option Values Manager or the Option Values Sorter.

Have there ever been any attributes in this store?

What addons are installed?

What 3rd-party tools have you used to load/edit/manage product and/or attribute details in your store?

[worshamdesigns]

What option names do you have set up? just 'price'

What other option values are showing? Either in the Option Values Manager or the Option Values Sorter. There are no other options showing up

Have there ever been any attributes in this store? Yes - I had an upload one but then deleted all of them to start over and see if that worked... but it didn't

What addons are installed? none

What 3rd-party tools have you used to load/edit/manage product and/or attribute details in your store? none

[worshamdesigns]

here is what the screen looks like prior to the error message

wow... you can't really see it.

let me try again

[DrByte]

Very unusual.

Try running the following statement using Admin->Tools->Install SQL Patch:

delete from products_options_values where products_options_values_id > 0;

And then try adding your Option Value again ... this time please list all the steps you take to do it, including the names of menu items selected, etc.

Does it make a difference if you leave out the $ you'd used in the value description?

[worshamdesigns]

I don't know what I would do without this forum!!!!!!!!!!!!! Thank you so very much!

That worked!!!!!!!!

[cyberfrog]

Hi,

I'm working on a site for a client and I've had the exact same error message when trying to set up Option Values. I can set up Option Names no problem but as soon as I try to set up options I get this message: 1062 Duplicate entry '1-1' for key 1

I've tried the SQL patch above but I get:

Not Acceptable

An appropriate representation of the requested resource /zc_admin/sqlpatch.php could not be found on this server.

Anybody any ideas? Thanks.

[DrByte]

I've tried the SQL patch above but I get:

Not Acceptable

An appropriate representation of the requested resource /zc_admin/sqlpatch.php could not be found on this server.

That's because your hosting company's mod_security rules are being triggered by words in that SQL statement that it thinks are normally used by hackers.
Use phpMyAdmin instead of the SQL Patch method.