http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=4704 Posted: 2009-01-06 06:46:29
Category: Newsletter
Version: 1.2.0.1
Priority: normal
Status: closed
Reported By: MAGNETO.ME

Tested on Firefox 2 Mac.

The error can be reproduced at : http://demo-admin.magentocommerce.com

Go to the Newsletter menu in the admin and select Newsletter subscribers .

In the table try to search by status or any field you wish.

The following error appears :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'website_id' in 'having clause'
Trace:
#0 /home/demoadm/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/demoadm/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/demoadm/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#3 /home/demoadm/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(258): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#4 /home/demoadm/public_html/lib/Zend/Db/Adapter/Abstract.php(727): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/demoadm/public_html/app/code/core/Mage/Newsletter/Model/Mysql4/Subscriber/Collection.php(124): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#6 /home/demoadm/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid/Massaction/Abstract.php(234): Mage_Newsletter_Model_Mysql4_Subscriber_Collection->getAllIds()
#7 /home/demoadm/public_html/app/design/adminhtml/default/default/template/widget/grid/massaction.phtml(77): Mage_Adminhtml_Block_Widget_Grid_Massaction_Abstract->getGridIdsJson()
#8 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(144): include('/home/demoadm/p...')
#9 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('adminhtml/defau...')
#10 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#11 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#12 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#13 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml('massaction', true)
#14 /home/demoadm/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(935): Mage_Core_Block_Abstract->getChildHtml('massaction')
#15 /home/demoadm/public_html/app/design/adminhtml/default/default/template/widget/grid.phtml(116): Mage_Adminhtml_Block_Widget_Grid->getMassactionBlockHtml()
#16 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(144): include('/home/demoadm/p...')
#17 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('adminhtml/defau...')
#18 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#19 /home/demoadm/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#20 /home/demoadm/public_html/app/code/core/Mage/Adminhtml/controllers/Newsletter/SubscriberController.php(61): Mage_Core_Block_Abstract->toHtml()
#21 /home/demoadm/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(348): Mage_Adminhtml_Newsletter_SubscriberController->gridAction()
#22 /home/demoadm/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(143): Mage_Core_Controller_Varien_Action->dispatch('grid')
#23 /home/demoadm/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/demoadm/public_html/app/Mage.php(450): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home/demoadm/public_html/index.php(57): Mage::run()
#26 {main}

---

]]> #1 / Comment by Magento Team

Hello MAGNETO.ME,

This issue was fixed. The changes will be available in the next bugfix release.

Thank you.]]>