• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
      • Try XenForo Demo
      • New Posts
      • FAQ
      • Calendar
      • Community
        • Groups
        • Albums
        • Member List
      • Forum Actions
        • Mark Forums Read
      • Quick Links
        • Today's Posts
        • Who's Online
      • Sponsor
        • Sponsor a Feature
        • List of Donors
    • Wiki
    • Support
    • What's New?
    • Buy Now
    • Manual
    • 
    • Forum
    • VaultWiki How-Tos
    • VaultWiki Questions
    • MySQL Error when trying to use Books

    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.

    Results 1 to 4 of 4

    Thread: MySQL Error when trying to use Books

    • Thread Tools
      • Show Printable Version
    1. August 30, 2008 #1
      Home Alone
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Home Alone is offline
      Junior Member
      Join Date
      August 29, 2008
      Posts
      15
      Rep Power
      215

      MySQL Error when trying to use Books

      Code:
      Database error in vBulletin 3.7.0:
      
      Invalid SQL:
      
      		SELECT visible, forumid, thread.threadid, title, open, postuserid, dateline,
      			article.protection, thread.namespaceid, MAX(chapternumber) AS chaptercount
      		FROM thread AS thread
      		LEFT JOIN vault_article AS article ON (article.threadid = thread.threadid)
      		LEFT JOIN vault_book AS chapter ON (chapter.bookid = thread.threadid)
      		WHERE thread.threadid IN (135151)
      			
      		GROUP BY thread.threadid
      		ORDER BY title ASC
      		LIMIT 0,50;
      
      MySQL Error   : Unknown column 'article.protection' in 'field list'
      Error Number  : 1054
      Reply With Quote Reply With Quote

    2. August 30, 2008 #2
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,959
      Blog Entries
      18
      Rep Power
      687
      Did you upgrade from the Lite version by any chance?
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    3. August 30, 2008 #3
      Home Alone
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Home Alone is offline
      Junior Member
      Join Date
      August 29, 2008
      Posts
      15
      Rep Power
      215
      Quote Originally Posted by pegasus View Post
      Did you upgrade from the Lite version by any chance?
      I uninstalled the Lite version, then installed the full version.
      Reply With Quote Reply With Quote

    4. August 30, 2008 #4
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,959
      Blog Entries
      18
      Rep Power
      687
      Okay, there is a (suppressed) MySQL error when uninstalling Lite. Simply upgrading avoids this issue.

      As a result of the botched uninstall, the vault_article table was not removed, so when it later attempted to create the table on a new install, it failed, and any new columns in that step were not added. I'm going to update the Lite uninstaller at vB.org, but you are going to have to run the following SQL queries on your database:

      Code:
      ALTER TABLE " . TABLE_PREFIX . "vault_link
      ADD COLUMN templateusage INT(1) UNSIGNED NOT NULL DEFAULT '0'
      Code:
      ALTER TABLE " . TABLE_PREFIX . "vault_article
      ADD COLUMN bookid INT(11) UNSIGNED NOT NULL DEFAULT '0',
      ADD COLUMN protection INT(11) UNSIGNED NOT NULL DEFAULT '0',
      ADD INDEX bookid (bookid)
      Replacing the " . TABLE_PREFIX . " bits to match your setup.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    Similar Threads

    1. MySQL 5.5?
      By Alfa1 in forum VaultWiki Questions
      Replies: 4
      Last Post: May 19, 2011, 1:54 PM
    2. Books
      By Praetor1 in forum VaultWiki Questions
      Replies: 4
      Last Post: August 31, 2010, 3:38 PM
    3. WHen I turn VW on, articles and threads give me MYSQL errors
      By gosborne in forum VaultWiki Questions
      Replies: 1
      Last Post: May 11, 2010, 12:16 PM
    4. Strange MYSQL error after installing Wikiw
      By jwocky in forum VaultWiki Questions
      Replies: 4
      Last Post: June 18, 2009, 11:57 AM
    5. MySQL Error
      By HellRazor in forum VaultWiki Questions
      Replies: 2
      Last Post: August 31, 2008, 9:51 PM

    Tags for this Thread

    able, any, are, books, but, columns, did, error, field, forumid, from, going, have, here, know, mysql, new, own, protection, quote, that, the, there, this, trying, use, was, were, when, you, your

    View Tag Cloud

    Bookmarks

    Bookmarks
    • Submit to Digg Digg
    • Submit to del.icio.us del.icio.us
    • Submit to StumbleUpon StumbleUpon
    • Submit to Google Google

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  
    • BB code is On
    • Smilies are On
    • [IMG] code is Off
    • [VIDEO] code is
    • HTML code is Off

    Forum Rules

    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 2:53 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 © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.