Magento Dashboard生成SQL错误

Question

我在管理部分的仪表板有问题，没有向我显示任何数据。我得到这个错误: SQLSTATE42000:语法错误或访问冲突: 1140组列的混合(MIN()，MAX()，COUNT()，...)如果没有GROUP BY子句，则with no GROUP列是非法的

我不知道是什么导致了这个问题，下面是跟踪：

0 /var/www/store/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/store/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/store/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/store/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /var/www/store/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /var/www/store/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /var/www/store/public_html/lib/Varien/Data/Collection/Db.php(687): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /var/www/store/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(520): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /var/www/store/public_html/lib/Varien/Data/Collection/Db.php(521): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /var/www/store/public_html/lib/Varien/Data/Collection.php(268): Varien_Data_Collection_Db->load()
#10 /var/www/store/public_html/app/code/local/Ezapps/Zoom/Model/Mysql4/Page/Collection.php(28): Varien_Data_Collection->getFirstItem()
#11 /var/www/store/public_html/app/code/local/Ezapps/Zoom/Block/Adminhtml/Dashboard/Tab/Zoom.php(38): Ezapps_Zoom_Model_Mysql4_Page_Collection->getStats()
#12 /var/www/store/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard/Abstract.php(77): Ezapps_Zoom_Block_Adminhtml_Dashboard_Tab_Zoom->_prepareData()
#13 /var/www/store/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Dashboard_Abstract->_prepareLayout()
#14 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#15 /var/www/store/public_html/app/code/local/Ezapps/Tools/Block/Adminhtml/Dashboard/Diagrams.php(42): Mage_Core_Model_Layout->createBlock('ezzoom/adminhtm...')
#16 /var/www/store/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Ezapps_Tools_Block_Adminhtml_Dashboard_Diagrams->_prepareLayout()
#17 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#18 /var/www/store/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard.php(66): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...')
#19 /var/www/store/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
#20 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#21 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(446): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...', 'dashboard')
#22 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(238): Mage_Core_Model_Layout->addBlock('adminhtml/dashb...', 'dashboard')
#23 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(204): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#24 /var/www/store/public_html/app/code/core/Mage/Core/Model/Layout.php(209): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#25 /var/www/store/public_html/app/code/local/Mage/Core/Controller/Varien/Action.php(345): Mage_Core_Model_Layout->generateBlocks()
#26 /var/www/store/public_html/app/code/local/Mage/Core/Controller/Varien/Action.php(270): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#27 /var/www/store/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(263): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#28 /var/www/store/public_html/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
#29 /var/www/store/public_html/app/code/local/Mage/Core/Controller/Varien/Action.php(420): Mage_Adminhtml_DashboardController->indexAction()
#30 /var/www/store/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#31 /var/www/store/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 /var/www/store/public_html/app/code/local/Mage/Core/Model/App.php(348): Mage_Core_Controller_Varien_Front->dispatch()
#33 /var/www/store/public_html/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#34 /var/www/store/public_html/index.php(82): Mage::run('', 'store')
#35 {main}

Answer 1

正如您在堆栈跟踪中看到的，该问题是由来自Ezapps的自定义模块引起的……

尝试禁用该模块(app/etc/modules/Ezapps_*.xml -将active设置为false)，并检查需要执行哪些其他操作才能禁用该模块...

在该模块的代码中，在形成sql查询时有一个问题...