• 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
    • Fatal DB Error causing inability to move threads/forums

    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: Fatal DB Error causing inability to move threads/forums

    • Issue Tools
      • View Changes
    1. issueid=802 August 27, 2009 12:15 AM
      Badorties Badorties is offline
      New Member
      Fatal DB Error causing inability to move threads/forums

      After installing vaultwiki i am now unable to move threads from forum to forum, regardless of whether the thread/forum is a part of the wiki. if i disable vaultwiki it works. when attempting to move threads i receive the following error
      Code:
      Database error in vBulletin 3.8.4:
      
      Invalid SQL:
      
      SELECT postid, thread.threadid, firstpostid
      
      FROM post AS post
      LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
      WHERE post.id IN (70);
      
      MySQL Error : Unknown column 'post.id' in 'where clause'
      Error Number : 1054
      Request Date : Wednesday, August 26th 2009 @ 08:35:25 PM
      Error Date : Wednesday, August 26th 2009 @ 08:35:25 PM
      Script : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
      Referrer : http://majorcommand.com/boards/postings.php?t=75&pollid=
      IP Address : 99.252.200.243
      Username : Badorties
      Classname : vB_Database_MySQLi
      MySQL Version : 5.0.22
      if it helps, i have vaultwiki as well as categories installed.
    Issue Details
    Issue Number 802
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Inline Moderation
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 2.5.1
    Fixed Version 2.5.2
    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. August 27, 2009 1:01 AM
      pegasus pegasus is offline
      VaultWiki Team
      Duplicate of: http://www.crackedeggstudios.com/issues/797/
      Reply Reply  
    2. August 27, 2009 2:18 AM
      Badorties Badorties is offline
      New Member
      noticeably different is the calling script, this one being postings.php, whereas 797 references inlinemod.php. not sure if the fix action is correct however, as i cant locate the inlinemod_start plugin you reference
      Reply Reply  
    3. August 27, 2009 7:39 AM
      pegasus pegasus is offline
      VaultWiki Team
      You're right. While the cause of the bug is the same, because it occurs on a different page the fix is going to be different. In AdminCP > Plugins & Products > Plugin Manager, locate the plugin for product "CES VaultWiki" at hook location "threadmanage_start", and click "Edit".

      The correct code is:
      Code:
      $getforumids = ($_POST['do'] == 'domovethread');
      
      require_once(DIR . '/vault/special_plugins_inlinemod.php');
      special_inlinemod_start($threadinfo['threadid'], 'thread', $getforumids);
      
      if ($getforumids)
      {
      	special_inlinemod_protect();
      }
      Reply Reply  
    4. August 27, 2009 10:44 AM
      tommythejoat tommythejoat is offline
      Regular Member
      I just bumped into this one also. I came to report the bug, but found the fix and installed it.

      It works fine, but are there any other move/copy option locations that are going to bite us?
      Reply Reply  
    5. August 27, 2009 3:55 PM
      pegasus pegasus is offline
      VaultWiki Team
      There were a number of plugins that were modified in 2.5.1 but that were never added to the package due to our server's sync issue described in the other thread. At this time, I'm not aware of any other locations that were changed that would now result in "fatal" errors.
      Reply Reply  
    6. August 27, 2009 4:03 PM
      Badorties Badorties is offline
      New Member
      this brought a new bug for me, the move actually works but throws another fatal error

      Code:
      Database error in vBulletin 3.8.4:
      
      Invalid SQL:
      
      		SELECT bookid, threadid
      		FROM vault_book
      		WHERE top_bookid IN (75);
      
      MySQL Error   : Unknown column 'top_bookid' in 'where clause'
      Error Number  : 1054
      Request Date  : Thursday, August 27th 2009 @ 01:01:26 PM
      Error Date    : Thursday, August 27th 2009 @ 01:01:26 PM
      Script        : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
      Referrer      : http://majorcommand.com/boards/postings.php?t=75&pollid=
      IP Address    : 67.172.167.177
      Username      : na641
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.0.22
      Reply Reply  
    7. August 27, 2009 4:18 PM
      pegasus pegasus is offline
      VaultWiki Team
      I have checked and this column is added by both the install script and the upgrade script, so this seems almost impossible to me (unless the upgrade script didn't successfully run step 1 from 2.5.0 to 2.5.1).

      You can add this field manually by running the following database query:
      Code:
      ALTER TABLE vault_book
      ADD COLUMN top_bookid INT(10) UNSIGNED NOT NULL DEFAULT '0',
      ADD INDEX top_bookid (top_bookid)
      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:29 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.