XF 1.5 user_id editing

[998877]

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]

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.

 

[998877]

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]

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]

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.