{"data":{"id":"ACSD-48417","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where an SQL error appears after creating a schedule change for a product and saving another product.","categories":["Admin"],"components":["magento/module-configurable-product-staging"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-26/acsd-48417-sql-error-after-creating-a-schedule-change","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-26/acsd-48417-sql-error-after-creating-a-schedule-change.md","blobSha":"af72aa75f27ca1f67592dff2b8d4a8d9f65975e4","description":"An SQL error appears after creating a schedule change for a product and saving another product.","stepsToReproduce":"1. Install Magento 2.4-develop EE + Sample Data. 1. Go to the admin panel > Catalog > Products. 1. Edit any product (e.g., Joust Duffle Bag [SKU: 24-MB01]). 1. Schedule a new update: * Select Save as a New Update * Update name: \"Update 1\" * Start Date: current time +1 min * End Date: current time +1 hour * Modify Product name to: \"Joust Duffle Bag 2\" * Save the product. 1. Go to CLI and execute cron and wait till the schedule is applied. bin/magento cron:run && bin/magento cron:run 1. Again, go to Catalog > Products and edit any configurable product (e.g., Chaz Kangeroo Hoodie [SKU: MH01]). * Disable all variants. Go to the Actions column > Select > Disable Product. * Save the configurable one.","introducedInQpt":"1.1.26","createdFor":["2.4.1-p1"],"documentedRange":"2.4.5 - 2.4.6","scheduledFixRelease":"2.4.7"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.5 <2.4.7","path":"patches/commerce/ACSD-48417_2.4.5-p1.patch","blobSha":"c87f059635b1ef7e5fe110c979435cc6182efd67","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-48417_2.4.5-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-configurable-product-staging/Plugin/Catalog/UpdateConfigurationsStaging.php","change":"modified","package":"magento/module-configurable-product-staging"}],"packages":["magento/module-configurable-product-staging"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/support_report.log","match":"*Integrity constraint violation: 1048 Column 'sku' cannot be null, query was: INSERT INTO `catalog_product_entity` (`entity_id`, `sku`, `row_id`, `created_in`, `updated_in`) VALUES *"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-48417 details"}