Getting int max value in ID

[athora]

Need a help. I'm using lava script(arawp/retrivewap script). Last week someone registered in my site with the max int value in the profile id. (So next registertation goes to unknown mysql error). I deleted that one's profile from the database. But when i test the registertation after deleting it, that profile id also got the max int value. I tried this several times. But same result. Can anyone please help me to findout whats going on?

Added after 6 minutes:

Also I tried by changing the ID data type to smalint and bigint. But still registration getting the max int value

[firemax]

first secure your script ;), then delete the bad user & reset the auto increment id to normal in phpmyadmin > user table> operations > table options.

[athora]

I mean, after deleting the bad user, when i registering(normal registration), my new profile id also goes to max int value. Thats the puzzle

[firemax]

try phpmyadmin >your db> your user table> operations > table options > AUTO_INCREMENT > input last id+1

[athora]

Worked. Thanks bro. ;)