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

Change default language for all users

Postby 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?
panhead
Registered User
 
Posts: 393
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

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

you should run a query against the USERS_TABLE, the field is user_lang .
User avatar
3Di
Registered User
 
Posts: 8557
Joined: Mon Apr 04, 2005 11:09 pm
Location: Italia - Germany
Name: Marco

Re: Change default language for all users

Postby panhead » Mon Mar 22, 2010 9:52 pm

Thank you, that's clear.
panhead
Registered User
 
Posts: 393
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Postby 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

http://www.stevesstocks.com

All unsolicited PMs will be ignored.
User avatar
stevemaury
Support Team Member
Support Team Member
 
Posts: 44096
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: Change default language for all users

Postby 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.
User avatar
3Di
Registered User
 
Posts: 8557
Joined: Mon Apr 04, 2005 11:09 pm
Location: Italia - Germany
Name: Marco

Re: Change default language for all users

Postby panhead » Tue Mar 23, 2010 7:19 am

Thanks for the help.
panhead
Registered User
 
Posts: 393
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Postby panhead » Tue Mar 23, 2010 8:46 am

Just one more question, how can I prevent users to change their default language?
panhead
Registered User
 
Posts: 393
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Postby 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
User avatar
ric323
Former Team Member
 
Posts: 22903
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric

Re: Change default language for all users

Postby panhead » Tue Mar 23, 2010 2:09 pm

No, not really. That is a simple solution :D
panhead
Registered User
 
Posts: 393
Joined: Sat Dec 20, 2003 8:17 pm

Re: Change default language for all users

Postby 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.
wonderland
Registered User
 
Posts: 102
Joined: Thu Aug 18, 2005 12:45 pm

Re: Change default language for all users

Postby Mick » Thu Aug 23, 2012 11:12 am

@Wonderland: Why are you replying to two year old topics marked as Image?
Remember, it's not the magic wand it's the magician! All unsolicited PM's will be trashed.
Image
User avatar
Mick
Support Team Member
Support Team Member
 
Posts: 13014
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff - UK

Re: Change default language for all users

Postby 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
User avatar
ric323
Former Team Member
 
Posts: 22903
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric


Return to 3.0.x Support Forum

Who is online

Users browsing this forum: Oyabun1, servetech and 70 guests