Hello, can someone please help me figure out the problem of this error? Here is the Details of the Error : Error Info Code: Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Column 'like_count' in field list is ambiguous - library/Zend/Db/Statement/Mysqli.php:77 Generated By: Unknown Account, Today at 10:22 AM Stack Trace : Code: #0 /home/nullse/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT use...') #1 /home/nullse/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT use...') #2 /home/nullse/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT use...') #3 /home/nullse/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT use...', Array, 2) #4 /home/nullse/public_html/library/XenForo/Model/User.php(297): XenForo_Model->fetchAllKeyed('?????SELECT use...', 'user_id') #5 /home/nullse/public_html/library/Brivium/ReferralCreditSystem/CronEntry/Referral.php(29): XenForo_Model_User->getUsers(Array, Array) #6 [internal function]: Brivium_ReferralCreditSystem_CronEntry_Referral::runPromotions(Array) #7 /home/nullse/public_html/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array) #8 /home/nullse/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array) #9 /home/nullse/public_html/library/XenForo/Model/Deferred.php(252): XenForo_Deferred_Cron->execute(Array, Array, 9.99999499321, '') #10 /home/nullse/public_html/library/XenForo/Model/Deferred.php(378): XenForo_Model_Deferred->runDeferred(Array, 9.99999499321, '', false) #11 /home/nullse/public_html/library/XenForo/Model/Deferred.php(331): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false) #12 /home/nullse/public_html/deferred.php(23): XenForo_Model_Deferred->run(false) #13 {main} Request State Code: array(3) { ["url"] => string(35) "http://www.null-sec.ru/deferred.php" ["_GET"] => array(0) { } ["_POST"] => array(4) { ["_xfRequestUri"] => string(79) "/index.php?threads/what-sub-sections-would-you-like-in-the-gaming-sections.296/" ["_xfNoRedirect"] => string(1) "1" ["_xfToken"] => string(8) "********" ["_xfResponseType"] => string(4) "json" } }
Hello, We don't have a copy of that add-on so can't confirm, but it would be up to @Luke Foreman to fix if it is that add-on. Regards,
If Luke Foreman agree for that, you can send us a copy via conversation or email: [email protected] Regards,
Hello, Thanks for your help. We found issue from Post Rating, Luke Forman used like_count without specifying a table name. You can fix that by follow guide below. Open file library/Dark/PostRating/Model/User.php and find Code: if($options->dark_postrating_like_id > 0 && $options->dark_postrating_like_show){ $joinOptions['selectFields'] .= " , ((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (".implode(",", $positive).")) + like_count) as positive_rating_count_incl_likes Change to Code: if($options->dark_postrating_like_id > 0 && $options->dark_postrating_like_show){ $joinOptions['selectFields'] .= " , ((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (".implode(",", $positive).")) + user.like_count) as positive_rating_count_incl_likes Regards,