OpenCart Community

I updated to 1.5.6.1 a while back and tonight just went to edit an "option" -- when I try to edit it, I get the following error:

Notice: Error: Duplicate entry '0' for key 'PRIMARY'
Error No: 1062
INSERT INTO option_value SET option_id = '21', image = '', sort_order = '0' in /home3/altituf1/public_html/system/database/mysql.php on line 50

This happens after I hit the submit button, and the page does not save my option entry.

Can anyone help with this?

Thank you,
Garret

Hi Garret,

That's a typical database error you get when you try to add a record with a primary key (option_id) value that already exists.

Go into your database and confirm if that record is there. If it is and you still get this error I'm happy to look into it for you.

- Mel

Hi Garret,

all fixed. Your table had the 'auto_increment' flag disabled.

- Mel