I am trying to add a new attribute, but seem to have a problem with what I think is the increment IDs of the primary key of the table
eav_attribute, which is
Every time I try to add a new attribute I get this error:
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '0' for key 1
I have tried re-indexing, clearing the cache and have truncated all log tables to no effect. A category attribute has been successfully added in a MySQL setup file which I think may have caused the auto increment to come out of sync?
Has anybody experienced this error before?