MyBB Community Forums

why do you care what the user ID is?

Are you just trying to make it so the UID is the next number in the sequence? If so, I believe this is the correct query to run in PHPMyAdmin

ALTER TABLE mybb_users AUTO_INCREMENT='x'

Replace X with the what would be the next number.

XD

AUTO_INCREMENT didn't came in my mind

I edited AUTO_INCREMENT and everything is fine

thx man...u saved the day