Issue: Upgrade fails with new version from some earlier version, same problem

Issue Tools
- View Changes

December 25, 2015 8:10 PM

boldplan

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

December 25, 2015 8:34 PM
boldplan

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
December 25, 2015 8:44 PM

boldplan

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
December 26, 2015 12:13 PM
pegasus

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
February 26, 2016 8:23 PM
pegasus

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
February 28, 2016 12:21 PM

pegasus

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

All times are GMT -4. The time now is 10:13 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

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Upgrade fails with new version from some earlier version, same problem

Issue Tools