• 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
    • In line mode move thread error

    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: In line mode move thread error

    • Issue Tools
      • View Changes
    1. issueid=797 August 24, 2009 2:59 PM
      tommythejoat tommythejoat is offline
      Regular Member
      In line mode move thread error
      vBulletin says this is not their problem with bad sql since the string post.id does not exist

      This morning we started getting lots of database errors from moderators trying to move posts. The error screen is:

      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 (54035);
      
      MySQL Error   : Unknown column 'post.id' in 'where clause'
      Error Number  : 1054
      Request Date  : Monday, August 24th 2009 @ 12:51:58 PM
      Error Date    : Monday, August 24th 2009 @ 12:51:58 PM
      Script        : http://mb.nawcc.org/inlinemod.php?do=domovethreads&threadids=54035
      Referrer      : http://mb.nawcc.org/inlinemod.php?forumid=11
      IP Address    : 66.189.87.170
      Username      : TMcIntyre
      Classname     : vB_Database
      MySQL Version : 5.0.27-standard
      The WHERE post.id is the broken bit. Is there any possibility that Vault Wiki is involved here? I made no changes except to upgrage to 3.8.4 and 2.5.1.

      I can't find post.id in any vBulletin file.
    Issue Details
    Issue Number 797
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Inline Moderation
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 2.5.1
    Fixed Version 2.5.2
    Milestone VaultWiki 3.0.0
    Software DependencyAny
    Users able to reproduce bug 1
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 24, 2009 3:34 PM
      tommythejoat tommythejoat is offline
      Regular Member
      I cannot find the string post.id in any file on my system.

      I suspect there is a bad edit expression somewhere that got triggered by post.postid and "corrected" it to post.id.

      I have no idea how to go about finding this. Is the a standard regular expression that is used to find duplicate strings sequentially in text? If so, I could probably search for that.

      I do not think this is a vBulletin problem since it would have blown up the world for them. It happens on every attempt to move a post on my message board.
      Reply Reply  
    2. August 24, 2009 4:28 PM
      pegasus pegasus is offline
      VaultWiki Team
      This is a result of code in 2.5.1 that isn't included in the package, which baffles me, since we spent almost a week on this.

      The inlinemod_start plugin SHOULD read:
      Code:
      require_once(DIR . '/vault/special_plugins_inlinemod.php');
      
      if (
      	!empty($_POST['title']) AND
      	(
      		$_POST['do'] == 'domoveposts' OR
      		$_POST['do'] == 'docopyposts'
      	)
      )
      {
      	special_inlinemod_movestart();
      }
      
      $getforumids = ($_POST['do'] == 'domovethreads' OR $_POST['do'] == 'domergeposts');
      
      if (!empty($threadids))
      {
      	special_inlinemod_start($threadids, 'thread', $getforumids);
      }
      else if (!empty($postids))
      {
      	special_inlinemod_start($postids, 'post');
      }
      
      if ($getforumids)
      {
      	special_inlinemod_protect();
      }
      This is the SECOND plugin reported that was not updated in the ZIP even though we did make changes to it. This is probably due to the plugin system we use on our servers, where the database is not automatically updated after a change is made (our plugins are stored in the file system). I have updated the instructions we use for compiling the ZIP, so we don't overlook this possibility in the future.
      Reply Reply  
    3. August 24, 2009 7:03 PM
      tommythejoat tommythejoat is offline
      Regular Member
      Thanks for the quick response. This one was a little painful since our moderators do not delete posts but move them to a quarantine area.
      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 7:24 PM.
    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.