[Forum] english language phrase won't restore

[RealIdea]

hello
i upgraded from 3.8 to 4.1 yesterday
i forgot to delete my arabic language first
after upgrade the Arabic is the only one language stayed
no English
tried to restore it by tools.php and creat empty language names en
but still with the Arabic phrase
i tried to install any language instead but also it installed with the arabic phrase too
what can i do ?

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

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

[RealIdea]

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:

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

that's what i did already

tried to restore it by tools.php and creat empty language names en
but still with the Arabic phrase

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

[RealIdea]

thank you
i did that and got this message
#1146 - Table 'mysite_DB.phrase' doesn't exist

[Steve Machol]

You need to edit that query with the appropriate table prefix you are using for your database.

[RealIdea]

what ?
table prefix ?
what that table ?
which part ?
my database name is like this
mysite_vb

[Steve Machol]

What do you have set for the table prefix in your vB config.php file?

[RealIdea]

databa_vbaccsess

[Steve Machol]

That is your table prefix? What is the complete line?

[RealIdea]

$config['Database']['tableprefix'] = 'databa_vb';

[Steve Machol]

Then the queries would be:

For MySQL 4.0.x use this query:

DELETE
FROM databa_vbphrase
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 databa_vbphrase 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;

[RealIdea]

the same message
#1146 - Table 'databa_vb.phrase' doesn't exist
did you mean
DELETE
FROM databa_vbphrase AS p1
USING databa_vbphrase 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;

MySQL version 5.0.90

[Andrew Elkins]

DELETE
FROM databa_vbphrase 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;

There's no "." in the able name that Steve provided. Please run the above query.

[RealIdea]

There's no "." in the able name that Steve provided. Please run the above query.

i can't reach you
what is the "." mean
and where is the above queries ?
i see its all the same queries