Phrase Issues

[Daniel]

Hey all,

I've got some weird phrase issues going on. I installed French on my forum, and it appears to be leaking into the English. I can fix it manually by copying the default text into the English language, but there's just so much...

Has anyone encountered this problem? Have you found an easier way to fix it? If you haven't, but have an idea, please share.

Much thanks!

Edit: To fix this issue, run this query:

highly recommend backing up your board first though - I lost my custom phrases in the process

DELETE FROM phrase WHERE languageid = 0

[kh99]

Hmm...in the admincp under Settings > Options > Style & Language Settings, what do you have selected for Default Language?

[Daniel]

Funny you should ask :P

[kh99]

So you have English selected as default but you're still getting French sometimes? I guess that was my only idea.

[ozzy47]

Perhaps the language pack has phrases in it that are not in vB by default?

[Daniel]

So you have English selected as default but you're still getting French sometimes?
Yep, exactly.

Perhaps the language pack has phrases in it that are not in vB by default?
I dunno, I downloaded the French version directly from the vBulletin.com Members Area, but I suppose that's possible. What to do?

[kh99]

Well, I've never installed a language pack or worked with anything other than English, but I've looked at the fetch_phrase() function that decides which language to get a phrase from. It goes through them in a certain order and looks for the first language where the phrase is non-blank. So from what you describe it seems that it's finding the French before the 'Master" language, or else installing that language pack has somehow made French the 'Master' language. I think the master should be english that vbulletin comes with by default, so it should contain all phrases. But if someone or something has added phrases then Ozzy could be right. (Well, except that I still can't see why it wouldn't use the English if it exists in one of the other languages).

If you put your site in to debug mode (temporarily), the Master language should appear in the Language Manager. Maybe if you look at that it will provide some clues.

Here's an article on turning on debug mode if you haven't used it before: https://vborg.vbsupport.ru/showthread.php?t=265999 .

[Daniel]

Yea... I did fine something interesting. It seems that all the phrases have the option to be "reverted" to their original. I'd like to revert them all, without doing that manually, if possible. Do you know of a way to do that?

Welp, either that or forgetting this 'Master Language' business and using 'English' as the default.

Hey y'all, an update; Running this query solved the issue.
DELETE FROM phrase WHERE languageid = 0
highly recommend backing up your board first though - I lost my custom phrases in the process

[Lynne]

How did you go about uploading the style? You didn't select to upload it as the Master Style, did you? (That should only be an option if you are in debug mode.)

[Daniel]

I'm not sure what you mean by style. Do you mean language? I didn't upload the language while the forum was in debug mode, so I don't think that was an option. Also note that there was a mix of the languages-95% English, 5% French. It was weird...

[HM666]

I'm not sure what you mean by style. Do you mean language? I didn't upload the language while the forum was in debug mode, so I don't think that was an option. Also note that there was a mix of the languages-95% English, 5% French. It was weird...

The Style refers to your skin (the design) for your forum. So it is not a language its the look and feel of your site.

[kh99]

The Style refers to your skin (the design) for your forum. So it is not a language its the look and feel of your site.

I think he knew that but was confused because we were talking about languages, not styles. I think Lynne probably misspoke.

In any case, Daniel, you're saying that deleting all the English phrases from language 0 made it so that some French phrases didn't show up any more? That's strange. Or was it that language 0 had some French phrases in it?

[HM666]

I think he knew that but was confused because we were talking about languages, not styles. I think Lynne probably misspoke.

In any case, Daniel, you're saying that deleting all the English phrases from language 0 made it so that some French phrases didn't show up any more? That's strange. Or was it that language 0 had some French phrases in it?

Ah I saw her post and figured there was confusion on the difference between the two. Whoops sorry my senile self will go take my afternoon nap now lol.

[Lynne]

I think he knew that but was confused because we were talking about languages, not styles. I think Lynne probably misspoke.

I did. I meant to ask how he went about uploading the *language" xml file and what settings he picked on the upload page when he did so.

[Daniel]

I think he knew that but was confused because we were talking about languages, not styles. I think Lynne probably misspoke.

In any case, Daniel, you're saying that deleting all the English phrases from language 0 made it so that some French phrases didn't show up any more? That's strange. Or was it that language 0 had some French phrases in it?

At this point... I don't know. I was just doing some research and stumbled upon someone who said that it worked for them. I tried it, and it worked---but custom phrases were removed in the process. That's OK with me though as it beats having to convert from French to English manually.