The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Glitch in phpMyAdmin

Discussion in 'Database Discussions' started by GoWilkes, Aug 15, 2013.

  1. GoWilkes

    GoWilkes Well-Known Member

    Joined:
    Sep 26, 2006
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,761
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. GoWilkes

    GoWilkes Well-Known Member

    Joined:
    Sep 26, 2006
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,761
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page