Corrupt English Language

[ibaker]

Hi
To cut a long story short I made a mistake causing me to do a separate install of vB and migrate the data over table by table (some tables were damaged).

The forum is working well now except for what I feel is a language problem. I tried to import the vbulletin-language.xml file and received the following database error (some details have been removed for posting)

Database error in vBulletin 3.7.2:

Invalid SQL:

            SELECT fieldname, varname, text
            FROM phrase
            WHERE languageid IN(-1,0) AND
                fieldname IN ();

MySQL Error   : 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 ')' at line 4
Error Number  : 1064
Request Date  : Tuesday, August 12th 2008 @ 12:18:59 AM
Error Date    : Tuesday, August 12th 2008 @ 12:18:59 AM
Script        : http://<address removed for post>/forum/admincp/language.php?do=rebuild&goto=language.php?
Referrer      : http://<address removed for post>/forum/admincp/language.php?do=upload
IP Address    : <address removed for post>
Username      : <removed for post>
Classname     : vb_database
MySQL Version : 5.0.51-log

Any help is greatly appreciated.

[Jake Bunce]

Try importing the language using the tools file.

First upload the original install/vbulletin-language.xml file from the zip file. Then go into the do_not_upload folder in the zip file. Upload the tools.php file to the install directory on your server. Run the tools.php file in your browser and select the option to reimport the language. Delete the tools file when you are done.

That might fix it, although it looks like there might be a more serious problem with the database schema. I recommend restoring a good backup instead of trying to manually repair the database.

[ibaker]

Thanks Jake but unfortunately my hosting Co has informed me that the last backup they did was nearly 2 weeks ago - not good!

[Jake Bunce]

Restoring any backup involves the loss of recent data, but it is better than nothing at all. You can always make more regular backups to cover yourself in the worst case.