uncaught_exception

[GemadaoTV]

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

[Jim M]

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.