{"data":{"id":"ACSD-56741","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes an error message \"Trying to access array offset on value of type null\" that displays during setup:upgrade when the database contains a custom MySQL trigger not related to the indexation mechanism and MView.","categories":["Other"],"components":["magento/framework"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-48/acsd-56741-database-setup-upgrade-error-with-custom-mysql-trigger","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-48/acsd-56741-database-setup-upgrade-error-with-custom-mysql-trigger.md","blobSha":"eb700ded4a458a5a621eaa1852a635fa35c437c2","description":"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.","stepsToReproduce":"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.","introducedInQpt":"1.1.48","createdFor":["2.4.6-p3"],"documentedRange":"2.4.6 - 2.4.6-p4","scheduledFixRelease":"2.5.0"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.6 <2.4.7","path":"patches/os/ACSD-56741_2.4.6-p3.patch","blobSha":"2d4a782558f35a0878152b87c91fc7ec5bfcc1c1","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-56741_2.4.6-p3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/framework/Mview/TriggerCleaner.php","change":"modified","package":"magento/framework"}],"packages":["magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["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"],"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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["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"],"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"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-56741 details"}