US English Lan got screwed up

[WebmasterSimds]

I added a few languages to the board, and somehow all the other languages got mixed into the US default language.

Dowes anyone know how to fix that problem? I tried the one in the install folder and it didnt re set it all back to normal. so now what do I do?

Thanks In Advance

[Steve Machol]

Try this. Run this query:

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

And for 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 now:

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

[WebmasterSimds]

Ok did that, then ran a phrase check on the word that was showing and it came to show this for that word:

Search ResultsThread Management Phrases Containing 'Opciones'delete_optionsCustom PhraseOpciones de BorrarStyle Tools Phrases Containing 'Opciones'download_style_advanced_optionsCustom PhraseSi quieres opciones avanzadas para esta descarga, pulsa 'Ok',\nen caso contrario pulsa 'Cancel' para una descarga estándar.Register Phrases Containing 'Opciones'preferences_and_optionsCustom PhrasePreferencias y OpcionesError Messages Phrases Containing 'Opciones'field_option_maximum_invalidCustom PhraseHas fijado un máximo de {1} opciones para el campo de perfil personalizado <b>{2}</b>. No se te permite sobrescribir este límite ya que el usuario no podrá actualizar su perfil sin cambiar este campo para que esté dentro de el límite.Control Panel Stop Message Phrases Containing 'Opciones'field_option_maximum_invalidCustom PhraseHas fijado un m&aacute;ximo de {1} opciones para el compo de perfil <b>{2}</b>. No se te est&aacute; permitido sobrescribir este l&iacute;mite ya que el usuario no podr&aacute; actualizar su perfil sin cambiar este campo a que est&eacute; sobre el l&iacute;mite.Search ResultsThread Management Phrases Containing 'Opciones'delete_optionsCustom PhraseOpciones de BorrarStyle Tools Phrases Containing 'Opciones'download_style_advanced_optionsCustom PhraseSi quieres opciones avanzadas para esta descarga, pulsa 'Ok',\nen caso contrario pulsa 'Cancel' para una descarga estándar.Register Phrases Containing 'Opciones'preferences_and_optionsCustom PhrasePreferencias y OpcionesError Messages Phrases Containing 'Opciones'field_option_maximum_invalidCustom PhraseHas fijado un máximo de {1} opciones para el campo de perfil personalizado <b>{2}</b>. No se te permite sobrescribir este límite ya que el usuario no podrá actualizar su perfil sin cambiar este campo para que esté dentro de el límite.Control Panel Stop Message Phrases Containing 'Opciones'field_option_maximum_invalidCustom PhraseHas fijado un m&aacute;ximo de {1} opciones para el compo de perfil <b>{2}</b>. No se te est&aacute; permitido sobrescribir este l&iacute;mite ya que el usuario no podr&aacute; actualizar su perfil sin cambiar este campo a que est&eacute; sobre el l&iacute;mite.


shoulld I delete all the other languages that I added? then do a rebuild as you suguested?

[Steve Machol]

Yes, I would do that.

[WebmasterSimds]

I deleted all the other language files that were there, I did what you said to do a query, then went to tools then language> rebuild files and i still get a whole lot of other languages mixed into the phrases? now wht do I do??

[Steve Machol]

One of those queries should have fixed this. Which version of MySQL are you running?

[WebmasterSimds]

4.0.x

My Server ( I own one) has the following

PHP version4.3.11MySQL version4.0.25-standardcPanel Build10.8.2-STABLE 120

[Steve Machol]

1. Run this query (assuming no table prefix otherwise add the appriopriate prefix):

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;

2. Then:

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

[WebmasterSimds]

Still would not work , unless its suppose to look this way?

[Steve Machol]

If you have installed any Plugins or Products, first disable these to see if you still have this problem.

Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If you still have this problem with plugins disabled, check the includes/xml dire3ctory and make sure only the original vB files are in there and none from any add-ons. Then if you still have a problem and have not installed any hacks (which includes portals), fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.