The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Auto_Increment fields being given a stupidly high value

I'm having a problem with auto_increment fields in a database, new entries are given a stupidly high value.

I.E. The entries jump from 28 (entered on the old server) to 2147483647 on the new server

As far as I can tell the new rows being sent to the database have the value 'null' for the user_id (auto_increment) coloum, and all I have really done to the table is delete a few rows and change the value of one of the rows user_id (auto_increment) coloum manually - none of this has ever caused me a problem before, so I am pretty much stumped on why this is happening.

phpMyAdmin is telling me that the next value for the Autoindex will be 2,147,483,647 which seems a little odd to me considering the table has 26 rows.

Sorry if I havn't been clear / posted all the info - but its late and am suffering from lack of sleep

Well as far as I can remeber there was a row with the user_id -1 (added by the forums to handle annon posting) but I deleted it after the move.

If that is the cause of the problem what's the best way to fix it - last time I used Repair_table I corrupted most of the rows and Nicky won't be too happy with me if I corrupt half of her forum users profile and user data

Thanks, but the problem isn't updating them - there are only one or two entires causing trouble, the problem is that new rows are being enterd with stupidly high values - I need a way to tell MySQL to enter new rows with a sensible value...