{"data":{"id":"ACSD-65540","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where an SQL syntax error occurs due to the absence of the REGEXP_LIKE function when updating the company_structure table.","categories":["B2B"],"components":["magento/module-company"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-64/acsd-65540-sql-syntax-error-occurs-due-to-the-absence-of-the-regexp-like-function-when-updating-the-company-structure-table","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-64/acsd-65540-sql-syntax-error-occurs-due-to-the-absence-of-the-regexp-like-function-when-updating-the-company-structure-table.md","blobSha":"bf3028481f4953cc4d2e0454aa9e9035b95f349d","description":"SQL syntax error occurs due to missing REGEXP_LIKE function in company_structure updates.","stepsToReproduce":"1. Update B2B to version 1.5.2. 1. Run the following command: bin/magento setup:upgrade","introducedInQpt":"1.1.64","createdFor":["1.5.2"],"documentedRange":"1.5.2","scheduledFixRelease":null},"files":[{"package":"magento/magento2-b2b-base","constraint":"1.5.2","path":"patches/commerce/ACSD-65540_B2B_1.5.2.patch","blobSha":"33e5683a3c98f215148bd8a549d6f6b62488d94a","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-65540_B2B_1.5.2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-company/Setup/Patch/Data/SetCompanyForStructure.php","change":"modified","package":"magento/module-company"}],"packages":["magento/module-company"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8","2.4.7-p5","2.4.6-p10"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8","2.4.7-p5","2.4.6-p10"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-65540 details"}