Previous Thread
Next Thread
Print Thread
Hop To
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
I had some other languages on my forums but deleted them after it seems they were causing so many issues.

However, a few users had them as their default and are now telling me that they get an error message when they go to the forums it says that the language packs aren't installed. Any way to get users back to the default?

Thanks

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
SQL Query
UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english' WHERE USER_ID=xxx

where xxx is the user id.. now if you don't want to do it once for each user and you have only ONE language (english), just do

SQL Query
UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english'

that sets everyone to english, regardless..

optionally.. assume you deleted the language 'klingon' and all those users are bitching

to fix just the klingons.. do

SQL Query
UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english' WHERE USER_LANGUAGE='klingon'

changes all klingons to english..

Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Great, thank you!

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
Would be a nice extension to UBB.threads: An option in te Admin Control Panel to delete a language with an integrated check which user use the language and set these user to the system default language with this query above.


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
agreed Zarzal wink


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 963 guests, and 237 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)