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!