How to restore english installation language / phrases?

[Fred_J]

At last!!!

It must be a bug in the VB-version. When I manually upload the file in the install directory on the server and use the option "import the XML file from your server" it...

[Fred_J]

Well, actually I still have a problem. As you know I installed another forum version (a fresh one). However, in neither version I can't upload a language file and get it to work. And in the fresh version...

[Fred_J]

This command still returns an error message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS p1 LEFT JOIN...

[Fred_J]

To install a fresh copy of the Vbulletin forum and export the phrase and phrasetype table and then import it into the old one worked!

[Fred_J]

Thank you! I will try this solution once I have done the above, and we can see if it works (if someone else bumps into the problem and do not want to do it the long way).

[Fred_J]

Now I deleted the entire phrases in the database. After I tried to upload the original language file vbulletin-language.xml. But this file does not contain all the translations. Many phrases are missing....

[Fred_J]

No, unfortunetaly the table name is correct. It must be something else....

[Fred_J]

I actually tried to do as your support suggested, but something is wrong in the SQL-syntax. I understand the logic, but I'm not a developer and don't want to mess around with something I don't fully understand....

[Fred_J]

I tried this one:
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
...

[Fred_J]

Hi,
I recently bought a version of Vbulletin 4.1.12. I tried to install the swedish english package. Afterwards I realized I wanted to keep the english language. Now I'm trying to put back the vbulletin-language.xml...