• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 user_id editing

#1
I need to streamline the user_id in wordpress with the same users in xenforo.
I have alot of plugins in wordpress, so it is not easy to change the ID in wordpress
Nor is it easy in X
I noticed when I changed my latest userid in phpmyadmin to 1000 (instead of 13)
and I create a new user, then that user will still get ID = 14
eventhough user_id is autoincrement

So I guess the latest used userid (13) is stored somewhere...
Can you give me a clue where ... ?
 

Mike

XenForo developer
Staff member
#2
We'd never recommend changing a user_id, but it's not stored anywhere. The value comes from MySQL's auto increment value. If that's giving you 14, then that should indicate there isn't a value above 13 in that table.
 
#3
I have 4 users
id
1
13
14
2000 (manually changed id)

I create a new user... and that gets 15 as an ID, not 2001 as I expected
Any ideas?
 

Mike

XenForo developer
Staff member
#4
Are you changing the xf_user table? If not, xf_user is what assigns IDs. If so, you may need to check MySQL's auto increment value as we don't pick an ID; we just accept what MySQL gives us.
 

n00bsaibot

Well-known member
#5
You need to change the Auto_increment value.... it's easiest to do from MyPHPadmin.

Click table xf_users
Click Operations (in top right)
Change AUTO_INCREMENT

Make database backup or test it on a junk db first.