Error 1062

This topic is empty.

Viewing 7 reply threads

Author

Posts
- October 13, 2004 at 3:19 am #16395
  
  Ritesh
  Member
  
  SQLyog logs all query(s) that it executes in the History Tab.
  
  Can you see '127' being inserted twice?
- October 13, 2004 at 11:20 am #16396
  
  Shadow
  Member
  
  Are you sure that your PK field is of integer type? Isn't it accidentally a signed tinyint? The error message may be caused by overflow…
- October 13, 2004 at 9:24 pm #16397
  
  qwerty007
  Member
  
  I am getting the exact same error
  
  Error No. 1062
  
  Duplicate Entry '2' for key 1
  
  There is no duplicate. I only have 2 entries in this table. They are both numbers.
  
  21197
  
  21385
  
  That's it.
  
  I can't find a reason for this error.
- October 14, 2004 at 6:53 am #16398
  
  Ritesh
  Member
  
  Can you send me your table structure and sample data?
  
  Information about SQLyog and MySQL versions will be helpful.
- October 14, 2004 at 12:43 pm #16399
  
  qwerty007
  Member
  
  I figured it out. (Tried to post yesterday but the site seemed to be down)
  
  My field length was only set to 1, so MySQL was only taking the first number (in this case '2') when I was trying to manually enter data. My mistake.
- October 14, 2004 at 3:07 pm #16400
  
  Ritesh
  Member
  
  Sorry for the inconvenience caused but our web-server went down for some time 🙁
- October 14, 2004 at 3:31 pm #16401
  
  Shadow
  Member
  
  This might explain terrym's problem as well.
- October 15, 2004 at 10:50 pm #16402
  
  terrym
  Member
  
  Yes!
  
  That's the problem. My id field was a tinyint, which only allows numbers up to 127.
  
  At least we won't get that wrong again?
  
  Thanks
  
  Terry
Author

Posts