I have a mysql database with about 180 tables. After setting up the db, I get the following error when trying to populate some of the tables with an auto increment primary key
Database Error: Duplicate entry ‘0’ for key 1
If I alter the affected table and set auto increment to one i can only insert one record and an attempt to insert a second record gives the above error. All my tables are in Innodb engine.
Any help will be appreciated.