EaDesgin / magento2-warehouses

Module to separate the stock on different store views based on warehouses.
https://www.eadesign.ro
Apache License 2.0
20 stars 19 forks source link

this extension is conflicting with Magentos layered navigation. #13

Open zhenyusun opened 6 years ago

zhenyusun commented 6 years ago

When this module is enabled, magentos layered navigation is throwing the following erros.

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause', query was: INSERT INTO `search_tmp_5ac383ed324023_32217399` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0) + (0) + (0) + (0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
 LEFT JOIN `warehouseinventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 24) AND (color_filter.value = '59') AND (style_general_filter.value = '133')) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000
Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause'

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'color_filter.value' in 'where clause', query was: INSERT INTO `search_tmp_5ac383ed324023_32217399` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0) + (0) + (0) + (0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1'
 LEFT JOIN `warehouseinventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 24) AND (color_filter.value = '59') AND (style_general_filter.value = '133')) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000