EN - Copy of English Language Pack

[Sergio68]

It may seems weird, but where I can found a copy of complete vbulletin english language pack ?
I messed up quite bad my copy and I can't find a way to revert it.

[Steve Machol]

Try this. Reupload the original vbulletin-language.xml file to the install directory. Then upload the tools.php script in the 'do_not_upload' folder of the vB zip file to your Admin CP directory and run it from your browser. Then reimport the vbulletin-language.xml file. Immediately remove tools.php when you are done.

Then run this in the Admin CP:

AdminCP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]

[Sergio68]

Its' exactly the vbulletin-language.xml that I'm not able to find, may be I'm drowning in a glass of water.

[Steve Machol]

Did you follow those instructions? Maybe if you told us what the exact problem is?

[Sergio68]

Long time ago I translated italian phrases directly into the English pack and now it's all messed up.
I would like to revert to the original english language package.

Is it possible to download it in somewhere as I do with others packages ?

[Steve Machol]

I gave you the instructiopns to restore the original English language. Did you follow them? If so, what is the exact problem?

[Sergio68]

Sorry, I have two problems :

a) I can't find the vbulletin-language.xml

b) I restored the original language but italian is still into the package.

[Steve Machol]

Download the vB zip file from the Members Area, upload the install/vbulletin-language.xml file and follow my instructions.

[Sergio68]

install/vbulletin-language.xml

Here it is, I was looking in another directory, thx Steve.

[Sergio68]

Houston we have a problem, it's weird, I did everything, several time.

I uploaded the original vbulletin-language.xml file and rebuild all the languages.
I even downloaded the new vbulletin-language.xml with the tools.php help, then uploaded the language and rebuild all.
The result is nothing, the old english language package with errors is still there.

If I upload the english package with another name (New English or New Language) nothing happens, if I upload a different language as Spanish it's working.
What am I doing wrong ?

Should I delete the english package and then upload ?

[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;

[Sergio68]

Thank you, 132 column affected.
Now something is changed, I don't have anymore irreversible phrases but I can still see some italian reversible phrase into english language.

Same problem with overwriting english package, nothing happens. I tried different uploads and tools.php.

[Steve Machol]

Those are all the instructions I have and up to now they have worked with everyone else who has had this problem. I suggest you contact the author of that Italian language pack and ak him for help since he clearly messed something up.

Also if that pack is available on our forums, let me know the link to it and I'll remove it.

[Sergio68]

The problem Steve it's not with the italian package, that one it's working nice and smooth.
My problem it's with the English package and it's not directly connected to the package, I'm quite sure.

It's only on one of my forums, www.bodyweb.it/forums , it can be almost anything, I started in 2001 from Vb 2.0.2 and I changed several PHP, MySql, Servers and Operating Systems.
At that time I wasn't such an expert (pretty much like today ) and I started to translate by changing the original english package.

Thanks anyway, I'll try something, you wasted enough time for now, I should be able to revert the EN package phrase by phrase after your query.

[Steve Machol]

Yes, I understand that.

The problem is that this Italian language pck meesed up the master language set and this affects the default English language. If you really have followed all of my instructions then the next step is to do what I asked in post #13.