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?.