Issue: [4.1 Alpha 2] Upgrade: SQL error with vw_integrate: unknown column 'adminset'

Issue Tools
- View Changes

February 13, 2019 12:16 AM

ACL

Regular Member

[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

Issue Details

Issue Number 5635

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 4.1.0 Alpha 2

Fixed Version 4.1.0 Alpha 2

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 13, 2019 12:29 PM
pegasus

VaultWiki Team
In src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/0/alpha/2/C/xf2.php, find:

Code:

410alpha1

Replace with:

Code:

410alpha2
Reply
February 13, 2019 12:52 PM

ACL

Regular Member

Thanks

Without this fix, is it possible certain steps could have been skipped in the Alpha 1 to Alpha 2 upgrade? As issue 5598 (vw_area empty child/parentlist) persists for the areas created during Alpha 1. No biggie if I need to fresh install Alpha 1 and restart the upgrade.

Reply

February 13, 2019 1:06 PM

pegasus

VaultWiki Team

In the same file, find:

Code:

$versionnfo

Replace with:

Code:

$version

Run the following MySQL queries:

Code:

UPDATE vw_upgradelog
SET `version` = '4.1.0 Alpha 1', `step` = 0
WHERE upgradetype = 'C'
LIMIT 1

Code:

UPDATE vw_upgradelog
SET `version` = '4.1.0 Alpha 1'
WHERE upgradetype = 'F'
LIMIT 1

Code:

UPDATE xf_addon
SET version_id = 1204010011, json_hash = ''
WHERE addon_id = 'vw/vw'
LIMIT 1

Then you should be able to run the upgrade again in order to execute the missed upgrade steps.

February 13, 2019 1:16 PM

ACL

Regular Member

Perfect, thank you. vw_area parent/childlists are no longer empty

Reply

+ Reply

All times are GMT -4. The time now is 5:32 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: [4.1 Alpha 2] Upgrade: SQL error with vw_integrate: unknown column 'adminset'

Issue Tools