[4.1 Beta 4] User merges don't merge, SQL error: Unknown column 'grantorid' in 'where clause'
With VW4.1 Beta 4 b003, when attempting to merge two users in XenForo 2.1, the merge does not complete. The following entry is added to the server error log:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'grantorid' in 'where clause' src/XF/Db/AbstractStatement.php:217
Code:
DELETE FROM `vw_whitelist` WHERE grantorid = 30827 AND userid = 25171
------------
#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(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(117): XF\Db\AbstractAdapter->query('DELETE FROM `vw...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(1330): vw_DB_Controller_XF2->query_write('DELETE FROM `vw...')
#6 src/addons/vw/vw/_core/model/db/mysql/vw.php(366): vw_DB_MySQL_Model->shutdown_or_run('DELETE FROM `vw...', false)
#7 src/addons/vw/vw/_core/model/plugins/data/vw.php(404): vw_DB_MySQL_Model->delete(Array)
#8 src/addons/vw/vw/XF/Service/User/Merge.php(44): vw_Plugins_Data_Model->do_user_merge_target_required(Array, Array)
#9 src/XF/MultiPartRunnerTrait.php(48): vw\vw\XF\Service\User\Merge->stepMergeWikiUserData(NULL, G)
#10 src/XF/Service/User/Merge.php(88): XF\Service\User\Merge->runLoop(G)
#11 src/XF/Job/UserMerge.php(39): XF\Service\User\Merge->merge(G)
#12 src/XF/Job/Manager.php(253): XF\Job\UserMerge->run(G)
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#14 src/XF/Job/Manager.php(111): XF\Job\Manager->runJobEntry(Array, G)
#15 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#16 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#18 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#19 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#20 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#21 src/XF.php(390): XF\App->run()
#22 admin.php(13): XF::runApp('XF\\Admin\\App')
#23 {main}