[Forum] How can I reset my EN language

[IRAQEDU.COM]

Hello everybody,

I had Arabic language as default language of my forum, and now I have turned my forum back to English and I deleted the Arabic that I had before, but I still have some phrases in Arabic Although I deleted the Arabic Lang. please can you help me with anyway that lets me keep just English phrases with no another non-English phrases?

I just need it to be like the normal vbulletin forums!

regards,

[josiah]

admin cp > settings > options > style & language.

[Trevor Hannant]

Re-import the master Language file

[Steve Machol]

Try running one of these queries:

For MySQL 4.0.x use this query:

DELETE
FROM phrase
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;

Or for MySQL 4.1.x and higher, use this query:

DELETE
FROM phrase AS p1
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;

Then run this:

Admin CP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]

[postcd]

in my case nothing worked, but finally it was sorted out by doing upgrade (uploading /install directory) the language was added. Import feature tools.php, init.php failed, so only upgrade helped me.