I was able to reproduce the database error after following the upgrade procedure outlined by ACL.
This occurs when performing an upgrade in XF 2, if there is a branch of the VaultWiki upgrade that was never started before:
That is, specific changes for 1.3, 1.5, 2.0, etc that were not already performed at the initial install, and this is the first time the upgrade is noticing a branch change -
* The first step of the first upgrade script in the new branch was being skipped.
In
src/addons/vw/vw/Setup.php, find:
Code:
$version['steps'][$newVersion[0]] = array($internalStep, $startat);
Replace with:
Code:
$version['steps'][$newVersion[0]] = array(0, $startat);
To correct an existing installation that already upgraded, run the following MySQL queries:
Code:
DELETE FROM vw_upgradelog WHERE upgradetype = 'XF1T2';
Code:
UPDATE xf_addon
SET json_hash = '',
version_id = version_id - 1
WHERE addon_id = 'vw/vw';
Then you will be able to perform the upgrade again.
After the upgrade, you may want to cleanup any widgets / widget definitions that might have been duplicated.