error adding attribute option values

[g28469b]

Hi, When I try to add in an option value for attributes I get the following error -

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', 'Black', '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've searched the forum but can't seem to find anything, is anybody able to give me some help here?.

I had installed a mod previously for product attribute grid but have removed the mod and still have this issue.

i am running zen cart v1.3.9d

[stevesh]

This maybe:

http://www.zen-cart.com/forum/showthread.php?t=156117

If not, search the forums for '1062' - lots of threads with similar problems.

[g28469b]

Have been reading a few posts but none seem to have this exact error

1062 Duplicate entry '0' for key 1

I have deleted my option names and then recreated a new option name succesfully, it's when i go to create a second option name that I get the error.

I tried to run a sql script posted by DrByte but I get the following error.

SQL query:
ALTER TABLE upgrade_exceptions CHANGE COLUMN upgrade_exception_id upgrade_exception_id smallint( 5 ) NOT NULL AUTO_INCREMENT ;
MySQL said:
#1146 - Table 'c06cele_zc1.upgrade_exceptions' doesn't exist

not sure what this means or how to fix it, or even if it's a related problem?.

[g28469b]

I managed to get this fixed. I did a new install of zen cart into another directory. Then matched all the product attribute settings against the new install with regard to the auto_increment.

Once this was done i am now able to add them without any errors.