{"action":"created","issue":{"url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/4","labels_url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/4/comments","events_url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/4/events","html_url":"https://github.com/quafzi/magento-CustomerGridOrderCount/issues/4","id":55657778,"number":4,"title":"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'customer_id' in group statement is ambiguous","user":{"login":"theskillwithin","id":8095506,"avatar_url":"https://avatars.githubusercontent.com/u/8095506?v=3","gravatar_id":"","url":"https://api.github.com/users/theskillwithin","html_url":"https://github.com/theskillwithin","followers_url":"https://api.github.com/users/theskillwithin/followers","following_url":"https://api.github.com/users/theskillwithin/following{/other_user}","gists_url":"https://api.github.com/users/theskillwithin/gists{/gist_id}","starred_url":"https://api.github.com/users/theskillwithin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theskillwithin/subscriptions","organizations_url":"https://api.github.com/users/theskillwithin/orgs","repos_url":"https://api.github.com/users/theskillwithin/repos","events_url":"https://api.github.com/users/theskillwithin/events{/privacy}","received_events_url":"https://api.github.com/users/theskillwithin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-27T18:46:15Z","updated_at":"2015-01-28T14:35:57Z","closed_at":null,"body":"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'customer_id' in group statement is ambiguous\r\n\r\nTrace:\r\n#0 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)\r\n#1 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Zend/Db/Statement.php(301): Varien_Db_Statement_Pdo_Mysql->_execute(Array)\r\n#2 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)\r\n#3 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array)\r\n#4 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array)\r\n#5 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)\r\n#6 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)\r\n#7 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()\r\n#8 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()\r\n#9 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Data/Collection/Db.php(516): Varien_Data_Collection->getCurPage()\r\n#10 /chroot/home/skincare/dev.skincarebyalana.com/html/lib/Varien/Data/Collection/Db.php(563): Varien_Data_Collection_Db->_renderLimit()\r\n#11 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(533): Varien_Data_Collection_Db->load()\r\n#12 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php(65): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()\r\n#13 [internal function]: Mage_Adminhtml_Block_Sales_Order_Grid->_prepareCollection()\r\n#14 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/community/Quafzi/CustomerGridOrderCount/Model/Observer.php(41): ReflectionMethod->invoke(Object(Mage_Adminhtml_Block_Sales_Order_Grid))\r\n#15 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/community/Quafzi/CustomerGridOrderCount/Model/Observer.php(29): Quafzi_CustomerGridOrderCount_Model_Observer->_callProtectedMethod(Object(Mage_Adminhtml_Block_Sales_Order_Grid), '_prepareCollect...')\r\n#16 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/community/Quafzi/CustomerGridOrderCount/Model/Observer.php(19): Quafzi_CustomerGridOrderCount_Model_Observer->_modifyGrid(Object(Mage_Adminhtml_Block_Sales_Order_Grid), 'created_at')\r\n#17 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/App.php(1338): Quafzi_CustomerGridOrderCount_Model_Observer->beforeBlockToHtml(Object(Varien_Event_Observer))\r\n#18 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Quafzi_CustomerGridOrderCount_Model_Observer), 'beforeBlockToHt...', Object(Varien_Event_Observer))\r\n#19 /chroot/home/skincare/dev.skincarebyalana.com/html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('core_layout_blo...', Array)\r\n#20 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(459): Mage::dispatchEvent('core_layout_blo...', Array)\r\n#21 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Adminhtml/Block/Widget/Grid/Container.php(66): Mage_Core_Model_Layout->createBlock('adminhtml/sales...', 'sales_order.gri...')\r\n#22 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/local/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Widget_Grid_Container->_prepareLayout()\r\n#23 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mybuys_Connector_Model_Layout))\r\n#24 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('adminhtml/sales...', 'sales_order.gri...')\r\n#25 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('adminhtml/sales...', 'sales_order.gri...')\r\n#26 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/community/Mybuys/Connector/Model/Layout.php(54): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))\r\n#27 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(205): Mybuys_Connector_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))\r\n#28 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))\r\n#29 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()\r\n#30 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()\r\n#31 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)\r\n#32 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(59): Mage_Adminhtml_Controller_Action->loadLayout()\r\n#33 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(94): Mage_Adminhtml_Sales_OrderController->_initAction()\r\n#34 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_Sales_OrderController->indexAction()\r\n#35 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')\r\n#36 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))\r\n#37 /chroot/home/skincare/dev.skincarebyalana.com/html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()\r\n#38 /chroot/home/skincare/dev.skincarebyalana.com/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)\r\n#39 /chroot/home/skincare/dev.skincarebyalana.com/html/index.php(96): Mage::run('', 'store')\r\n#40 {main}"},"comment":{"url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/comments/71843804","html_url":"https://github.com/quafzi/magento-CustomerGridOrderCount/issues/4#issuecomment-71843804","issue_url":"https://api.github.com/repos/quafzi/magento-CustomerGridOrderCount/issues/4","id":71843804,"user":{"login":"quafzi","id":164261,"avatar_url":"https://avatars.githubusercontent.com/u/164261?v=3","gravatar_id":"","url":"https://api.github.com/users/quafzi","html_url":"https://github.com/quafzi","followers_url":"https://api.github.com/users/quafzi/followers","following_url":"https://api.github.com/users/quafzi/following{/other_user}","gists_url":"https://api.github.com/users/quafzi/gists{/gist_id}","starred_url":"https://api.github.com/users/quafzi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/quafzi/subscriptions","organizations_url":"https://api.github.com/users/quafzi/orgs","repos_url":"https://api.github.com/users/quafzi/repos","events_url":"https://api.github.com/users/quafzi/events{/privacy}","received_events_url":"https://api.github.com/users/quafzi/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T14:35:56Z","updated_at":"2015-01-28T14:35:56Z","body":"Would be great to know, in which situation you got that error."}}