{"data":{"id":"MDVA-42689","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where Adobe Commerce throws an Integrity Constraint Violation error while updating product categories during import.","categories":["Catalog/Product"],"components":["magento/module-catalog-url-rewrite"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-12/mdva-42689-users-get-integrity-constraint-violation-error-while-updating-product-categories","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-12/mdva-42689-users-get-integrity-constraint-violation-error-while-updating-product-categories.md","blobSha":"73d54f51e84e26ef803967b6f0dd7c99eba62847","description":"Adobe Commerce throws an Integrity Constraint Violation error while updating product categories during import.","stepsToReproduce":"1. Set up two websites. 1. Create subcategories under the root category up to two levels on the category page. For example, Root Category > Gear > Watches. 1. Create two simple products and assign both the products to the same Gear > Watches category. 1. Assign one simple product to both websites. 1. Save the product. 1. Prepare a CSV file for import. There should be two product records with different store views. One of the products should belong to both these store views. 1. Now import the CSV file by navigating to System > Import > Entity Type (Products).","introducedInQpt":"1.1.12","createdFor":["2.4.3"],"documentedRange":"2.3.0 - 2.4.3-p1","scheduledFixRelease":"2.4.5"},"files":[{"package":"magento/magento2-base","constraint":">=2.3.0 <2.4.5","path":"patches/os/MDVA-42689_EE_2.4.3.patch","blobSha":"13ba02a456d87e0449a180ccdee9962f5d0ea642","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-42689_EE_2.4.3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-url-rewrite/Model/Category/Plugin/Storage.php","change":"modified","package":"magento/module-catalog-url-rewrite"}],"packages":["magento/module-catalog-url-rewrite"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","2.3.4-p2","2.3.4-p1","2.3.4","2.3.3-p2","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2","2.3.1","2.3.0"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","2.3.4-p2","2.3.4-p1","2.3.4","2.3.3-p2","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2","2.3.1","2.3.0"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","2.3.4-p2","2.3.4-p1","2.3.4","2.3.3-p2","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2","2.3.1","2.3.0"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","2.3.4-p2","2.3.4-p1","2.3.4","2.3.3-p2","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2","2.3.1","2.3.0"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/exception.log","match":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*' for key 'PRIMARY', query was: INSERT  INTO `catalog_url_rewrite_product_category` (`url_rewrite_id`,`category_id`,`product_id`) VALUES"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-42689 details"}