Classifieds Error merging users

Status
Not open for further replies.
Code:
Server error log
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'reaction_table.like_users' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: Adminis 22 Jun 2019 às 10:41
Stack trace
            UPDATE (
                SELECT content_id FROM xf_reaction_content
                WHERE content_type = ?
                AND reaction_user_id = ?
            ) AS temp
            INNER JOIN xf_z61_classifieds_listing AS reaction_table ON (reaction_table.`listing_id` = temp.content_id)
            SET reaction_table.`like_users` = REPLACE(reaction_table.`like_users`, ?, ?)
        
------------

#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/Like/AbstractHandler.php(139): XF\Db\AbstractAdapter->query('
            UPDATE (
        ...', Array)
#5 src/XF/Service/User/ContentChange.php(310): XF\Like\AbstractHandler->updateRecentCacheForUserChange(48615, 466, 'luismpg', 'Luis Gonçalves')
#6 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepRebuildLikes(-1, G)
#7 src/XF/Service/User/ContentChange.php(198): XF\Service\User\ContentChange->runLoop(G)
#8 src/XF/Service/User/Merge.php(137): XF\Service\User\ContentChange->apply(G)
#9 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepReassignContent(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(79): XF\Job\Manager->runJobEntry(Array, G)
#15 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 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(2177): XF\Mvc\Dispatcher->run()
#21 src/XF.php(390): XF\App->run()
#22 admin.php(13): XF::runApp('XF\\Admin\\App')
#23 {main}
Request state
array(4) {
  ["url"] => string(31) "/foruns/admin.php?tools/run-job"
  ["referrer"] => string(58) "https://mywebsite.com/foruns/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["_xfRedirect"] => string(17) "/foruns/admin.php"
    ["_xfToken"] => string(8) "********"
    ["only_ids"] => string(0) ""
  }
}
 
Code:
Server error log
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'reaction_table.like_users' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: Adminis 22 Jun 2019 às 10:41
Stack trace
            UPDATE (
                SELECT content_id FROM xf_reaction_content
                WHERE content_type = ?
                AND reaction_user_id = ?
            ) AS temp
            INNER JOIN xf_z61_classifieds_listing AS reaction_table ON (reaction_table.`listing_id` = temp.content_id)
            SET reaction_table.`like_users` = REPLACE(reaction_table.`like_users`, ?, ?)
       
------------

#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/Like/AbstractHandler.php(139): XF\Db\AbstractAdapter->query('
            UPDATE (
        ...', Array)
#5 src/XF/Service/User/ContentChange.php(310): XF\Like\AbstractHandler->updateRecentCacheForUserChange(48615, 466, 'luismpg', 'Luis Gonçalves')
#6 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepRebuildLikes(-1, G)
#7 src/XF/Service/User/ContentChange.php(198): XF\Service\User\ContentChange->runLoop(G)
#8 src/XF/Service/User/Merge.php(137): XF\Service\User\ContentChange->apply(G)
#9 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepReassignContent(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(79): XF\Job\Manager->runJobEntry(Array, G)
#15 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 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(2177): XF\Mvc\Dispatcher->run()
#21 src/XF.php(390): XF\App->run()
#22 admin.php(13): XF::runApp('XF\\Admin\\App')
#23 {main}
Request state
array(4) {
  ["url"] => string(31) "/foruns/admin.php?tools/run-job"
  ["referrer"] => string(58) "https://mywebsite.com/foruns/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["_xfRedirect"] => string(17) "/foruns/admin.php"
    ["_xfToken"] => string(8) "********"
    ["only_ids"] => string(0) ""
  }
}
The latest released version should already address this.
 
Status
Not open for further replies.
Back
Top