Fixed User Delete Clean Up error

[AndyB]

Affected version

Beta 7

When I delete a user I get the following error:

 

[Chris D]

Could you provide the full error and stack trace? (Copy and pasting the text from the full error is nearly always more useful than a screenshot).

 

[AndyB]

Thank you, Chris.

XF\Db\Exception: Job XF:UserDeleteCleanUp: MySQL statement prepare error [1054]: Unknown column 'user_id' in 'where clause' src/XF/Db/AbstractStatement.php:212

Generated by: Unknown account Oct 24, 2017 at 10:28 AM

Stack trace
UPDATE IGNORE `xf_upgrade_log` SET
`user_id` = 0
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('\n\t\t\t\t\t\tUPDATE I...', 21)
#5 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignContent(30, 7.9855713844299)
#6 src/XF/Service/User/ContentChange.php(196): XF\Service\User\ContentChange->runLoop(7.9855742454529)
#7 src/XF/Service/User/DeleteCleanUp.php(193): XF\Service\User\ContentChange->apply(7.9855742454529)
#8 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\DeleteCleanUp->stepChangeOwner(NULL, 7.9855742454529)
#9 src/XF/Service/User/DeleteCleanUp.php(93): XF\Service\User\DeleteCleanUp->runLoop(7.9999990463257)
#10 src/XF/Job/UserDeleteCleanUp.php(32): XF\Service\User\DeleteCleanUp->cleanUp(7.9999990463257)
#11 src/XF/Job/Manager.php(241): XF\Job\UserDeleteCleanUp->run(7.9999990463257)
#12 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999990463257)
#13 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999990463257)
#14 job.php(15): XF\Job\Manager->runQueue(false, 8)
#15 {main}

 

[Chris D]

Ah, yeah that's definitely a bug.

Fixed for the next release, thanks!