How to change the language in all user profiles

[i_rodionov]

After some use of XenForo and attempt to upgrade to 1.0.1 in Russian we have all users profiles set to English, not to Russian as it was. Is there any way to set the language at once to the specific one?

 

[erich37]

not sure what you mean.... you still have the russian-language-file installed ?

 

[i_rodionov]

Yes we still. And it works. But some magic occured - profiles become English. Is there any way to make it back Russian in bulk operation?

 

[i_rodionov]

How to make it using SQL UPDATE? Could you tell me?

 

[Paul B]

http://xenforo.com/community/thread...nother-language-as-default.14252/#post-186470

UPDATE xf_user SET language_id = 1

Change 1 to the ID of the language.

To find the ID, click on the language and look at the URL, the ID will be just before /edit.

Make sure you set it as the default in the ACP for all new registrations.