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

Newsletter subscirbers list
 
Frederik Bové
Member
 
Total Posts:  58
Joined:  2008-08-26
 

I get the error below when I whant to filter the newsletter subscibers list

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

nobody any idee?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lewin
Jr. Member
 
Total Posts:  4
Joined:  2009-03-04
 

I got the same problem. does anyone could help!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lewin
Jr. Member
 
Total Posts:  4
Joined:  2009-03-04
 

By the way. I tried reinstalled whole system couple times. but it seem that cannot fix the problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Bruno Serges
Jr. Member
 
Total Posts:  2
Joined:  2008-07-05
 

that bug was solved in magento 1.2.1
http://www.magentocommerce.com/roadmap/release/1.2.1
Ticket 9803

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lewin
Jr. Member
 
Total Posts:  4
Joined:  2009-03-04
 

I got ver. 1.2.1.1 but still problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lewin
Jr. Member
 
Total Posts:  4
Joined:  2009-03-04
 

I got 1.2.1.1 but still problem. Cannot send newsletter.

 
Magento Community Magento Community
Magento Community
Magento Community
 
meurissema
Member
 
Total Posts:  62
Joined:  2008-03-10
Marcq En Baroeul
 

Hello, it’s possible to know where is modifications in the core ?

Thanks

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