View Full Version : Solved Question about 'Default Language' setting.

24-01-10, 05:37
When I installed vBET, I already had about 18,000 forum users, most of which have not yet set their 'default language' setting in their user CP. I don't want to require this, as it'll result in many tech noobs asking me why the system won't let them view threads.

Thus, my question is this- what MySQL query should I manually run to update all 'Not Set' values to just 'English'?

24-01-10, 18:30
First of all - when user default language is not set then vBET assumes that it is same as forum default language. So you do not have to set it at all :)

If you still want to this is the query (NOTE: add table prefix if you use it before table name):

UPDATE user SET vbet_def_lang='en' WHERE vbet_def_lang IS NULL OR vbet_def_lang='';

26-01-10, 07:47
Thanks very much!

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Integration with Google translations by vB Enterprise Translator 4.9.2