v2.2.7: How to fix incompatible issue between module with M2.4.2 EE?

QUESTION:

I installed the module v2.2.7 for M2.3.4 - M2.3.5 for Enterprise Edition on my site Magento M2.4.2 EE. 

However, since your module is not compatible with M2.4.2 EE so that we couldn't run command bin/magento setup:upgrade

And it shows the error below when saving product: 

] report.CRITICAL: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price_replica` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) SELECT `catalog_product_index_price_store_temp`.`entity_id`, `catalog_product_index_price_store_temp`.`customer_group_id`, `catalog_product_index_price_store_temp`.`website_id`, `catalog_product_index_price_store_temp`.`store_id`, `catalog_product_index_price_store_temp`.`tax_class_id`, `catalog_product_index_price_store_temp`.`price`, `catalog_product_index_price_store_temp`.`final_price`, `catalog_product_index_price_store_temp`.`min_price`, `catalog_product_index_price_store_temp`.`max_price`, `catalog_product_index_price_store_temp`.`tier_price` FROM `catalog_product_index_price_store_temp` ON DUPLICATE KEY UPDATE `entity_id` = VALUES(`entity_id`), `customer_group_id` = VALUES(`customer_group_id`), `website_id` = VALUES(`website_id`), `tax_class_id` = VALUES(`tax_class_id`), `price` = VALUES(`price`), `final_price` = VALUES(`final_price`), `min_price` = VALUES(`min_price`), `max_price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`) {"exception":"[object] (Magento\\Framework\\Exception\\LocalizedException(code: 0): SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price_replica` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) SELECT `catalog_product_index_price_store_temp`.`entity_id`, `catalog_product_index_price_store_temp`.`customer_group_id`, `catalog_product_index_price_store_temp`.`website_id`, `catalog_product_index_price_store_temp`.`store_id`, `catalog_product_index_price_store_temp`.`tax_class_id`, `catalog_product_index_price_store_temp`.`price`, `catalog_product_index_price_store_temp`.`final_price`, `catalog_product_index_price_store_temp`.`min_price`, `catalog_product_index_price_store_temp`.`max_price`, `catalog_product_index_price_store_temp`.`tier_price` FROM `catalog_product_index_price_store_temp` ON DUPLICATE KEY UPDATE `entity_id` = VALUES(`entity_id`), `customer_group_id` = VALUES(`customer_group_id`), `website_id` = VALUES(`website_id`), `tax_class_id` = VALUES(`tax_class_id`), `price` = VALUES(`price`), `final_price` = VALUES(`final_price`), `min_price` = VALUES(`min_price`), `max_price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`) at /xxxx/xxxx/xxxx/xxxx/app/code/Bss/MultiStoreViewPricingPriceIndexer/Model/Indexer/Product/Price/Action/Full.php:173, Zend_Db_Statement_Exception(code: 21): SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price_replica` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) SELECT `catalog_product_index_price_store_temp`.`entity_id`, `catalog_product_index_price_store_temp`.`customer_group_id`, `catalog_product_index_price_store_temp`.`website_id`, `catalog_product_index_price_store_temp`.`store_id`, `catalog_product_index_price_store_temp`.`tax_class_id`, `catalog_product_index_price_store_temp`.`price`, `catalog_product_index_price_store_temp`.`final_price`, `catalog_product_index_price_store_temp`.`min_price`, `catalog_product_index_price_store_temp`.`max_price`, `catalog_product_index_price_store_temp`.`tier_price` FROM `catalog_product_index_price_store_temp` ON DUPLICATE KEY UPDATE `entity_id` = VALUES(`entity_id`), `customer_group_id` = VALUES(`customer_group_id`), `website_id` = VALUES(`website_id`), `tax_class_id` = VALUES(`tax_class_id`), `price` = VALUES(`price`), `final_price` = VALUES(`final_price`), `min_price` = VALUES(`min_price`), `max_price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`) at /xxxx/xxxx/xxxx/xxxxx/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 21S01): SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 at /xxxx/xxx/xxxx/xxxx/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} [] 

Please provide us the fix!

ANSWER: 

The error happened because module Bss_MultipleStoreViewPricing is not compatible with M2.4.2 EE.

To fix this error, please remove 3 files below:

+ app/code/Bss/MultiStoreViewPricing/Model/CatalogSearch/Adapter/Mysql/Dynamic/DataProvider.php

+ app/code/Bss/MultiStoreViewPricing/Model/Search/FilterMapper/ExclusionStrategy.php

+ app/code/Bss/MultiStoreViewPricing/Plugin/Filter/Price/DataProvider.php

And download the 4 files attached and override the current files on your site. 

+ app/code/Bss/MultiStoreViewPricing/Model/ResourceModel/Product/Indexer/LinkedProductSelectBuilderByIndexPr

ice.php 

+ app/code/Bss/MultiStoreViewPricing/etc/frontend/di.xml 

+ app/code/Bss/MultiStoreViewPricingPriceIndexer/Model/Indexer/Product/Price/TableMaintainer.php 

+ app/code/Bss/MultiStoreViewPricingPriceIndexer/Model/ResourceModel/Product/Indexer/Price/Bundle.php

 If you need any further assistance, please feel free to contact us. We'd be happy to support!  

Learn more about us

BSS Commerce is a full-service ecommerce agency with 14+ years of experience, supporting 75,000+ customers worldwide. As an Adobe Commerce Solution Bronze Partner and Select Magento Extensions Builder, we deliver trusted end-to-end solutions.

Our core strength is Magento, with 150+ extensions designed to enhance store performance and drive growth. With deep expertise from years of working on Magento websites, we deliver scalable, high-impact solutions backed by strong client trust.

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

Our Magento B2B Extension by BSS Commerce is a flagship, widely used global solution, providing an all-in-one system for pricing, account management, and efficient B2B workflows