we have a problem after install BSS MultipleStoreViewPricing module ,we trying to enable the extension Stores then Configuration then Catalog.Store View to enable the module. Save Config
the problem when try to run command php bin/magento indexer:reindex get the attached error
image
enter link description here
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.store_id' in 'on clause', query was: UPDATE `catalog_product_index_price_temp` AS `i`
INNER JOIN `catalog_product_index_website` AS `cpiw` ON cpiw.website_id = i.website_id
INNER JOIN `catalogrule_product_price_store` AS `cpp` ON cpp.product_id = i.entity_id AND cpp.customer_group_id = i.customer_group_id AND cpp.store_id = i.store_id AND cpp.rule_date = cpiw.website_date
SET `i`.`final_price` = LEAST(final_price, IFNULL(cpp.rule_price, i.final_price)), `i`.`min_price` = LEAST(min_price, IFNULL(cpp.rule_price, i.min_price))
WHERE (i.entity_id IN ('1', '3', '5'))
