This issue is not related to WeltPixel extensions but a Magento 2 upgrade issue we decided to document.
Everything works well when installing an extension on a clean Magento, but how about the upgrades? We need to keep up with the security updates, performance improvements and new features, so from time to time updating Magento is necessary and sometimes challenging as the new Magento releases are constantly changing and improving the core.
You can find below one of the common issues we encountered when upgrading Magento 2.1.x to Magento 2.2.
Module 'Magento_SalesRule': Upgrading data.. SQLSTATE: Integrity constraint violation:
1062 Duplicate entry'0-0-0-0' for key 'PRIMARY', query was:
INSERT INTO `salesrule_product_attribute` () VALUES ()
Run this Query in PhpMyAdmin and truncate below tables.
Note:This will delete data related to sales rules and coupons. Make sure to backup the database and save the tables in case you need to reimport or rebuild the rules. If you don't have custom sales rules, proceed with below query in PhpMyAdmin.
After truncating the tables, run below command via SSH in the root of you Magento installation: php bin/magento setup:upgrade