• 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
    • After upload patch files, get this db error in some pages : Unknown column 'thread.taglist' in 'field list'

    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: After upload patch files, get this db error in some pages : Unknown column 'thread.taglist' in 'field list'

    • Issue Tools
      • View Changes
    1. issueid=2361 June 19, 2011 12:24 AM
      basketmen basketmen is offline
      Junior Member
      After upload patch files, get this db error in some pages : Unknown column 'thread.taglist' in 'field list'

      After uploaded just patch files, from VW 3.0.11 to 3.0.12

      some get this db error :
      Code:
      Database error in vBulletin 3.6.12:
      
      Invalid SQL:
      
      			SELECT thread.threadid, thread.forumid, thread.title,
      				thread.taglist,
      				postusername, user.userid, user.username, user.usergroupid, user.membergroupids,
      				thread.lastpost, thread.replycount,
      				forum.title AS forumtitle, forum.vault_type
      				,post.pagetext AS preview
      				, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      				, art.languageid
      			FROM thread AS thread
      			INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
      			
      			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
      			
      			LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 3 AND canview = 1)
      			LEFT JOIN user AS user ON (user.userid = thread.postuserid)
      			INNER JOIN vault_article AS art ON (art.threadid = thread.threadid)
      			
      			WHERE thread.threadid IN (88183, 33355, 47808, 47806, 88184) AND thread.visible = 1
      				AND thread.forumid IN (3046)
      				
      				
      				
      			ORDER BY lastpost DESC;
      
      MySQL Error  : Unknown column 'thread.taglist' in 'field list'
      Error Number : 1054
      Date         : Sunday, June 19th 2011 @ 11:06:22 AM
      Script       : http://www.domain.com/wiki/Charles-Robert-Darwin
      Referrer     : 
      IP Address   : 111.222.333.444
      Username     : admin
      Classname    : vB_Database
      i am using vbulletin 3.6.12

      only about 50% pages that get that error messages, no matter its old pages or new pages , not sure what trigger that error

      maybe simillar problem with this https://www.vaultwiki.org/issues/2267/ , can you give quick fix?

      let me know if you need login details from pm
    Issue Details
    Issue Number 2361
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Wiki Pages
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 3.0.12
    Fixed Version 3.0.12
    Milestone (none)
    Software DependencyvBulletin 3.6
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. June 19, 2011 1:02 AM
      pegasus pegasus is offline
      VaultWiki Team
      Fixed in the current ZIP. In showwiki.php, find:
      Code:
      				" . (!VAULT_36X_COMPAT ? "thread.prefixid, " : "") . "thread.taglist,
      Replace with:
      Code:
      				" . (!VAULT_36X_COMPAT ? "thread.prefixid, thread.taglist, " : "") . "
      Reply Reply  
    2. June 26, 2011 12:42 PM
      basketmen basketmen is offline
      Junior Member
      thank you, its fixed this problem

      i've got another problem, just realize it :

      cant create new page, or edit other page, get this error message
      Code:
      Fatal error: Call to undefined function special_fetch_thread36x() in /home/username/public_html/vault/functions/automate.php on line 182
      can you give hotfix too please
      Reply Reply  
    3. June 26, 2011 2:48 PM
      pegasus pegasus is offline
      VaultWiki Team
      In vault/functions/automate.php, find:
      Code:
      	if (VAULT_36X_COMPAT)
      	{
      		// run fetch_threadinfo joins
      		require_once(DIR . '/vault/functions/36x.php');
      		$found = special_fetch_thread36x($threadid);
      	}
      	else
      	{
      		$found = fetch_threadinfo($threadid);
      	}
      Replace with:
      Code:
      	$found = fetch_threadinfo($threadid);
      Reply Reply  
    4. July 3, 2011 11:32 PM
      basketmen basketmen is offline
      Junior Member
      pegasus, i am sorry, just found out another problem, maybe related with above :

      Cant renaming/edit Title

      in edit page >> Title >> i change the title, and check list 'Do not create a redirect when renaming this page' option

      after that i redirected to new page, but the content just this :

      There is currently no text in this page.



      nb.
      - i already tried not to check list 'Do not create a redirect when renaming this page' option, but the result still same
      - there is no problem if i just edit the article content, only got problem when edit the title, cant edit title right now.



      Please give hotfix too if you can, Let me know if you need try live forum and login details
      Reply Reply  
    5. July 6, 2011 8:43 AM
      basketmen basketmen is offline
      Junior Member
      Quote Originally Posted by basketmen
      pegasus, i am sorry, just found out another problem, maybe related with above :

      Cant renaming/edit Title

      in edit page >> Title >> i change the title, and check list 'Do not create a redirect when renaming this page' option

      after that i redirected to new page, but the content just this :

      There is currently no text in this page.



      nb.
      - i already tried not to check list 'Do not create a redirect when renaming this page' option, but the result still same
      - there is no problem if i just edit the article content, only got problem when edit the title, cant edit title right now.



      Please give hotfix too if you can, Let me know if you need try live forum and login details

      up up, i am sorry pegasus, how is it, do you think it is because not using /vault/functions/36x.php file again like above post?

      please try it in your 3.6.x test forum, or i will give my forum login


      the problem right now, only not success renaming title, the text content not involved to the new page, just get 'There is currently no text in this page.' text like screenshot below
      Reply Reply  
    6. July 6, 2011 11:49 AM
      pegasus pegasus is offline
      VaultWiki Team
      I think this was because of another problem that is fixed in 3.0.13. Please update and let me know. The old title should still work if I'm right.
      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 9:33 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.