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..