GoWilkes

Well-Known Member
Sep 26, 2006
439
8
168
cPanel Access Level
Root Administrator
Sorry for the vague title, I couldn't think of a way to summarize this.

Before submitting a ticket, I wanted to see if others are having this problem. I'm using PMA v. 4.0.4.2.

When I run a command with multiple queries and no SELECT, it brings me back to a page that shows the query, and it's editable. Like:

INSERT INTO table1 VALUES ('1', '2'); # 1 row affected
INSERT INTO table2 VALUES ('3', '4'); # 1 row affected

Which is what it has always done. But when I submit a second query in this textarea, after I click "Go" it wipes out my new query, and instead runs the first one that I submitted.

Meaning, I highlight the above text in the textarea, and type or paste a new query:

INSERT INTO table3 VALUES ('5', '6');

When I click "Go", my new "table3" query disappears and the first two "table1" and "table2" queries come back, then the query submits.

The only way around this has been to click "Show Query Box" in the upper left (which shows the same thing, but with line numbers, styled formatting, and without the # 1 row affected), then type the new query there. Or, of course, I can click "SQL" in the main navigation to start over.

I hope this is explained well. If others are experiencing this, please reply and I'll submit a ticket.
 

GoWilkes

Well-Known Member
Sep 26, 2006
439
8
168
cPanel Access Level
Root Administrator
You're right, they do seem to be the same.

The last post there gives a "Fix", but without any instructions. Does this mean that I need to import their data on my end to fix it, or just that it will be fixed in an upcoming release?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
It shows a resolution is scheduled for phpMyAdmin version 4.0.6. This version has not been released yet, but when it is, internal testing will occur and it will be included with cPanel. There is currently no time frame available for that.

Thank you.