Bug Merge with user

[NotDrink]

Hello. When merging two users, I get an error. The error is related to your plugin.
The following message appears in the admin panel "There are manual rebuild jobs awaiting completion. Continue running them."
If I continue, I get this message:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'creator_user_id' in 'where clause' in src/XF/Db/AbstractStatement.php at line 228

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 322
6. XF\Db\AbstractAdapter->update() in src/addons/DBTech/Shop/XF/Service/User/Merge.php at line 82
7. DBTech\Shop\XF\Service\User\Merge->postMergeCleanUp() in src/XF/Service/User/Merge.php at line 153
8. XF\Service\User\Merge->stepFinalizeMerge() in src/XF/MultiPartRunnerTrait.php at line 48
9. XF\Service\User\Merge->runLoop() in src/XF/Service/User/Merge.php at line 88
10. XF\Service\User\Merge->merge() in src/XF/Job/UserMerge.php at line 39
11. XF\Job\UserMerge->run() in src/XF/Job/Manager.php at line 253
12. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 195
13. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 79
14. XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 139
15. XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 350
16. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
17. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
18. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
19. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
20. XF\App->run() in src/XF.php at line 391
21. XF::runApp() in admin.php at line 13

This entry appears in the error log:

• XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'creator_user_id' in 'where clause'
• src/XF/Db/AbstractStatement.php:228
• Generated by: Admin
• Jan 4, 2020 at 8:35 AM

Stack trace
UPDATE xf_dbtech_shop_purchase SET creator_username = ? WHERE creator_user_id = ?
------------

#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/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE `xf_dbt...', Array)
#5 src/addons/DBTech/Shop/XF/Service/User/Merge.php(82): XF\Db\AbstractAdapter->update('xf_dbtech_shop_...', Array, 'creator_user_id...', Array)
#6 src/XF/Service/User/Merge.php(153): DBTech\Shop\XF\Service\User\Merge->postMergeCleanUp()
#7 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepFinalizeMerge(NULL, G)
#8 src/XF/Service/User/Merge.php(88): XF\Service\User\Merge->runLoop(G)
#9 src/XF/Job/UserMerge.php(39): XF\Service\User\Merge->merge(G)
#10 src/XF/Job/Manager.php(253): XF\Job\UserMerge->run(G)
#11 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#12 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#13 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 8)
#14 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#16 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#19 src/XF.php(391): XF\App->run()
#20 admin.php(13): XF::runApp('XF\\Admin\\App')
#21 {main}
Request state
array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(43) "site/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(10) "/admin.php"
["_xfToken"] => string(8) "********"
["only_ids"] => string(0) ""
}
}

 

[Fillip H.]

I've applied a hotfix to v6.1.4 that should resolve this issue

 

[NotDrink]

I updated the plugin to version 6.1.4 today, but the problem is not solved.
Or do I need to update the plugin again?

 

[Fillip H.]

Yes, after I've applied a hotfix you would need to re-download the files and re-upload the files.

 

[NotDrink]

I updated the plugin. The bug is fixed. Thanks.

 

[DragonByte Technologies]

Hello @NotDrink,

We hope your ticket regarding DragonByte Shop has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @NotDrink,

As we have not heard back from you, your ticket regarding DragonByte Shop has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.