Merge pull request #14216 from Piyush3079/PMA_14212

Fix XML Export fatal error and add Move columns preview SQL

1 files changed, 5 insertions, 2 deletions

diff --git a/js/tbl_structure.js b/js/tbl_structure.js
index bb26f3b8bb..92808d94b9 100644
--- a/js/tbl_structure.js
+++ b/js/tbl_structure.js
@@ -297,14 +297,12 @@ AJAX.registerOnload('tbl_structure.js', function () {
             var $this = $(this);
             var $form = $this.find('form');
             var serialized = $form.serialize();
-
             // check if any columns were moved at all
             if (serialized === $form.data('serialized-unmoved')) {
                 PMA_ajaxRemoveMessage($msgbox);
                 $this.dialog('close');
                 return;
             }
-
             $.post($form.prop('action'), serialized + PMA_commonParams.get('arg_separator') + 'ajax_request=true', function (data) {
                 if (data.success === false) {
                     PMA_ajaxRemoveMessage($msgbox);
@@ -347,6 +345,11 @@ AJAX.registerOnload('tbl_structure.js', function () {
                 }
             });
         };
+        button_options[PMA_messages.strPreviewSQL] = function () {
+            // Function for Previewing SQL
+            var $form = $('#move_column_form');
+            PMA_previewSQL($form);
+        };
         button_options[PMA_messages.strCancel] = function () {
             $(this).dialog('close');
         };