#4338 (ok 4.1.12) Executing queries in SQL tab broken

[Raimund Meyer]

1. Open the SQL tab in a database or table
2. Enter some SQL in the textfield
3. Hit OK
4. Alert box says "Missing value in the form"

[Raimund Meyer]

Same with SQL box in the popup when you click "edit"

[Ashutosh Dhundhara]

Hello Raimund,
I think this happens when you omit the Delimiter, when writing the query in the box, in the end.

[anr]

Apparently, the delimiter ";" given at the end of query worked

[Marc Delisle]

Raimund,
I cannot reproduce with current master (f1b7735cc78067bc3ba0e350dc7b3d727947a41e).

[Raimund Meyer]

It's positively in the latest master, see screenshot.
anr seems to be right, it seems to be only when you don't have a ; at the end. On the other hand I could reproduce it with a normal dump

[Raimund Meyer]

Additionally, it seems sporadic. I first to one screenshot where it didn't work, then directly afterward, it worked

[Marc Delisle]

Raimund,
it seems to happen only if I don't type anything in the box (executing the default query that appears there on entering). I can even cut&paste the default query, then it will work.
Can you confirm?

[Smita Kumari]

Copy and pasting the below query don't work.. at least never worked for me.

create table missing_val (
id integer
)

Also if we add ';' or anything other than space in the end it works as the sqlQuery has some value other than space that is ';'.
here is a pull request, I have submitted to fix the same, let me know if it looks fine.
https://github.com/phpmyadmin/phpmyadmin/pull/1094

[Michal Čihař]

Merged https://github.com/phpmyadmin/phpmyadmin/pull/1094