XF 2.3 Merge users does not work (sql error)

[Salamanca]

Hi,

I tried to merge two users. It does not work. When I do it, I get "Your changes have been saved" but they are not merged.
Error log reports:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'last_edit_user_id' in 'field list'
[HEADING=2]Stack trace[/HEADING]
                        UPDATE IGNORE `xf_xcu_profile_audio` SET
                            `last_edit_user_id` = 23756
                        WHERE `last_edit_user_id` = ?
                    
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(43): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(61): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Service/User/ContentChangeService.php(278): XF\Db\AbstractAdapter->query('
                        UPDATE I...', 34515)
#5 src/XF/MultiPartRunnerTrait.php(88): XF\Service\User\ContentChangeService->stepReassignContent(104, 7.98963)
#6 src/XF/Service/User/ContentChangeService.php(225): XF\Service\User\ContentChangeService->runLoop(7.98963)
#7 src/XF/Service/User/MergeService.php(275): XF\Service\User\ContentChangeService->apply(7.98963)
#8 src/XF/MultiPartRunnerTrait.php(88): XF\Service\User\MergeService->stepReassignContent(NULL, 7.98963)
#9 src/XF/Service/User/MergeService.php(108): XF\Service\User\MergeService->runLoop(8)
#10 src/XF/Job/UserMerge.php(42): XF\Service\User\MergeService->merge(8)
#11 src/XF/Job/Manager.php(275): XF\Job\UserMerge->run(8)
#12 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 8)
#13 src/XF/Job/Manager.php(121): XF\Job\Manager->runJobEntry(Array, 8)
#14 src/XF/Admin/Controller/ToolsController.php(146): XF\Job\Manager->runByIds(Array, 8)
#15 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\ToolsController->actionRunJob(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ToolsController), NULL)
#17 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ToolsController), NULL)
#18 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#20 src/XF.php(806): XF\App->run()
#21 admin.php(15): XF::runApp('XF\\Admin\\App')
#22 {main}

Thanks
Alex

 

[Ozzy47]

Are you running some sort of profile music addon?

 

[Salamanca]

yes: https://xencustomize.com/product/profile-audio-player-library.4/

 

[Ozzy47]

Disable that and try again.