MDVA-43601: Triggers are removed from catalogrule_product_price table…
Triggers are removed from catalogrule_product_price table after a full reindex of catalogrule_rule or catalogrule_product. Quality patch MDVA-43601 for magento/module-catalog-rule applies to Magento Open Source and Adobe Commerce 2.3.0 to 2.4.4-p18.
- Categories
- Catalog/Product
- Components
- magento/module-catalog-rule
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.13
Issue
Triggers are removed from catalogrule_product_price table after a full reindex of catalogrule_rule or catalogrule_product.
Steps to reproduce
1. Set all the indexers to Update by Schedule. 1. Check the triggers created for catalogrule_product_price table by running the following SQL request: show triggers like '%catalogrule_%'\G 1. Manually reindex catalogrule_rule or catalogrule_product by running the following command: bin/magento indexer:reindex catalogrule_rule 1. Check the triggers of catalogrule_product_price table again.
Adobe's page lists 2.3.0 - 2.4.4 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.5.
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 MDVA-43601. On Cloud, add MDVA-43601 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-43601/ 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-base >=2.3.0 <2.4.3
- Magento Open Source
- 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
- Adobe Commerce
- 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
- Requires
- MDVA-38608-V2
- Patch file
- patches/os/MDVA-43601_2.4.1.patch
- vendor/magento/module-catalog-rule/Model/Indexer/IndexerTableSwapper.php
magento/magento2-base >=2.4.3 <2.4.5
- Magento Open Source
- 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
- Adobe 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
- Patch file
- patches/os/MDVA-43601_2.4.1.patch
- vendor/magento/module-catalog-rule/Model/Indexer/IndexerTableSwapper.php
