Issue: Unknown column 'permission_hash' in 'field list' - error upgrading from RC 5 to latest

Issue Tools
- View Changes

October 6, 2016 3:36 PM

Vilandra

New Member

Unknown column 'permission_hash' in 'field list' - error upgrading from RC 5 to latest

Trying to upgrade from RC 5 to 4.0.14 b2, and I get this error at 12%:

Code:

Upgrading to 4.0.1
Step 11

Updating data in table: vw_route
An exception occurred: Database Error: UPDATE `vw_usercount` SET `permission_hash` = '05648e30c8a06f1370b71a1d552d937c' WHERE userid = 1 LIMIT 1 Mysqli prepare error: Unknown column 'permission_hash' in 'field list' in [path]/vault/core/controller/db/xf.php on line 173
#0: vw_DB_Controller_XF->throw_error() in [path]/vault/core/controller/db/xf.php at line 157
#1: vw_DB_Controller_XF->query_write() in [path]/vault/core/model/db/mysql/vw.php at line 1099
#2: vw_DB_MySQL_Model->shutdown_or_run() in [path]/vault/core/model/db/mysql/vw.php at line 762
#3: vw_DB_MySQL_Model->update() in [path]/vault/core/model/permissions/vw.php at line 297
#4: vw_Permissions_Model->get_from_db() in [path]/vault/core/model/permissions/vw.php at line 218
#5: vw_Permissions_Model->pre_cache() in [path]/vault/core/controller/fetch/base/vw.php at line 106
#6: vw_Fetch_Base_Controller->cache_items() in [path]/vault/core/controller/fetch/page/vw.php at line 454
#7: vw_Fetch_Page_Controller->cache_items() in [path]/vault/install/lib/upgradepath/steps/4/0/1/base/vw.php at line 516
#8: vw_Install_UpgradePath_Steps_401_base_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#9: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#10: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/upgradepath/vw.php at line 60
#11: vw_Install_UpgradePath_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#12: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 34
#13: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 275
#14: vw_CP_Install_Controller->upgrade() in [path]/vault/core/controller/cp/install/vw.php at line 57
#15: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
#16: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
#17: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 351
#18: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#19: XenForo_FrontController->run() in [path]/admin.php at line 13

Any help greatly appreciated!

Issue Details

Issue Number 4725

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.14

Fixed Version 4.0.15

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 6, 2016 4:02 PM

pegasus

VaultWiki Team

In vault/core/model/permissions/vw.php, find:

Code:

if (!$debug AND count($hashable))

Before it, add:

Code:

		$version = vw_Hard_Core::model('Settings')->get('vw_version_string');

		if (vw_Hard_Core::model('Version')->compare($version, '4.0.10') == -1)
		{
			$hashable = array();
		}

October 6, 2016 4:15 PM

Vilandra

New Member

That fixed that error, but at 89% I get:

Finalizing
Step 6

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 [path]/vault/core/controller/db/xf.php on line 173
#0: vw_DB_Controller_XF->throw_error() in [path]/vault/core/controller/db/xf.php at line 189
#1: vw_DB_Controller_XF->query_read() in [path]/vault/core/model/db/mysql/vw.php at line 27
#2: vw_DB_MySQL_Model->select() in [path]/vault/install/lib/common/vw.php at line 228
#3: vw_Install_Common_Controller->do_bbcode() in [path]/vault/install/lib/upgradepath/steps/final/xf.php at line 92
#4: vw_Install_UpgradePath_Steps_Final_Controller_XF->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#5: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#6: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/upgradepath/vw.php at line 60
#7: vw_Install_UpgradePath_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#8: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 34
#9: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 275
#10: vw_CP_Install_Controller->upgrade() in [path]/vault/core/controller/cp/install/vw.php at line 57
#11: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
#12: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
#13: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 351
#14: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#15: XenForo_FrontController->run() in [path]/admin.php at line 13

Reply
October 6, 2016 4:40 PM

pegasus

VaultWiki Team

For this to occur in the current version of the upgrader, it looks like a major part of the upgrade was logged as completed even though it was not performed. Please submit a private ticket so we can find the cause and manually fix the database: https://www.vaultwiki.org/members/?do=tickets

Reply
October 6, 2016 6:04 PM

pegasus

VaultWiki Team

Fixed. There was a problem upgrading VaultWiki if it was originally installed on XenForo 1.2 prior to VaultWiki 4.0.6. The upgrade system wasn't correctly detecting the XenForo version change.

Reply
October 6, 2016 6:11 PM

Vilandra

New Member

Thank you so much for fixing this, and so quickly!

Reply

+ Reply

All times are GMT -4. The time now is 4:52 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: Unknown column 'permission_hash' in 'field list' - error upgrading from RC 5 to latest

Issue Tools