auto increment "skipping"

[Anon]

I have run into a weird problem using mySQL 3.23.49a. I have recently just moved a database over from another server and in one of the tables the user id field is isn't incrementing properly. Instead of say "215", it inserts "2147483647" which is the maximum value of a signed integer. I'm guessing that means that mySQL thinks that that column is has reached the maximum number of IDs. When I change the field to unsigned and then attempt to enter a new row I get an error saying that it can't insert because there is a duplicate value, "4294967295", for the user id field which is also the primary key. "4294967295" is the maximum value for an unsigned integer. Again leading to the same conclusion as above.

Any ideas what is going on?

Thanks,
Kyle

[Anon]

That's whacked. You could do an sql dump to get all your data, delete the table, recreate it, then read all the data in... maybe that will help.

[Anon]

Tried that, still didn't work. I was thinking about deleting that field and then adding back to the db. We'll see...