MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
7660
Kenn Baker
August 02, 2012 04:50AM
Re: Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
2374
Kenn Baker
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.