• 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 4.x Series
    • Bug
    • "Unknown column 'vw_options' in 'field list'"

    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: "Unknown column 'vw_options' in 'field list'"

    • Issue Tools
      • View Changes
    1. issueid=2956 March 15, 2013 4:12 PM
      Dark Pulse Dark Pulse is offline
      New Member
      "Unknown column 'vw_options' in 'field list'"
      Attempting a clean install...

      Just purchased VaultWiki and am attempting to do an install of 4.0.0 Alpha 1 on vBulletin 4.2.0, but it showstops on Step 3 while trying to edit the BBCode table.

      Code:
      Step 3
      
      Adding data to table: bbcode
      
      Warning: mysqli_query(): (42S22/1054): Unknown column 'vw_options' in 'field list' in [path]/includes/class_core.php on line 1391[/QUOTE]
      It is slightly (ever so slightly) possible that this is related to a just-fixed bug. Specifically, this one, as I think my forum uses no Prefix stuff.
    Issue Details
    Issue Number 2956
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Alpha 1 Depot
    Fixed Version 4.0.0 Alpha 1
    Milestone VaultWiki 4 Alpha 1
    Software DependencyAny
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. March 15, 2013 4:19 PM
      pegasus pegasus is offline
      VaultWiki Team
      It seems that the Install_DB_Alter controller may not be loading its children properly. You can bear with me while I setup a new test to run a fresh install and debug the issue, you can opt for a complimentary Install Service (no charge), or if you have some technical ability, you can look in vault/core/controller/install/db/alter's children and apply the changes to the database manually (it's 2 columns total).
      Reply Reply  
    2. March 15, 2013 4:25 PM
      Dark Pulse Dark Pulse is offline
      New Member
      If you can tell me what files and what to edit, I'm comfortable editing them, reuploading them, and retrying.

      Should I uninstall before I retry, or would it just work to re-try the install, as Steps 1 and 2 were successful.
      Reply Reply  
    3. March 15, 2013 4:48 PM
      pegasus pegasus is offline
      VaultWiki Team
      It will take a bit to debug this, so run the following queries on your database. You don't need to uninstall before retrying.

      Code:
      ALTER TABLE bbcode ADD COLUMN vw_options INT(10) UNSIGNED NOT NULL DEFAULT '0';
      ALTER TABLE session ADD COLUMN vw_location VARCHAR(255) NOT NULL DEFAULT '';
      Reply Reply  
    4. March 15, 2013 4:56 PM
      Dark Pulse Dark Pulse is offline
      New Member
      Altered the tables and retried. Got a little further, but then it bombed out with something else.

      Code:
      Adding data to table: bbcode
      Adding data to table: vw_nodetype
      Adding data to table: product
      Adding data to table: productcode
      Adding data to table: productdependency
      Fatal error: Call to undefined method vw_URL_Model_vB3::form_path() in /[...]/vault/core/model/url/vw.php on line 113
      Reply Reply  
    5. March 15, 2013 5:04 PM
      pegasus pegasus is offline
      VaultWiki Team
      line 113, where it says 'form_path' should be 'forum_path'

      As for the Alter not working, got it sorted. vault/core/controller/install/db/alter/vw.php, has:
      Code:
      $this->values
      Should be:
      Code:
      $this->fields
      Weird that the warning for the invalid foreach wasn't showing for you though.
      Reply Reply  
    6. March 15, 2013 5:18 PM
      Dark Pulse Dark Pulse is offline
      New Member
      Edited files, reuploaded, retried. Step 3 is now passed, but it now fatals on Step 10. As that is separate from Step 3, however, I will open another topic on it.
      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 8:40 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 © 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.