XF 1.4 Change default language

[Axel B]

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

 

[Paul B]

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:

 

[Axel B]

@Brogan, many thanks!

 

[daimpa]

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:
View attachment 88663

Is this still valid for XF2?

 

[SyTry]

Is this still valid for XF2?

Hello,

Yes.

Regards, SyTry