Magento 1.7价格过滤器错误(找不到列:1054"where子句"中的未知列"e.min_price") [英] Magento 1.7 price filter error (Column not found: 1054 Unknown column 'e.min_price' in 'where clause')

问题描述

在我的产品列表中，当我按价格进行过滤时，会出现此错误. 有人知道如何解决此问题吗?

In my productlist, when I filter on price, I get this error. Does anybody know, how to fix this?

SQLSTATE [42S22]:找不到列:1054未知列'e.min_price' 在"where子句"中

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

踪迹: 0/var/www/vhosts/domain.nl/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo-> _ execute(Array) 1/var/www/vhosts/domain.nl/httpdocs/lib/Zend/Db/Statement.php(300):Varien_Db_Statement_Pdo_Mysql-> _ execute(Array) 2/var/www/vhosts/domain.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement-> execute(Array) 3/var/www/vhosts/domain.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-> query('SELECT COUNT(DI ...'，数组) 4/var/www/vhosts/domain.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-> query('SELECT COUNT(DI ...'，Array) 5/var/www/vhosts/domain.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql-> query(Object(Varien_Db_Select)，Array) 6/var/www/vhosts/domain.nl/httpdocs/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract-> fetchOne(Object(Varien_Db_Select)，Array) 7/var/www/vhosts/domain.nl/httpdocs/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db-> getSize() 8/var/www/vhosts/domain.nl/httpdocs/lib/Varien/Data/Collection.php(211): Varien_Data_Collection-> getLastPageNumber() 9/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1036): Varien_Data_Collection-> getCurPage() 10/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract-> _ loadEntities(false，false) 11/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract-> load() 12/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1338): Mage_Review_Model_Observer-> catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer)) 13/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1311): Mage_Core_Model_App-> _ callObserverMethod(Object(Mage_Review_Model_Observer)， 'catalogBlockPro ...'，对象(Varien_Event_Observer)) 14/var/www/vhosts/domain.nl/httpdocs/app/Mage.php(447):Mage_Core_Model_App-> dispatchEvent('catalog_block_p ...'，Array) 15/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Catalog/Block/Product/List.php(163): 法师:: dispatchEvent('catalog_block_p ...'，Array) 16/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(862): Mage_Catalog_Block_Product_List-> _ beforeToHtml() 17/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract-> toHtml() 18/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract-> _ getChildHtml('product_list'，true) 19/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Catalog/Block/Category/View.php(85): Mage_Core_Block_Abstract-> getChildHtml('product_list') 20/var/www/vhosts/domain.nl/httpdocs/app/design/frontend/domain/default/template/catalog/category/view.phtml(67): Mage_Catalog_Block_Category_View-> getProductListHtml() 21/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): 包括('/var/www/vhosts ...') 22/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-> fetchView('frontend/johans ...') 23/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-> renderView() 24/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template-> _ toHtml() 25/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract-> toHtml() 26/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List-> _ toHtml() 27/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract-> toHtml() 28/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract-> _ getChildHtml('content'，true) 29/var/www/vhosts/domain.nl/httpdocs/app/design/frontend/domain/default/template/page/2columns-right.phtml(50): Mage_Core_Block_Abstract-> getChildHtml('content') 30/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): 包括('/var/www/vhosts ...') 31/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-> fetchView('frontend/johans ...') 32/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-> renderView() 33/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template-> _ toHtml() 34/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract-> toHtml() 35/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout-> getOutput() 36/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Catalog/controllers/CategoryController.php(159): Mage_Core_Controller_Varien_Action-> renderLayout() 37/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController-> viewAction() 38/var/www/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action-> dispatch('view') 39/var/www/vhosts/domain.nl/httpdocs/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/vhosts/domain.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front-> dispatch() 41/var/www/vhosts/domain.nl/httpdocs/app/Mage.php(683):Mage_Core_Model_App-> run(Array) 42/var/www/vhosts/domain.nl/httpdocs/index.php(92):Mage :: run(''，'store')

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

推荐答案

找到了解决方案:这是一个兼容的问题. 我在Magento 1.6中更改了价格过滤器 (应用程序/代码/本地/法师/目录/模型/图层/过滤器/price.php)

Found the solution: It was a compatibly problem. I had changed the price filter in Magento 1.6 (app/code/local/Mage/Catalog/Model/Layer/Filter/price.php)

在1.7中，此文件已更改，因此我也必须在app/code/local目录中对其进行更改.

In 1.7 this file has changed, so i had to change it also in the app/code/local directory.

这篇关于Magento 1.7价格过滤器错误(找不到列:1054"where子句"中的未知列"e.min_price")的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！