Can't see SQL after adding new column in 5.1.0

[wotnotweb]

Describe the bug

Page refreshes immedaitely back to structure so can't see the SQL that was entered after adding a new column

To Reproduce

Steps to reproduce the behavior:

1. Go to table structure tab
2. Click Go to add column
3. Enter details and click save
4. Page refreshes immedaitely so can't see the SQL that was entered

Expected behavior

The refresh to the structure view is a good improvement but the SQL should still be displayed as it useful to copy for logging what was done.

Screenshots

Server configuration

• Operating system: Linux
• Web server: Apache
• Database version: 5.5.68-MariaDB
• PHP version: 7.3.27
• phpMyAdmin version: 5.1.0

Client configuration

• Browser: Firefox
• Operating system: Win 10

Additional context

Add any other context about the problem here.

[williamdes]

Hi @wotnotweb
Thank you for your comments on that, I agree that could be improved

[sradhanjan]

@wotnotweb You can click the console which is at the bottom left side of the page to check the SQL query you have just entered
(before)

(after clicking console)

[wotnotweb]

Many thanks, I can use that, I'm just used to it being at the top after the change.

Incidentally there is one thing that has never been shown after an action which is the move columns interface. It is not shown at the top or in the console. I have to remember to use the preview SQL and copy it first if I need to replicate it.

[toxpal]

Came here to report the same. Version 5.1.0 actually displays SQL query at the top (just like old versions), but it does so for half a second, and then page refreshes, which is very annoying.

Devs, please bring the old behavior back.

[williamdes]

cc @MauricioFauth what is your opinion ?

[toxpal]

The issue still exists in 5.1.1

[williamdes]

As said in #17088 I thinks this is due to #15675
I marked this to be done soon as I take the reports about this behavior seriously. I understand it is annoying to not be able to copy the query

[williamdes]

I just created #17089
Feel free to try it here: #17089 (comment)