Trouble with a second language

**pingelich** · July 10, 2010

Hi!

On our german forum I installed english as alternative language. If I now select in my profile-settings english as main language and go to WIKI (showwiki.php?title=Wissensdatenbank) I get a 404-error. The URL change to http://www.example.org/showwiki.php?...ssensdatenbank&langid=1

Can you help me?

**pegasus** · July 10, 2010

If the only thing that changes about the URL is it gains &langid=1 then you should not receive a 404, unless the wiki gives you a 404 all the time. The 404 implies that it can't find the showwiki.php file. I can't help more unless you use the full real URLs in your post.

**beduino** · July 23, 2010

I'm with this trouble too
I use portuguese language in my vBulletin - and when I choose language english the wiki don't work.

**pegasus** · July 23, 2010

Again, I need the real URLs in order to investigate this further.

**beduino** · July 23, 2010

hi pegasus
sorry the delay
I upgrade to last vaulwiki and works.
I will install vBseo now
the url is
http://e-liberdade.net/showwiki.php [portuguese]
http://e-liberdade.net/showwiki.php?langid=1 [english]

I report later
thank you

**beduino** · July 24, 2010

Problem
When I start a new page and when I try edit content ...

Code:

Database error in vBulletin 4.0.5:

Invalid SQL:

					REPLACE INTO v0b_vault_language
						(translate_2)
					VALUES
						(24);

MySQL Error   : Unknown column 'translate_2' in 'field list'
Error Number  : 1054
Request Date  : Friday, July 23rd 2010 @ 11:24:54 PM
Error Date    : Friday, July 23rd 2010 @ 11:24:55 PM
Script        : http://e-liberdade.net/showwiki.php?title=Novo_Teste&do=edit
Referrer      : http://e-liberdade.net/showwiki.php?do=create
IP Address    : 189.60.181.152
Username      : beduino
Classname     : vB_Database
MySQL Version : 5.0.91-community

How I can fix this?

**pegasus** · July 24, 2010

The only way I see this happening if this happened in this order:

You were already running VaultWiki 3.0.0 Beta 5 or later.
You disabled VaultWiki.
You created the language.
You re-enabled VaultWiki later.

In order to fix this, you'll need to manually modify the database:

Code:

ALTER TABLE v0b_vault_language
ADD translate_2 INT(10) UNSIGNED NOT NULL DEFAULT '0',
ADD INDEX translate_2 (translate_2)

**beduino** · July 24, 2010

OK Pegasus
I will do it
But - the problem appears after I upgrade vaultwiki. The language already exists [is one of the first things I do in my projects]
I give feedback soon