Issue: Error when upgrading from 4.0.22 to 4.1.0 beta 4 on XF 2.1.4

Issue Tools
- View Changes

October 28, 2019 3:51 PM

dvsDave

Regular Member

Error when upgrading from 4.0.22 to 4.1.0 beta 4 on XF 2.1.4

Install error, won't progress past 4.0.22

Getting some oddball errors when migrating from XF 1.5 to 2.1. I downlaoded VW 4.1.0 beta 4

closed Vaultwiki, upgraded XF1.5 to 2.1.4, then used the archive uploader to load VW. It went through the upgrade process, and got hung up on 4.0.22

It throws an error when trying to upgrade past 4.0.22

Code:

ErrorException: Illegal string offset 'field' in src/addons/vw/vw/_core/instance/dbalter/mysql/vw.php at line 143
vw\vw\Setup\View->handle_php_error() in src/addons/vw/vw/_core/instance/dbalter/mysql/vw.php at line 143
vw_DBalter_MySQL_Instance->create_table() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/0/alpha/1/base/vw.php at line 1126
vw_Install_UpgradePath_Steps_410alpha1_base_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

Issue Details

Issue Number 5913

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 Beta 4

Fixed Version 4.1.0 Beta 4

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 1

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 29, 2019 12:00 PM

ACL

Regular Member

Confirmed at my end also, while upgrading my public site (XF1.5) from VW4.0 to VW4.1.0 Beta 4 b003.

Upgrading to 4.1.0 Alpha 1
...
Step 25
Creating table: vw_langevent
Creating table: vw_langeventitem

Code:

An exception occurred: Illegal string offset 'field' in [vw-core]/instance/dbalter/mysql/vw.php on line 143

    #0: vw_CP_Progress_View->handle_php_error() in [vw-core]/instance/dbalter/mysql/vw.php at line 143
    #1: vw_DBalter_MySQL_Instance->create_table() in [vw-platform]/library/vw/_install/lib/upgradepath/steps/4/1/0/alpha/1/base/vw.php at line 1126
    #2: vw_Install_UpgradePath_Steps_410alpha1_base_Controller->{closure}() in [vw-core]/controller/progress/steps/vw.php at line 85
    #3: vw_Progress_Steps_Controller->call() in [vw-core]/controller/progress/steps/vw.php at line 56
    #4: vw_Progress_Steps_Controller->execute() in [vw-platform]/library/vw/_install/lib/upgradepath/vw.php at line 78
    #5: vw_Install_UpgradePath_Controller->exec_script() in [vw-core]/controller/progress/vw.php at line 169
    #6: vw_Progress_Controller->execute() in [vw-core]/view/response/progress/vw.php at line 25
    #7: vw_Response_Progress_View->stream() in [vw-core]/view/response/progress/vw.php at line 61
    #8: vw_Response_Progress_View->render() in [vw-platform]/library/vw/XenForo/ViewAdmin.php at line 67
    #9: vw_XenForo_ViewAdmin->renderRaw() in [vw-platform]/library/XenForo/ViewRenderer/Abstract.php at line 229
    #10: XenForo_ViewRenderer_Abstract->renderViewObject() in [vw-platform]/library/XenForo/ViewRenderer/Raw.php at line 53
    #11: XenForo_ViewRenderer_Raw->renderView() in [vw-platform]/library/XenForo/FrontController.php at line 624
    #12: XenForo_FrontController->renderView() in [vw-platform]/library/XenForo/FrontController.php at line 176
    #13: XenForo_FrontController->run() in [vw-platform]/admin.php at line 13

I tried upgrading again from VW4.0 using an older version VW4.1.0 Beta 3 b003, and this time the upgrade in XF1.5 completed.

October 29, 2019 12:07 PM

pegasus

VaultWiki Team

Fixed in the current build. In src/addons/vw/vw/_core/instance/dbalter/mysql/vw.php, find:

Code:

							foreach ($indexinfo['fields'] AS $inner)
							{
								$name .= ($name ? '_' : '') . (isset($inner['name']) ? $inner['name'] : $inner['field']);
							}

Replace with:

Code:

							foreach ($indexinfo['fields'] AS $inner)
							{
								if (is_array($inner))
								{
									$name .= ($name ? '_' : '') . (isset($inner['name']) ? $inner['name'] : $inner['field']);
								}
								else
								{
									$name .= ($name ? '_' : '') . $inner;
								}
							}

October 29, 2019 1:18 PM

dvsDave

Regular Member

Got further this time, then got another error:

Code:

InvalidArgumentException: Unknown column vw_varname on XF:BbCode in src/XF/Mvc/Entity/Finder.php at line 1569
XF\Mvc\Entity\Finder->resolveFieldToTableAndColumn() in src/XF/Mvc/Entity/Finder.php at line 595
XF\Mvc\Entity\Finder->columnSqlName() in src/XF/Mvc/Entity/Finder.php at line 267
XF\Mvc\Entity\Finder->buildCondition() in src/XF/Mvc/Entity/Finder.php at line 132
XF\Mvc\Entity\Finder->where() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/0/beta/4/C/xf2.php at line 177
vw_Install_UpgradePath_Steps_410beta4_C_Controller_XF2->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

October 29, 2019 1:51 PM

pegasus

VaultWiki Team

This occurs when upgrading to 4.1.0 Beta 4 on XenForo 2 directly from an earlier version on XenForo 1 (as opposed to the same version on XenForo 1).

In src/addons/vw/vw/_install/upgradepath/steps/4/1/0/beta/4/C/xf2.php, find:

Code:

$bbcodes = $finder->where('vw_varname', 'like', $finder->escapeLike('vwp_', '?%'))->fetch();

Replace with:

Code:

			$test = XF::app()->em()->create('XF:BbCode');
			$bbcodes = array();

			if ($test->isValidColumn('vw_varname'))
			{
				$bbcodes = $finder->where('vw_varname', 'like', $finder->escapeLike('vwp_', '?%'))->fetch();
			}

October 29, 2019 2:02 PM

dvsDave

Regular Member

I found that file in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/0/beta/4/C/

is that correct? I just want to be sure before I edit it.

Reply
October 29, 2019 2:40 PM

pegasus

VaultWiki Team

Yes that's correct. Updated instructions above.

Reply
October 29, 2019 9:09 PM

dvsDave

Regular Member

That did the trick! I was able to finish upgrading and get it running!

Reply

+ Reply

All times are GMT -4. The time now is 11:23 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: Error when upgrading from 4.0.22 to 4.1.0 beta 4 on XF 2.1.4

Issue Tools