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.
Please visit our site for more useful Magento 2 Extensions: https://bsscommerce.com/magento-2-extensions.html