clarkwinkelmann Lolu you mean via an extension, or via a tool like phpMyAdmin ? Could you explain in more details what you try to achieve ? There's no user_id column in the users table. You mean id ? If some IDs are missing it must be because users were deleted.
clarkwinkelmann Lolu why do you need to change the IDs ? They are not meant to be updated. Because Flarum migrations don't set ON UPDATE constraints on foreign keys I don't think it can be updated from the users table alone. You'd need to disable key checks on the database, then update the IDs everywhere by hand or via a script. Then re-enable foreign key checks.
clarkwinkelmann Also additional note: if you change user IDs, you have to invalidate all sessions otherwise some users could end up connected as other users. It's really best to never change them.
