Re: User ID = 999999999?
I’ll confirm that I have this problem as well, from a phpbb to bbpress conversion. I actually tried to reset the auto_increment like chrishajer said:
ALTER TABLE bb_users AUTO_INCREMENT = 400
Since my original ID’s stopped at around 350.
It didn’t work though, still incrementing in the billions. MySQL documentation says:
“You cannot reset the counter to a value less than or equal to any that have already been used.”
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
So to me that reads I need to delete the admin user 999999999 first, am I correct?