Not a bug Error creating new user

[John]

Received this error when manually creating a new user via the ACP on my localhost installation:

 

[Jake Bunce]

That looks like a problem with your unique indexes in the database.

Check these tables using phpmyadmin:

xf_user
xf_user_authenticate
xf_user_option
xf_user_privacy
xf_user_profile

The highest user_id should be the same in each of these tables. If any of them are higher than the xf_user table then that explains the error. A quick fix is to increase the AUTO_INCREMENT value in xf_user by selecting that table and clicking the Operations tab.

 

[Mike]

Yeah it looks to me that the data in those tables aren't in sync for some reason. I can only guess that some data was manually edited?

 

[John]

Yeah it looks to me that the data in those tables aren't in sync for some reason. I can only guess that some data was manually edited?

I only had two users on this install, myself and a dummy account. The dummy account didn't import properly, apparently, after the upgrade from 1.0.4 to B1 but I didn't check it till the upgrade to B2. I did manually delete it from the database because it wouldn't let me from the ACP (saying the user didn't exist) and tried to re-create it via the ACP and got this error. I ended up just re-registering the account from the forum interface.