The Search Result page of default does not work when switching the price scope to "Store View"

Issue: 

We are using extension version 2.2.4 on Magento 2.2.6. The extension seems to work fine in general, however, as soon as we are switching the price scope to "Store View" in the Default Store Configuration, the Search Result page of Magento's default search module does not work anymore. The following error occurs there:

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.store_id' in 'where clause', query was: SELECT IFNULL(FLOOR(value / '1.0000' ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM (SELECT DISTINCT  `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav_decimal` AS `main_table`
 INNER JOIN `search_tmp_5ed0c997c2e006_67506348` AS `entities` ON main_table.entity_id  = entities.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON main_table.source_id = stock_index.product_id WHERE (main_table.attribute_id = '179') AND (main_table.store_id = '1' ) AND (stock_index.stock_status = 1)) AS `main_table` WHERE (main_table.store_id = '1') GROUP BY `range` ORDER BY `range` ASC

Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.store_id' in 'where clause'

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.store_id' in 'where clause', query was: SELECT IFNULL(FLOOR(value / '1.0000' ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM (SELECT DISTINCT  `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav_decimal` AS `main_table`
 INNER JOIN `search_tmp_5ed0c997c2e006_67506348` AS `entities` ON main_table.entity_id  = entities.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON main_table.source_id = stock_index.product_id WHERE (main_table.attribute_id = '179') AND (main_table.store_id = '1' ) AND (stock_index.stock_status = 1)) AS `main_table` WHERE (main_table.store_id = '1') GROUP BY `range` ORDER BY `range` ASC

Solution:

The issue is caused due to the fact that some attributes on your site have this config as follows:

"Catalog Input Type for Store Owner = Price" and "Use in Search Results Layered Navigation = Yes" 

Our module does not support when catalog_product_index_eav_decimal has the Price type.

However, we would like to give you the solution to resolve it.

To fix this issue, please change the config of these attributes as this "Use in Search Results Layered Navigation = No"

Please check and follow our guide.

If you need any further support, please feel free to contact us

BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.

We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.

Visit our store: https://bsscommerce.com/magento-2-extensions.html 

Don't forget to discover our top tier extensions that might boost your store performance:

• BSS Commerce’s Magento 2 B2B Extension is a trusted solution for managing complex B2B operations with ease and flexibility.
• BSS Commerce’s Magento 2 SEO Extension is a reliable tool to strengthen your SEO strategy and drive sustainable growth.