MySQL Forums
Forum List  »  MyISAM

Re: Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
Posted by: Kenn Baker
Date: August 02, 2012 11:06PM

The issue ended up being that the table in question was a bit dodgy.

When I ran ANALYZE TABLE `mydatabase`.mytable;

The following was returned.

mydatabase.mytable analyze warning Found row where the auto_increment column has the value 0

OPTIMIZE TABLE `mydatabase`.mytable; fixed the issue and all seems to be good now.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
2231
August 02, 2012 11:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.