Duplicate Server error log: User merge

[Robru]

Affected version

v2.0.0 Beta 7

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'user_id' in 'where clause'

UPDATE IGNORE `xf_upgrade_log` SET
                            `user_id` = 18641
                        WHERE `user_id` = ?
                    
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(35): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(46): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(69): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Service/User/ContentChange.php(254): XF\Db\AbstractAdapter->query('\r\n\t\t\t\t\t\tUPDATE ...', 18608)
#5 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignContent(30, 7.9956860542297)
#6 src/XF/Service/User/ContentChange.php(196): XF\Service\User\ContentChange->runLoop(7.995689868927)
#7 src/XF/Service/User/Merge.php(137): XF\Service\User\ContentChange->apply(7.995689868927)
#8 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepReassignContent(NULL, 7.995689868927)
#9 src/XF/Service/User/Merge.php(88): XF\Service\User\Merge->runLoop(7.9999990463257)
#10 src/XF/Job/UserMerge.php(39): XF\Service\User\Merge->merge(7.9999990463257)
#11 src/XF/Job/Manager.php(241): XF\Job\UserMerge->run(7.9999990463257)
#12 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999990463257)
#13 src/XF/Job/Manager.php(103): XF\Job\Manager->runJobEntry(Array, 7.9999990463257)
#14 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#15 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', 'json', Object(XF\Mvc\ParameterBag), 'tools', Object(XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(1844): XF\Mvc\Dispatcher->run()
#19 src/XF.php(328): XF\App->run()
#20 admin.php(13): XF::runApp('XF\\Admin\\App')
#21 {main}

 

[Robru]

/admin.php?tools/run-job

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'user_id' in 'where clause' in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 35
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 46
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 69
XF\Db\AbstractAdapter->query() in src/XF/Service/User/ContentChange.php at line 254
XF\Service\User\ContentChange->stepReassignContent() in src/XF/MultiPartRunnerTrait.php at line 48
XF\Service\User\ContentChange->runLoop() in src/XF/Service/User/ContentChange.php at line 196
XF\Service\User\ContentChange->apply() in src/XF/Service/User/Merge.php at line 137
XF\Service\User\Merge->stepReassignContent() in src/XF/MultiPartRunnerTrait.php at line 48
XF\Service\User\Merge->runLoop() in src/XF/Service/User/Merge.php at line 88
XF\Service\User\Merge->merge() in src/XF/Job/UserMerge.php at line 39
XF\Job\UserMerge->run() in src/XF/Job/Manager.php at line 241
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 187
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 76
XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 139
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1844
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

 

[Chris D]

This was already reported and fixed:
https://xenforo.com/community/threads/user-delete-clean-up-error.136161/

To resolve it open src/XF/Service/User/ContentChange.php and delete this line:

'xf_upgrade_log' => ['user_id'],