Issue: Error Switching Language View

Issue Tools
- View Changes

April 13, 2010 1:55 PM

Mokonzi

Senior Member

Error Switching Language View

MySQL Error "Unknown Column"

Getting this MySQL Error, not sure why, as I can view the page (as Admin) without error.

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

			SELECT title_enc
			FROM vb3_vault_language AS vlang
			INNER JOIN vb3_vault_list AS vlist ON (vlist.threadid = vlang.translate_1)
			WHERE vlang.translate_-1 = 16250;

MySQL Error   : Unknown column 'vlang.translate_' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, April 13th 2010 @ 09:37:56 PM
Error Date    : Tuesday, April 13th 2010 @ 09:37:57 PM
Script        : /showwiki/Reviews:Terracorp Vulcan dt Review
Referrer      : http://www.mysite.com/showwiki/Reviews:Terracorp+Vulcan+dt+Review

Issue Details

Issue Number 1418

Issue Type Bug

Project VaultWiki 3.x Series

Category Language / Phrasing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0 RC 1

Fixed Version 3.0.0 RC 1

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 13, 2010 2:38 PM

pegasus

VaultWiki Team

This occurs when attempting to switch the language view of the current page using the form below the article, if the namespace of the current page is not translated in the current language (it uses the MASTER LANGUAGE phrase).

In vault/special_class_wiki.php, find:

Code:

	function verify_setcache($langid)
	{
		if ($langid < 1)
		{
			$langid = LANGUAGEID;
		}

Add after:

Code:

		if ($langid < 1)
		{
			global $vbulletin;

			$langid = $vbulletin->options['languageid'];
		}

In vault/special_plugins.php, find:

Code:

function special_verify_id($idname, &$fallbackid, $alert = true, $selall = false, $languageid = 0)

Replace with:

Code:

function special_verify_id($idname, &$fallbackid, $alert = true, $selall = false, $language_id = 0)

Find:

Code:

		$newlanguageid = $languageid ? $languageid : $vbulletin->options['languageid'];
		$languageid = $_POST['vault_langid'] > 0;
		$_SERVER['REQUEST_METHOD'] = 'GET';
	}

	$languageid = $vault->verify_setcache($languageid);

Replace with:

Code:

		$newlanguageid = $language_id ? $language_id : $vbulletin->options['languageid'];
		$language_id = $_POST['vault_langid'] > 0;
		$_SERVER['REQUEST_METHOD'] = 'GET';
	}

	$languageid = $language_id = $vault->verify_setcache($language_id);

Find:

Code:

			WHERE vlang.translate_" . intval($languageid) . " = " . intval($check['threadid']) . "

Replace with:

Code:

			WHERE vlang.translate_" . intval($language_id) . " = " . intval($check['threadid']) . "

April 13, 2010 3:23 PM

Mokonzi

Senior Member

Thanks Pegasus

Reply
April 13, 2010 3:44 PM

pegasus

VaultWiki Team

I don't have a multi-language setup to test. Can you confirm this as fixed?

Reply
April 13, 2010 3:51 PM

Mokonzi

Senior Member

This seems to be fixed, I'm not getting an error when trying to view in a different language... however, there aren't any translated articles atm (am working on that presently as we're almost done with the German translation for the VW3 series), all that is available is English. I assume the user attempted to look at it in English for it to do that error (clicking the Go button), though I can't be certain.

I did notice that when doing that (clicking on English > Go) I end up with an identically named page, but with no text. When I reload, I get the full article I was just looking at.

Not sure why tbh...

Reply
April 13, 2010 4:16 PM

pegasus

VaultWiki Team

See: http://www.vaultwiki.org/issues/1423/

Marking this as fixed in the current ZIP.

Reply
April 13, 2010 4:25 PM

Mokonzi

Senior Member

Thanks Pegasus, will apply the other fix shortly...

Reply

+ Reply

All times are GMT -4. The time now is 10:23 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Error Switching Language View

Issue Tools