ACSD-48417: An SQL error appears after creating a schedule change for a product and saving another…
An SQL error appears after creating a schedule change for a product and saving another product. Quality patch ACSD-48417 for magento/module-configurable-product-staging applies to Magento Open Source and Adobe Commerce 2.4.5 to 2.4.6-p15.
- Categories
- Admin
- Components
- magento/module-configurable-product-staging
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.26
Issue
An SQL error appears after creating a schedule change for a product and saving another product.
Steps to reproduce
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.
Adobe's page lists 2.4.5 - 2.4.6 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Adobe scheduled the permanent fix for 2.4.7.
Install
Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-48417. On Cloud, add ACSD-48417 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-48417/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.
Patch files and compatible versions
magento/magento2-ee-base >=2.4.5 <2.4.7
- Magento Open Source
- —
- Adobe 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
- vendor/magento/module-configurable-product-staging/Plugin/Catalog/UpdateConfigurationsStaging.php
