0

Working on custom layered navigation on custom collection. follow this solution link

Getting an Error:

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.min_price' in 'field list', query was: SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(e.min_price ) * 1, 2) AS `max`, ROUND(MIN(e.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((e.min_price ) * 1, 2)) AS `std` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_entity_int` AS `at_brands` ON (`at_brands`.`entity_id` = `e`.`entity_id`) AND (`at_brands`.`attribute_id` = '509') AND (`at_brands`.`store_id` = 0) WHERE (FIND_IN_SET('16304', at_brands.value)) AND (e.min_price IS NOT NULL) 

1 Answer 1

0

You must set 0 in is_filterable column for attribute price in catalog_eav_attribute table

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.