stack

exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay' in /home/rocajava/public_html/lib/Zend/Db/Statement/Pdo.php:227
Stack trace:
#0 /home/rocajava/public_html/lib/Zend/Db/Statement.php(279): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/rocajava/public_html/lib/Zend/Db/Adapter/Abstract.php(396): Zend_Db_Statement->execute(Array)
#2 /home/rocajava/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('select count(*)...', Array)
#3 /home/rocajava/public_html/lib/Zend/Db/Adapter/Abstract.php(677): Zend_Db_Adapter_Pdo_Abstract->query('select count(*)...', Array)
#4 /home/rocajava/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1158): Zend_Db_Adapter_Abstract->fetchOne('select count(*)...')
#5 /home/rocajava/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1097): Mage_Eav_Model_Entity_Collection_Abstract->getSize()
#6 /home/rocajava/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1120): Mage_Eav_Model_Entity_Collection_Abstract->getLastPageNumber()
#7 /home/rocajava/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(780): Mage_Eav_Model_Entity_Collection_Abstract->_getPageStart()
#8 /home/rocajava/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(661): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(337): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php(52): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#11 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(358): Mage_Adminhtml_Block_Sales_Order_Grid->_prepareCollection()
#12 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(364): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#13 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#14 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Abstract.php(437): Mage_Core_Block_Template->toHtml()
#15 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Abstract.php(415): Mage_Core_Block_Abstract->_getChildHtml('grid', true)
#16 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid/Container.php(62): Mage_Core_Block_Abstract->getChildHtml('grid')
#17 /home/rocajava/public_html/app/design/adminhtml/default/default/template/widget/grid/container.phtml(30): Mage_Adminhtml_Block_Widget_Grid_Container->getGridHtml()
#18 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(116): include('/home/rocajava/...')
#19 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(143): Mage_Core_Block_Template->fetchView('adminhtml/defau...')
#20 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(188): Mage_Core_Block_Template->renderView()
#21 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Text/List.php(38): Mage_Core_Block_Template->toHtml()
#22 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Abstract.php(437): Mage_Core_Block_Text_List->toHtml()
#23 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Abstract.php(415): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#24 /home/rocajava/public_html/app/design/adminhtml/default/default/template/page.phtml(130): Mage_Core_Block_Abstract->getChildHtml('content')
#25 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(116): include('/home/rocajava/...')
#26 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(143): Mage_Core_Block_Template->fetchView('adminhtml/defau...')
#27 /home/rocajava/public_html/app/code/core/Mage/Core/Block/Template.php(188): Mage_Core_Block_Template->renderView()
#28 /home/rocajava/public_html/app/code/core/Mage/Core/Model/Layout.php(401): Mage_Core_Block_Template->toHtml()
#29 /home/rocajava/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(303): Mage_Core_Model_Layout->getOutput()
#30 /home/rocajava/public_html/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(49): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /home/rocajava/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(326): Mage_Adminhtml_Sales_OrderController->indexAction()
#32 /home/rocajava/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(119): Mage_Core_Controller_Varien_Action->dispatch('index')
#33 /home/rocajava/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(164): Mage_Core_Controller_Varien_Router_Admin->match(Object(Zend_Controller_Request_Http))
#34 /home/rocajava/public_html/app/Mage.php(378): Mage_Core_Controller_Varien_Front->dispatch()
#35 /home/rocajava/public_html/index.php(28): Mage::run('base')
#36 {main}