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 :confused:
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 ;)