Issue: Upgrade Bug

Issue Tools
- View Changes

August 22, 2014 10:07 PM

dvsDave

Regular Member

Upgrade Bug

mysqli error in gamma 5, stage 3 (creating_system_area)

Upgrading from 4.0.0 Gamma 3 to current (4.0.0rc2) , getting an error during upgrade:

Code:

Upgrading to 4.0.0 Gamma 5
Step 3

creating_system_area
An exception occurred: Database Error: UPDATE `vw_revision` SET `ip_id` = 525849 WHERE revisionid = 35927 Mysqli prepare error: Unknown column 'ip_id' in 'field list' in /home/control/public_html/vault/core/controller/db/xf.php on line 136
vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 122
vw_DB_Controller_XF->query_write() in vault/core/model/db/mysql/vw.php at line 893
vw_DB_MySQL_Model->shutdown_or_run() in vault/core/model/db/mysql/vw.php at line 662
vw_DB_MySQL_Model->update() in library/vw/XenForo/DataWriter.php at line 394
vw_XenForo_DataWriter->log_ip() in vault/core/controller/dm/revision/vw.php at line 144
vw_DM_Revision_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 412
vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 378
vw_DM_Controller_XF->save() in vault/core/controller/dm/page/vw.php at line 1503
vw_DM_Page_Controller->save_revision() in vault/core/controller/dm/page/vw.php at line 1265
vw_DM_Page_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 412
vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 378
vw_DM_Controller_XF->save() in vault/core/controller/dm/area/vw.php at line 381
vw_DM_Area_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 412
vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 378
vw_DM_Controller_XF->save() in vault/core/controller/install/upgradepath/steps/4/0/0/gamma/5/base/vw.php at line 165
vw_Install_UpgradePath_Steps_400gamma5_base_Controller->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 299
vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 264
vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 201
vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 71
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 142
vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13

Issue Details

Issue Number 3940

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 5

Fixed Version 4.0.0 RC 2

Milestone VaultWiki 4.0 Gold

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)

August 23, 2014 10:17 AM

pegasus

VaultWiki Team

The upgrader is using a DataWriter from the current version (RC2) to create something in an earlier version (Gamma 4). This is not possible in this case because the field vw_revision.ip_id does not exist until a later version (Gamma 6).

In library/vw/XenForo/DataWriter.php, find:

Code:

		$idfield = $this->controller->node['idfield'];
		$contentType = 'vw' . strtolower($this->controller->node['accesskey']);

		$ipaddress = $this->controller->instance->get('ipaddress');
		$ipaddress = vw_Hard_Core::model('IP')->format($ipaddress);

Add before:

Code:

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

		if (vw_Hard_Core::model('Version')->compare($version, '4.0.0 Gamma 6') == -1)
		{
			return;
		}

August 23, 2014 10:49 PM

dvsDave

Regular Member

That did the trick!

Reply

+ Reply

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

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

Issue: Upgrade Bug

Issue Tools