ACSD-65540: SQL syntax error occurs due to missing REGEXP_LIKE function in company_structure updates

Categories

B2B

Components

magento/module-company

Origin

adobe-commerce-support

Since QPT

1.1.64

Issue

SQL syntax error occurs due to missing REGEXP_LIKE function in company_structure updates.

Steps to reproduce

1. Update B2B to version 1.5.2. 1. Run the following command: bin/magento setup:upgrade

Adobe's page lists 1.5.2 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

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-65540. On Cloud, add ACSD-65540 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-65540/ 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-65540
• JSON API: /api/v1/patches/ACSD-65540