ACSD-56741: An error message Trying to access array offset on value of type null appears…

Categories

Other

Components

magento/framework

Origin

adobe-commerce-support

Since QPT

1.1.48

Issue

An error message Trying to access array offset on value of type null appears during setup:upgrade due to a custom MySQL trigger in the database unrelated to indexation and MView.

Steps to reproduce

1. Run php bin/magento indexer:set-mode schedule. DELIMITER // CREATE TRIGGER trg_catalog_category_entity_before_delete_umis BEFORE DELETE ON catalog_category_entity FOR EACH ROW -> BEGIN -> UPDATE ewave_navigation_menu_item_info as nit INNER JOIN ewave_navigation_menu_category_type as ncmi ON nit.id = ncmi.menu_item_id AND ncmi.category_id = OLD.entity_id SET nit.status = 0; -> END // 1. Run php bin/magento c:f. 1. Run php bin/magento setup:upgrade.

Adobe's page lists 2.4.6 - 2.4.6-p4 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.5.0.

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-56741. On Cloud, add ACSD-56741 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-56741/ 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

Sources

• Adobe documentation for ACSD-56741
• JSON API: /api/v1/patches/ACSD-56741