• 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 error after upgrading to 2.3.1

    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 error after upgrading to 2.3.1

    • Issue Tools
      • View Changes
    1. issueid=630 June 7, 2009 11:35 AM
      mickknutson mickknutson is offline
      Regular Member
      database error after upgrading to 2.3.1

      I got this error immediately after upgrade:

      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      
                             SELECT IF(visible = 2, 1, 0) AS isdeleted,
      
      
      
                             thread.*
      
                             , article.*, thread.threadid,
             commenter.usergroupid AS lastusergroupid,
             commenter.membergroupids AS lastmembergroupids,
             commenter.homepage AS lasthomepage, commenter.email AS lastemail,
             IF(commenter.displaygroupid > 0, commenter.displaygroupid, commenter.usergroupid) AS lastdisplaygroupid,
             protected.options AS protection
                             FROM thread AS thread
      
      
      
      
      
      
             LEFT JOIN vault_article AS article ON (thread.threadid = article.threadid)
      LEFT JOIN user AS commenter ON (article.lastposterid = commenter.userid)
      LEFT JOIN vault_protect AS protected ON (protected.targetid = 0)
                             WHERE thread.threadid = 19496;
      
      MySQL Error   : Unknown column 'protected.targetid' in 'on clause'
      Error Number  : 1054
      Request Date  : Sunday, June 7th 2009 @ 08:28:38 AM
      Error Date    : Sunday, June 7th 2009 @ 08:28:38 AM
      Script        : http://www.blincmagazine.com/forum/39138-post1.html
      Referrer      :
      IP Address    : 74.6.22.121
      Username      : Unregistered
      Classname     : vB_Database
      MySQL Version :
    Issue Details
    Issue Number 630
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Wiki Pages
    Status Not a Bug
    Priority 2 - Fatal / Database Errors
    Affected Version 2.3.1
    Fixed Version (none)
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. June 7, 2009 12:50 PM
      pegasus pegasus is offline
      VaultWiki Team
      Did you have any problems running the upgrade script? That column is added in the first step of the upgrade.
      Reply Reply  
    2. June 7, 2009 1:07 PM
      mickknutson mickknutson is offline
      Regular Member
      Quote Originally Posted by pegasus View Post
      Did you have any problems running the upgrade script? That column is added in the first step of the upgrade.
      No. It went pretty smooth without any errors on the screen. That DB error was emailed to me via vBulletin
      Reply Reply  
    3. June 7, 2009 1:58 PM
      pegasus pegasus is offline
      VaultWiki Team
      If you don't get it while visiting articles now (should happen for every article), it's possible someone had visited one during the upgrade, before the database changes were made. In that case, the error can be ignored.
      Reply Reply  
    4. June 7, 2009 2:17 PM
      mickknutson mickknutson is offline
      Regular Member
      Quote Originally Posted by pegasus View Post
      If you don't get it while visiting articles now (should happen for every article), it's possible someone had visited one during the upgrade, before the database changes were made. In that case, the error can be ignored.
      That is a possibility. I did NOT turn the site off while performing the upgrade, and I have not gotten another one since.
      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 11:17 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.