Change default language for all users

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
panhead
Registered User
Posts: 533
Joined: Sat Dec 20, 2003 8:17 pm

Change default language for all users

Post by panhead » Mon Mar 22, 2010 9:23 pm

I have changed the default language (from English to British English). How can I make this the default language for existing members?

User avatar
3Di
Registered User
Posts: 10933
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Change default language for all users

Post by 3Di » Mon Mar 22, 2010 9:49 pm

you should run a query against the USERS_TABLE, the field is user_lang .
Want to compensate me for my interest? You can.
You can pm me only in case of request for paid job. Thx.
MOD conversions, Extensions and Scripts for phpBB.

panhead
Registered User
Posts: 533
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Post by panhead » Mon Mar 22, 2010 9:52 pm

Thank you, that's clear.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 46564
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Change default language for all users

Post by stevemaury » Mon Mar 22, 2010 9:59 pm

Code: Select all

UPDATE phpbb_users SET `user_lang` = 'en'  WHERE `user_type` <> 2;
http://www.phpbb.com/kb/article/executi ... hpmyadmin/
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

User avatar
3Di
Registered User
Posts: 10933
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Change default language for all users

Post by 3Di » Mon Mar 22, 2010 10:05 pm

For those they are not running on MySql just remove the ` (back ticks) from the above query.
Want to compensate me for my interest? You can.
You can pm me only in case of request for paid job. Thx.
MOD conversions, Extensions and Scripts for phpBB.

panhead
Registered User
Posts: 533
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Post by panhead » Tue Mar 23, 2010 7:19 am

Thanks for the help.

panhead
Registered User
Posts: 533
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Post by panhead » Tue Mar 23, 2010 8:46 am

Just one more question, how can I prevent users to change their default language?

User avatar
ric323
Former Team Member
Posts: 22908
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Change default language for all users

Post by ric323 » Tue Mar 23, 2010 12:27 pm

Do you need any other languages installed?
If not, just uninstall all the other languages, then they won't be able to change.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

panhead
Registered User
Posts: 533
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Post by panhead » Tue Mar 23, 2010 2:09 pm

No, not really. That is a simple solution :D

wonderland
Registered User
Posts: 102
Joined: Thu Aug 18, 2005 12:45 pm

Re: Change default language for all users

Post by wonderland » Thu Aug 23, 2012 11:08 am

I think that easiest solution would be just set new language as default un-install current default language.
And then re-install if needed.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 16894
Joined: Fri Aug 29, 2008 9:49 am

Re: Change default language for all users

Post by Mick » Thu Aug 23, 2012 11:12 am

@Wonderland: Why are you replying to two year old topics marked as Image?
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
ric323
Former Team Member
Posts: 22908
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Change default language for all users

Post by ric323 » Thu Aug 23, 2012 11:13 am

There was no need to do any extra steps, and it is a bit pointless commenting on a topic which is more than two years old...
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 58 guests