• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Error Switching Language View

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

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Error Switching Language View

    • Issue Tools
      • View Changes
    1. issueid=1418 April 13, 2010 1:55 PM
      Mokonzi Mokonzi is offline
      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)




    1. April 13, 2010 2:38 PM
      pegasus pegasus is offline
      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']) . "
      Reply Reply  
    2. April 13, 2010 3:23 PM
      Mokonzi Mokonzi is offline
      Senior Member
      Thanks Pegasus
      Reply Reply  
    3. April 13, 2010 3:44 PM
      pegasus pegasus is offline
      VaultWiki Team
      I don't have a multi-language setup to test. Can you confirm this as fixed?
      Reply Reply  
    4. April 13, 2010 3:51 PM
      Mokonzi Mokonzi is offline
      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 Reply  
    5. April 13, 2010 4:16 PM
      pegasus pegasus is offline
      VaultWiki Team
      See: http://www.vaultwiki.org/issues/1423/

      Marking this as fixed in the current ZIP.
      Reply Reply  
    6. April 13, 2010 4:25 PM
      Mokonzi Mokonzi is offline
      Senior Member
      Thanks Pegasus, will apply the other fix shortly...
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.