View Single Post
  #5  
Old 06-17-2003, 05:27 PM
IAMrCleric
Fire Beetle
 
Join Date: Jun 2003
Posts: 5
Default One thing I found

I'm using ver 4.0.13-nt of mySql and I ran into a problem where I was trying to insert more data into the spawn2 table. the last Id in the row was 1000. I was trying to insert a new row using 1001. It gave me duplicate entry error. This might be part of the problem if you are like me and sourced in a few files then manualy deleted the records.

I wish I new how to reclaim or reset the auto_increment number for the id field in the spawn2 table