GemadaoTV Posted November 3, 2022 Posted November 3, 2022 SELECT forums_topics.tid FROM `forums_topics` LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id WHERE forums_topics.approved < 2 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(5,7,8,10,11,13,14,16,19,20,21,22,23,24,26,28,29,30,31,32,33,35,36,38,39,40,41,42,43,47,48,49,50,51,52,53) AND forums_forums.min_posts_view<=110 ORDER BY forums_topics.last_post DESC LIMIT 5 IPS\Db\Exception: 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 (1104) #0 /home/puas/www/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*puas::puas::I...', Array, true) #1 /home/puas/www/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /home/puas/www/system/Content/Item.php(3339): iterator_to_array(Object(IPS\Db\Select)) #4 /home/puas/www/applications/forums/sources/Topic/Topic.php(314): IPS\Content\_Item::getItemsWithPermission(Array, 'forums_topics.l...', 5, 'read', true, 256, Object(IPS\Member), true, false, false, false, NULL, false, true, true, true, false) #5 /home/puas/www/system/Content/Widget.php(476): IPS\forums\_Topic::getItemsWithPermission(Array, 'forums_topics.l...', 5, 'read', NULL, 256) #6 /home/puas/www/system/Widget/Widget.php(833): IPS\Content\_Widget->render() #7 /home/puas/www/system/Widget/Widget.php(888): IPS\_Widget->_render() #8 /home/puas/www/system/Theme/Theme.php(885) : eval()'d code(18191): IPS\_Widget->__toString() #9 /home/puas/www/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->widgetContainer('header', 'horizontal') #10 /home/puas/www/system/Theme/Theme.php(885) : eval()'d code(6731): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #11 /home/puas/www/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate('Club Pua - Como...', '\n\n<div class='i...', Array) #12 /home/puas/www/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #13 /home/puas/www/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish() #14 /home/puas/www/system/Dispatcher/Front.php(558): IPS\Dispatcher\_Standard->finish() #15 /home/puas/www/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\_Front->finish() #16 /home/puas/www/index.php(13): IPS\_Dispatcher->run() #17 {main} BACKTRACE #0 /home/puas/www/init.php(1029): IPS\_Log::log('SELECT forums_t...', 'uncaught_except...') #1 /home/puas/www/system/Widget/Widget.php(935): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 /home/puas/www/system/Theme/Theme.php(885) : eval()'d code(18191): IPS\_Widget->__toString() #3 /home/puas/www/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->widgetContainer('header', 'horizontal') #4 /home/puas/www/system/Theme/Theme.php(885) : eval()'d code(6731): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #5 /home/puas/www/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate('Club Pua - Como...', '\n\n<div class='i...', Array) #6 /home/puas/www/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #7 /home/puas/www/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish() #8 /home/puas/www/system/Dispatcher/Front.php(558): IPS\Dispatcher\_Standard->finish() #9 /home/puas/www/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\_Front->finish() #10 /home/puas/www/index.php(13): IPS\_Dispatcher->run() #11 {main} I've had this problem for a month on my website, on the home page. I believe it's the recent threads hook I'm not sure. Can you help me
Solution Jim M Posted November 3, 2022 Solution Posted November 3, 2022 The following would be server configuration item with your MySQL server. This is the error MySQL is coming back with when we attempt to run the query: 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 Please contact your hosting provider for assistance. GemadaoTV 1
Recommended Posts