title: #1062 - Duplicate entry '1' for key 1 - No duplicate entries found
body: <p>So when trying to add an autoincrement to a field it comes up with #1062 - Duplicate entry '1' for key 1 . I've tried removing the primary key and re-adding it and that works fine (which I assume wouldn't if there was duplicates?)</p>
  
  <p>But when I try to add an autoincrement to the field it throws an error. It gives me a browse option which runs the following SQL:</p>
  
  <pre><code>SELECT *
  FROM `myTbl`
  WHERE CONCAT_WS( "-", 11 ) = "1"
  ORDER BY 11
  LIMIT 0 , 30
  </code></pre>
  
  <p>However this returns a empty result set.. suggesting there are no duplicates. So if there are no duplicates, how come i can't add an autoincrement?</p>