Multiple storeview pricing: Reindex and di:compile error on Magento 2.2.3 and lower

Question:

When installing v2.1.5 Multiple storeview pricing on Magento 2.2.0 - 2.2.3 , we encountered the error:

Module 'Bss_MultiStoreViewPricingPriceIndexer':
Installing schema... SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table 'catalog_product_index_price_store', query was: CREATE TABLE IF NOT EXISTS `catalog_product_index_price_store`

How can we fix it?

Answer: 

Please do the following steps: 

Step 1: Install the 2.1.5 version for M2.2.x CE

Step 2: On Magento 2.2.4 (on which we develop the extension), there is a class: app/code/Bss/MultiStoreViewPricingCatalogRule/Model/Indexer/IndexBuilder.php:39:use Magento\CatalogRule\Model\Indexer\IndexerTableSwapperInterface, but Magento 

2.2.3 and lower do not have, so we should move Indexer folder of v2.1.1 (attached) to this folder of the site: /home/[sitename]/public_html/app/code/Bss/MultiStoreViewPricingCatalogRule/Model/Indexer

Step 3: Add this folder to app/code

https://www.dropbox.com/s/c0qbufgz0ewgse6/Bss_MultiStoreViewPricingFixFor222.zip?dl=0

If you need further assistance, please don't hesitate to contact us. Don't forget that 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.

Our most powerful extensions are BSS Commerce’s Magento 2 B2B Extension & BSS Commerce’s Magento 2 SEO Extension

Please visit our site for more useful Magento 2 Extensions: https://bsscommerce.com/magento-2-extensions.html