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

Price Filter error in Magento 1.7 - SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.min_price’ in ‘where clause’
 
Jaganaath
Jr. Member
 
Total Posts:  8
Joined:  2011-12-06
 

After upgrading from Magento 1.4.2 to 1.7.0, When i click on the price filter option in the category listing page, magento error page is popping out. And I can’t trace the exact issue.

Please help me to sort this issue....... Error message is given below.

There has been an error processing your request

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.min_price’ in ‘where clause’

Trace:
#0 /var/www/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT COUNT(DI...’, Array)
#4 /var/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT COUNT(DI...’, Array)
#5 /var/www/lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /var/www/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /var/www/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 /var/www/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1037): Varien_Data_Collection->getCurPage()
#10 /var/www/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(872): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#11 /var/www/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 /var/www/app/code/core/Mage/Core/Model/App.php(1338): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer))
#13 /var/www/app/code/core/Mage/Core/Model/App.php(1311): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), ‘catalogBlockPro...’, Object(Varien_Event_Observer))
#14 /var/www/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent(’catalog_block_p...’, Array)
#15 /var/www/app/code/core/Mage/Catalog/Block/Product/List.php(163): Mage::dispatchEvent(’catalog_block_p...’, Array)
#16 /var/www/app/code/core/Mage/Core/Block/Abstract.php(862): Mage_Catalog_Block_Product_List->_beforeToHtml()
#17 /var/www/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#18 /var/www/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’product_list’, true)
#19 /var/www/app/code/core/Mage/Catalog/Block/Category/View.php(85): Mage_Core_Block_Abstract->getChildHtml(’product_list’)
#20 /var/www/app/design/frontend/default/MAGFREE001/template/catalog/category/view.phtml(81): Mage_Catalog_Block_Category_View->getProductListHtml()
#21 /var/www/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/app/de...’)
#22 /var/www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#23 /var/www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#24 /var/www/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#25 /var/www/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#26 /var/www/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#27 /var/www/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#28 /var/www/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’content’, true)
#29 /var/www/app/design/frontend/default/MAGFREE001/template/page/2columns-left.phtml(50): Mage_Core_Block_Abstract->getChildHtml(’content’)
#30 /var/www/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/app/de...’)
#31 /var/www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#32 /var/www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#33 /var/www/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#34 /var/www/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#35 /var/www/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#36 /var/www/app/code/core/Mage/Catalog/controllers/CategoryController.php(159): Mage_Core_Controller_Varien_Action->renderLayout()
#37 /var/www/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController->viewAction()
#38 /var/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#39 /var/www/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#40 /var/www/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#41 /var/www/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#42 /var/www/index.php(87): Mage::run(’’, ‘store’)
#43 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagenX
Enthusiast
 
Total Posts:  791
Joined:  2008-05-26
Dublin
 

hi
if its a production server, send me test account, i would like to see and help you to debug.

cheers

 
Magento Community Magento Community
Magento Community
Magento Community
 
roywulmsdesign
Jr. Member
 
Total Posts:  29
Joined:  2011-04-13
 

Did you find out what cause this problem? I have the same problem too.

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

It seems that something went wrong while updating. We advise you to roll back to the old website and do the updating again.
In order to do the updating you should runn all these commands from Magento root directory in the console on your server or via SSH:

chmod 700 ./mage

./mage mage-setup .
./
mage install community Mage_Downloader --force
./mage install community Mage_All_Latest --force

chmod 700 
./mage

./mage sync-pear
./mage list-installed
./mage list-upgrades
./mage install http://connect20.magentocommerce.com/community Mage_All_Latest --force

chmod 700 ./mage

./mage config-set preferred_state beta
./mage list-installed
./mage list-upgrades
 
Magento Community Magento Community
Magento Community
Magento Community
 
roywulmsdesign
Jr. Member
 
Total Posts:  29
Joined:  2011-04-13
 

Hi, thanks for the reply.

I just found out what cause the issue.

It was a compatibly problem. I changed the price filter in Magento 1.6 (app/code/local/Mage/Catalog/Model/Layer/Filter/price.php)
In 1.7 this file has changed, so i had to change it also in the app/code/local directory.

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