• 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
    • Database errors after upgrading to 3.0.2

    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: Database errors after upgrading to 3.0.2

    • Issue Tools
      • View Changes
    1. issueid=1888 August 4, 2010 3:34 AM
      ctrlbrk ctrlbrk is offline
      Junior Member
      Database errors after upgrading to 3.0.2

      vw 3.0.2
      vb 3.8.5

      I just had to disable VaultWiki. Upgraded from 3.0.0 to 3.0.2, but there were database errors viewing some (but not all?) forums.

      Code:
      Database error in vBulletin 3.8.5:
      
      Invalid SQL:
      
      			SELECT forumid, vopt.options AS vault_options
      			FROM post AS post
      			INNER JOIN thread AS thread ON (thread.threadid = post.threadid)
      			LEFT JOIN vault_options AS vopt ON (vopt.contentid = post.postid AND vopt.contenttypeid = 1)
      			WHERE post.threadid=145 AND post.visible=1
      			ORDER BY post.dateline 
      			LIMIT ,;
      
      MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
      Error Number  : 1064
      Mike
    Issue Details
    Issue Number 1888
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Non-Wiki Threads / Posts
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 3.0.2
    Fixed Version 3.0.3
    Milestone VaultWiki 3.0.5
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 4, 2010 3:38 AM
      ctrlbrk ctrlbrk is offline
      Junior Member
      More info, seems to only happen on the Print View showthread pages.

      Mike
      Reply Reply  
    2. August 4, 2010 12:17 PM
      pegasus pegasus is offline
      VaultWiki Team
      Do you have any other plugins at hook location printthread_start? If not, is there a modification that calls the parser on every page (perhaps in one of the parse_templates or global_* hooks, and runs even on printable thread pages)? I can only see this happening if there is a mod conflict that triggers the VaultWiki code BEFORE all the variables have been set.

      This might un-conflict it. In vault/plugins/bbcode.php, find:
      Code:
      	if (THIS_SCRIPT == 'printthread' AND $forumid == 'nonforum')
      Replace with:
      Code:
      	if (THIS_SCRIPT == 'printthread' AND $forumid == 'nonforum' AND $parser_class == 'vb_bbcodeparser_printablethread')
      Reply Reply  
    3. August 4, 2010 5:52 PM
      ctrlbrk ctrlbrk is offline
      Junior Member
      Pegasus,

      This seems to have fixed it, thank you. Can you confirm it will also be included automagically in the next build?

      I have no plugins at hook "printthread_start".

      Mike
      Reply Reply  
    4. August 5, 2010 12:54 AM
      pegasus pegasus is offline
      VaultWiki Team
      Yes, this will be included.
      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 12:07 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.