MySQL query error [1104]: The SELECT would examine more than MAX_JOIN_SIZE rows

[kodeblend]

Dear experts please guide i am facing this error.

• XF\Db\InvalidQueryException: MySQL query error [1104]: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
• src/XF/Db/AbstractStatement.php:230

Stack trace​

SELECT content_type, content_id, count(*) as count
FROM xf_sv_user_activity
WHERE `timestamp` >= ? AND (
(content_type = 'node' AND content_id in (75)) OR
(content_type = 'thread' AND content_id in (815, 705, 102, 100, 1834, 1833, 1816, 1815, 1790, 1719, 1708, 1706, 1704, 1703, 1700, 1246, 1667, 1666, 1665, 156)))
group by content_type, content_id
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1104, '42000')
#1 src/XF/Db/Mysqli/Statement.php(78): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1104, '42000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(157): XF\Db\AbstractAdapter->query('SELECT content_...', Array)
#4 src/addons/SV/UserActivity/Repository/UserActivity.php(638): XF\Db\AbstractAdapter->fetchAll('SELECT content_...', Array)
#5 src/addons/SV/UserActivity/Repository/UserActivity.php(671): SV\UserActivity\Repository\UserActivity->_getUsersViewingCountFallback(Array, 1713490710, 1713491640)
#6 src/addons/SV/UserActivity/Repository/UserActivity.php(125): SV\UserActivity\Repository\UserActivity->getUsersViewingCount(Array)
#7 src/addons/SV/UserActivity/UserCountActivityInjector.php(90): SV\UserActivity\Repository\UserActivity->insertBulkUserActivityIntoViewResponse(Object(XF\Mvc\Reply\View), Array)
#8 src/addons/SV/UserActivity/UserCountActivityInjector.php(38): SV\UserActivity\XF\Pub\Controller\Forum->_injectUserCountIntoResponse(Object(XF\Mvc\Reply\View), 'Forum')
#9 src/XF/Mvc/Controller.php(360): SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType('Forum', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#10 src/addons/SV/UserActivity/UserActivityInjector.php(69): XF\Mvc\Controller->postDispatch('Forum', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#11 src/XF/Mvc/Dispatcher.php(385): SV\UserActivity\XF\Pub\Controller\Forum->postDispatch('Forum', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#12 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Forum', Object(XF\Mvc\RouteMatch), Object(SV\StandardLib\XF\Pub\Controller\Forum), Object(XF\Mvc\Reply\Reroute))
#13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\StandardLib\XF\Pub\Controller\Forum), Object(XF\Mvc\Reply\Reroute))
#14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#16 src/XF.php(524): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}

 

M

[MMO] Rate Own Resources

Avatar Problems