Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: User ID = 999999999?


cweb
Member

@cweb

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?

Skip to toolbar