• 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
    • Upgrade fails with new version from some earlier version, same problem

    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: Upgrade fails with new version from some earlier version, same problem

    • Issue Tools
      • View Changes
    1. issueid=4489 December 25, 2015 8:10 PM
      boldplan boldplan is offline
      New Member
      Upgrade fails with new version from some earlier version, same problem
      You'll see below, same issue

      I fortunately can uninstall and install, but this was my failed upgrade using the latest build:
      Code:
      Step 19
      
      Importing BB-Codes
      An exception occurred: Database Error: SELECT bb_code_id AS `tag`,vw_varname FROM `xf_bb_code` WHERE ( `bb_code_id` LIKE 'autolink%' OR `bb_code_id` LIKE 'bookindex%' OR `bb_code_id` LIKE 'category%' OR `bb_code_id` LIKE 'char%' OR `bb_code_id` LIKE 'comment%' OR `bb_code_id` LIKE 'div%' OR `bb_code_id` LIKE 'file%' OR `bb_code_id` LIKE 'footnote%' OR `bb_code_id` LIKE 'forumindex%' OR `bb_code_id` LIKE 'gallery%' OR `bb_code_id` LIKE 'h%' OR `bb_code_id` LIKE 'hr%' OR `bb_code_id` LIKE 'if%' OR `bb_code_id` LIKE 'includeonly%' OR `bb_code_id` LIKE 'noedit%' OR `bb_code_id` LIKE 'noinclude%' OR `bb_code_id` LIKE 'nostate%' OR `bb_code_id` LIKE 'onlyinclude%' OR `bb_code_id` LIKE 'reflist%' OR `bb_code_id` LIKE 'showthreads%' OR `bb_code_id` LIKE 'span%' OR `bb_code_id` LIKE 'table%' OR `bb_code_id` LIKE 'template%' OR `bb_code_id` LIKE 'toc%' OR `bb_code_id` LIKE 'var%' OR `bb_code_id` LIKE 'widget%' OR `bb_code_id` LIKE 'Wiki%' ) Mysqli prepare error: Unknown column 'vw_varname' in 'field list' in /home/mysite/public_html/vault/core/controller/db/xf.php on line 171
      vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 185
      vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 29
      vw_DB_MySQL_Model->select() in vault/core/controller/install/common/vw.php at line 212
      vw_Install_Common_Controller->do_bbcode() in vault/core/controller/install/full/steps/xf.php at line 613
      vw_Install_Full_Steps_Controller_XF->{closure}() in vault/core/controller/progress/vw.php at line 100
      vw_Progress_Controller->call() in vault/core/controller/cp/progress/vw.php at line 45
      vw_CP_Progress_Controller->process() in vault/core/controller/cp/install/vw.php at line 236
      vw_CP_Install_Controller->install() in vault/core/controller/cp/install/vw.php at line 64
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 351
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
    Issue Details
    Issue Number 4489
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.8
    Fixed Version 4.0.9
    Milestone (none)
    Software DependencyAny
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users pegasus
    Tags major, upgrade




    1. December 25, 2015 8:34 PM
      boldplan boldplan is offline
      New Member
      I stand corrected. Can't uninstall and reinstall. Now have a version "0" in the listed apps.
      Code:
      Fatal error: Call to undefined method vw_DBalter_Controller::fetch_table() in /home/mysite/public_html/vault/core/controller/uninstall/xf.php on line 29
      I'll try to upload an earlier group of files and uninstall from those and then reinstall the big one.
      Reply Reply
    2. December 25, 2015 8:44 PM
      boldplan boldplan is offline
      New Member
      By renaming all the tables, it seems I was able to reinstall and shall now remove all of them. Either way, we're now up to date and rolling with the latest version. Looks like I'll have to pay for an update soon. Great work as always on this incredible addon - thank you. Happy holidays.
      Reply Reply
    3. December 26, 2015 12:13 PM
      pegasus pegasus is offline
      VaultWiki Team
      You say this is the "same issue" as before, but I can't find another post you made about it.

      Judging by your replies, you will have to run the following query against your reinstalled database:
      Code:
      ALTER TABLE vw_lastupdate
      ADD COLUMN lastitemid INT(10) UNSIGNED NOT NULL DEFAULT '0',
      ADD INDEX last_item (lastitemid, lasttypeid)
      Reply Reply
    4. February 26, 2016 8:23 PM
      pegasus pegasus is offline
      VaultWiki Team
      I think what was happening here was that the upgrade-log was using a step counter from an old version for a new version, resulting in some important upgrade steps being skipped because the step counter suggested they were completed already.

      Since this could affect an upgrade between any two versions, the possible bad step counter values are numerous, and it is impossible to try to guess which steps were skipped and re-execute them. If any customers have an issue where some tables or columns are illogically missing, then it was likely due to this issue. You have two choices for repair:
      • Submit a Support Ticket so that we can investigate the database integrity and repair any damage we find; OR
      • Re-install VaultWiki (this will result in loss of all existing wiki data).


      This bug is fixed in the upgrade script for 4.0.9, but there might still be damage from previous partial upgrades.
      Reply Reply
    5. February 28, 2016 12:21 PM
      pegasus pegasus is offline
      VaultWiki Team
      Refactored the progress-related scripts (import, install, upgrade) in 4.0.9 to prevent a related issue where multiple old versions that were only upgraded partly could force re-execution of platform-specific steps from those versions (which could lead to corruption). The refactor should ensure that progress is only counted towards the related versions without also ignoring progress on other steps that occur under specific platform versions.

      An added bonus is that the design of the progress scripts is now easier for a human to understand.
      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 2:49 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.