XF 1.4 Change default language

Axel B

Well-known member
Hi there,
I migrated from MyBB to Xenforo about two months ago. When migrated users log in for the first time the default language is English. I have changed the default language in Dutch, but I think the imported users are not changed by that setting.

I have access to the database and can run an SQL to correct it. Can somebody please tell me what SQL I need to run to change the default language for all users to Dutch?

Thanks in advance!

Cheers, Axel


XenForo moderator
Staff member
UPDATE xf_user
SET language_id = 1;
Change the value to match the language.
You can check that by clicking on the language and looking at the address bar: