[4.1 Alpha 2] Upgrade: SQL error with vw_integrate: unknown column 'adminset'
Upgrading VaultWiki 4.1 Alpha 1 to Alpha 2 on XenForo 2.0:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'adminset' in 'where clause' src/XF/Db/AbstractStatement.php:212
Code:
UPDATE `vw_integrate` SET `position` = 'forumbit' WHERE adminset = 1 AND 0 <= integrateid ORDER BY integrateid ASC LIMIT 10000
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(117): XF\Db\AbstractAdapter->query('UPDATE `vw_int...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(1330): vw_DB_Controller_XF2->query_write('UPDATE `vw_int...')
#6 src/addons/vw/vw/_core/model/db/mysql/vw.php(974): vw_DB_MySQL_Model->shutdown_or_run('UPDATE `vw_int...', false)
#7 src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/0/alpha/1/base/vw.php(1276): vw_DB_MySQL_Model->update(Array)
#8 src/addons/vw/vw/Setup.php(260): vw_Install_UpgradePath_Steps_410alpha1_base_Controller->{closure}(Object(vw\vw\Setup\Caller\Upgrade), false)
#9 src/addons/vw/vw/Setup.php(870): vw\vw\Setup->vwRunStep('upgrade', Object(vw_Install_UpgradePath_Steps_410alpha2_C_Controller_XF2), Array, 24)
#10 src/XF/Admin/Controller/AddOn.php(452): vw\vw\Setup->upgrade(Array)
#11 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#15 src/XF.php(333): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}
The request state suggests this occurred during step 26:
Code:
["params"] => string(32) "{"step":26,"version_id":4010012}"
However, the last step written to the upgrade log file is step 24:
Code:
== Upgrading to 4.1.0 Alpha 2 ==
== Step 23 (0) ==
Altering table: vw_integrate
== Upgrading to 4.1.0 Alpha 2 ==
== Step 24 (0) ==
Updating data in table: vw_integrate