Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Admin Dashboard Errors Zend_Db_Statement_Exception
 
nomi
Member
 
Total Posts:  36
Joined:  2007-09-03
 

I upgraded to the newest version last week. It seemed to go fine, but now when I try to go to the admin dashboard page, it’s just all a bunch of errors. Here is the code:

SELECT `e`.*, `_table_base_subtotal`.`value` AS `base_subtotal`, `_table_base_discount_amount`.`value` AS `base_discount_amount`, `_table_store_to_base_rate`.`value` AS `store_to_base_rate`, `_table_base_total_refunded`.`value` AS `base_total_refunded`, `_table_base_total_canceled`.`value` AS `base_total_canceled`, SUM((_table_base_subtotal.value-ifnull(_table_base_discount_amount.value,0)-ifnull(_table_base_total_refunded.value,0)-ifnull(_table_base_total_canceled.value,0))/_table_store_to_base_rate.value) AS `revenue`, `_table_base_tax_amount`.`value` AS `base_tax_amount`, SUM(_table_base_tax_amount.value/_table_store_to_base_rate.value) AS `tax`, `_table_base_shipping_amount`.`value` AS `base_shipping_amount`, SUM(_table_base_shipping_amount.value/_table_store_to_base_rate.value) AS `shipping`, COUNT(e.entity_id) AS `quantityFROM `sales_order_entity` AS `eLEFT JOIN `sales_order_entity_decimal` AS `_table_base_subtotalON (_table_base_subtotal.entity_id e.entity_id) AND (_table_base_subtotal.attribute_id='492'LEFT JOIN `sales_order_entity_decimal` AS `_table_base_discount_amountON (_table_base_discount_amount.entity_id e.entity_id) AND (_table_base_discount_amount.attribute_id='489'LEFT JOIN `sales_order_entity_decimal` AS `_table_store_to_base_rateON (_table_store_to_base_rate.entity_id e.entity_id) AND (_table_store_to_base_rate.attribute_id='226'LEFT JOIN `sales_order_entity_decimal` AS `_table_base_total_refundedON (_table_base_total_refunded.entity_id e.entity_id) AND (_table_base_total_refunded.attribute_id='496'LEFT JOIN `sales_order_entity_decimal` AS `_table_base_total_canceledON (_table_base_total_canceled.entity_id e.entity_id) AND (_table_base_total_canceled.attribute_id='498'LEFT JOIN `sales_order_entity_decimal` AS `_table_base_tax_amountON (_table_base_tax_amount.entity_id e.entity_id) AND (_table_base_tax_amount.attribute_id='487'LEFT JOIN `sales_order_entity_decimal` AS `_table_base_shipping_amountON (_table_base_shipping_amount.entity_id e.entity_id) AND (_table_base_shipping_amount.attribute_id='488'WHERE (e.entity_type_id '11'GROUP BY `e`.`entity_type_id`

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/sites/british-bodybuilding.co.uk/public_html/magento/lib/Zend/Db/Statement/Pdo.php:238
Stack trace
:
#0 /home/sites/british-bodybuilding.co.uk/public_html/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/sites/british-bodybuilding.co.uk/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/sites/british-bodybuilding.co.uk/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/sites/british-bodybuilding.co.uk/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(813): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#5 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(688): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#6 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Adminhtml/Block/Dashboard/Totals.php(54): Mage_Eav_Model_Entity_Collection_Abstract->load()
#7 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(192): Mage_Adminhtml_Block_Dashboard_Totals->_prepareLayout()
#8 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(383): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#9 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Adminhtml/Block/Dashboard.php(46): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...')
#10 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(192): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
#11 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(383): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#12 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(34): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...', 'dashboard')
#13 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(341): Mage_Adminhtml_DashboardController->indexAction()
#14 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(141): Mage_Core_Controller_Varien_Action->dispatch('index')
#15 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(147): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#16 /home/sites/british-bodybuilding.co.uk/public_html/magento/app/Mage.php(400): Mage_Core_Controller_Varien_Front->dispatch()
#17 /home/sites/british-bodybuilding.co.uk/public_html/magento/index.php(29): Mage::run('default')
#18 {main}

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Airforce111
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2008-01-31
 

I have no idea on how you got that error or how to fix it, but I gotta say… that’s one mighty big SELECT query 0.o! It’s humongous.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top