{"data":{"id":"ACSD-50478","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the JS issue for the rollback action in the Backups grid. Fixes the database rollback command for a case when the DB dump contains triggers and a \"delimiter\" SQL command.","categories":["Admin","Other"],"components":["magento/framework","magento/module-backend","magento/module-backup"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-33/acsd-50478-database-rollback-command-when-db-dump-contains-triggers","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-33/acsd-50478-database-rollback-command-when-db-dump-contains-triggers.md","blobSha":"cb346892c7f1f15302eb24bb5c26ad2c944054b4","description":"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.","stepsToReproduce":"1. Set indexers to Update on Schedule mode so that triggers are created in the database. 1. Enable the backup functionality from the command line: bin/magento config:set system/backup/functionality_enabled 1 1. Go to System > Tools > Backups and generate a DB backup. 1. Open the browser console; you will see the following error: Uncaught SyntaxError: Unexpected token '&' (at (index):606:32) function eventListener8jtGaqtgG2 () { return backup.rollback(&#039;db&#039;, &#039;1678391644&#039;); 1. Try to import the DB from the command line: bin/magento setup:rollback --db-file=\"<filename>\" 1. 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 ;;","introducedInQpt":"1.1.33","createdFor":["2.4.3-p1"],"documentedRange":"2.4.0 - 2.4.4-p4","scheduledFixRelease":"2.4.7"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.0 <2.4.5","path":"patches/os/ACSD-50478_2.4.3-p1.patch","blobSha":"498f19817d2ac403753598b987ad6024df5fde3b","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-50478_2.4.3-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-backend/Block/Widget/Grid/Column/Renderer/Action.php","change":"modified","package":"magento/module-backend"},{"path":"vendor/magento/module-backup/Model/ResourceModel/Db.php","change":"modified","package":"magento/module-backup"},{"path":"vendor/magento/framework/Backup/Filesystem/Iterator/File.php","change":"modified","package":"magento/framework"}],"packages":["magento/module-backend","magento/module-backup","magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-50478 details"}