Language Packs Resulted in Mixed Languages

[SOnline2]

I installed some language packs yesterday which I found here on vb.com, and afterwards when it looked like there was a mixing of languages I deleted all of them except the default English. Now there's still some Spanish and French words showing up. For example, in the AdminCP "Notices" is now "Noticias" and the top says "Panel de Control del Administrador (vBulletin 3.7.3 Patch Level 1". In the forum, "Rate this Thread" says "Calificar discusion".

Is there an easy way to repair this problem? Thanks!

[Steve Machol]

That's a problem with those language packs. 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]

[Floris]

Can you link me to the threads with the .zip files of the language packs you downloaded and had installed?

[SOnline2]

Can you link me to the threads with the .zip files of the language packs you downloaded and had installed?

Thanks, Floris,

Here's the two Spanish files I had installed. This first one came up as "Espanol - LatinAmerica" as I recall, and when using it in conjunction with a dropdown language-picker didn't change the language, so I deleted it (language ID 2):

vbulletin-3.7.3.PL1-Spanish-language.xml (here (http://www.vbulletin.com/forum/showthread.php?t=287052))

This next one came up as "Espanol - MX" as I recall, and did work as far as effecting language-changes within the dropdown control:

language-es_MX-3.6.1 (here (http://www.vbulletin.com/forum/showthread.php?t=109551))

Someone on our board mentioned seeing Spanish and French, and while I did install French, too, I haven't seen any examples of that language sticking, so to speak, just Spanish.

Hope this helps.

[Update: I do remember the "LatinAmerica" coming up first which didn't change the browser, and the "MX" was second, and without re-installing them, I am assuming that the order listed in this post corresponds to the order I had installed]

[SOnline2]

Okay, a member responded with what he found, and yes there is at least one French phrase there:



- On thread pages, the Quick Reply area is now called "Respuesta rápida", in Spanish.

- In the User CP, left column, Modify Signature is now "Modifier votre signature", in French.

- In User CP/Edit Options, near the bottom, Miscellaneous Options are now "Opciones misceláneas", in Spanish.

- In User CP/Send New Message/Additional Options, near the bottom, Miscellaneous Options are now "Opciones misceláneas", in Spanish.

There may be more, but these are the ones I see right now.




I had problems finding a French language pack which would install. As I recall it would come back saying something about a file not found. These packs seemed to have had different requirements which I didn't really understand.

[Floris]

I remember processing the first language pack. It is a custom pack, with translated phrases, and worked fine when I tested it.

I don't remember doing the second one, but from the mod-logs it's clear I processed it. It also is a custom pack and has translated phrases.

Neither packs show me that they are 'master' phrases, which overwrite master language. If you don't run your forum in debug mode when importing the custom packs, I can't see how they would overwrite. But yes, it seems to happen.

[SOnline2]

I remember processing the first language pack. It is a custom pack, with translated phrases, and worked fine when I tested it.

I don't remember doing the second one, but from the mod-logs it's clear I processed it. It also is a custom pack and has translated phrases.

Neither packs show me that they are 'master' phrases, which overwrite master language. If you don't run your forum in debug mode when importing the custom packs, I can't see how they would overwrite. But yes, it seems to happen.

Not sure if this helps, but when we initially added the language-chooser code in the navbar we saw it was too wide because of the phrase "Quick Langiage Chooser" and we shortened the English version to just "Language".

We effected a rebuild of the languages per Steve's post, and it cleared out the problem. We then reapplied the language packs except the French and Spanish, as a test. A member is still complaining that the Quick Links still has Spanish which no one else seems to see. We asked him to refresh his page, clear the cache, etc. Here's what he sees:


Quick Links

Today's Posts
Mark Forums Read
Abrir lista de amigos
FlashChat

User Control Panel
Edit Signature
Editar perfil
Edit Options

Miscellaneous
Private Messages
Subscribed Threads
Mi perfil
Who's Online

Is there something wrong with my settings or is it a system issue? It appears to happen on the second from last item in each section.



Any suggestions appreciated.

[SOnline2]

That's a problem with those language packs. Try running one of these queries:

. . .

Then run this:

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

There's no need to delete the non-default languages first? I should be able to repair the installed languages with your procedure? Thanks in advance, Steve.