Issue - AFter installing Layered Navigation i get below error -
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, cat_index.position AS cat_index_position FROM catalog_product_flat_1 AS e
INNER JOIN catalog_category_product_index_store1 AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1')
Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause'
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, cat_index.position AS cat_index_position FROM catalog_product_flat_1 AS e
INNER JOIN catalog_category_product_index_store1 AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1')
tuyennn
commented
2 years ago
Precondtion : Magento 2.4 Module - Smile ELastic and Layered Navigation (https://landofcoder.com/magento-2-layered-navigation.html )
Issue - AFter installing Layered Navigation i get below error -
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS
status,e.entity_id,e.attribute_set_id,e.type_id,e.created_at,e.updated_at,e.sku,cat_index.positionAScat_index_positionFROMcatalog_product_flat_1ASeINNER JOINcatalog_category_product_index_store1AScat_indexON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1') Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause'Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS
status,e.entity_id,e.attribute_set_id,e.type_id,e.created_at,e.updated_at,e.sku,cat_index.positionAScat_index_positionFROMcatalog_product_flat_1ASeINNER JOINcatalog_category_product_index_store1AScat_indexON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1')