ACSD-50478: JS issue for rollback action in backups grid and database rollback command

The ACSD-50478 patch fixes the JS issue for the rollback action in the backups grid and the database rollback command for a case when the DB dump contains triggers and a delimiter SQL command. This patch is available when the Quality Patches Tool (QPT) 1.1.33 is installed. The patch ID is ACSD-50478. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.7.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.3-p1

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.0 - 2.4.4-p4
NOTE

The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

JS issue for the rollback action in the Backups grid and the database rollback command for a case when the DB dump contains triggers and a delimiter SQL command.

Steps to reproduce:

  1. Set indexers to Update on Schedule mode so that triggers are created in the database.

  2. Enable the backup functionality from the command line:

    bin/magento config:set system/backup/functionality_enabled 1

  3. Go to System > Tools > Backups and generate a DB backup.

  4. Open the browser console; you will see the following error:

    Uncaught SyntaxError: Unexpected token '&' (at (index):606:32)

function eventListener8jtGaqtgG2 () {

        return backup.rollback('db', '1678391644');

  5. Try to import the DB from the command line:

    bin/magento setup:rollback --db-file="<filename>"

  6. The following error appears:

    Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'delimiter' at line 1, query was: delimiter ;;

Expected results:

The database restoration is successful from both the Admin and the command line.

Actual results:

You observed the errors mentioned in step 4 and step 6.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.

On this page