Unable to insert into mysql



I’m having a strange problem. When I try to insert 3 records into a table it only inserts 1 record. If I copy the table structure to a new table without the data the insert works as it should. Is there anyway to fix the existing table?


Show the code that does insertions.


Thanks, the problem was with the table structure and a unique index.