#4021 Previous Insert Query runs after editing it

4.0.4
works-for-me
Marc Delisle
sql (5) query (2)
5
2013-07-29
2013-07-14
Shakir Moledina
No

After running some queries through the SQL tab, the query is executed successfully and shows the messages (1 rows affected). However editing the box (without refreshing) runs the previous query and not the edited query.

Example:
1.) Run: insert into tests VALUES(10,1,1);

Shows: insert into tests VALUES(10,1,1);# 1 row affected.

2.) Edit textarea to

insert into tests VALUES(11,1,1);

Shows: reports that duplicate value for id because it ran the original query

insert into tests VALUES(10,1,1);

Check as I might be mistaken.

Discussion

  • Marc Delisle
    Marc Delisle
    2013-07-26

    I'm testing with 4.0.4 and cannot reproduce your problem. Moreover, when I insert, I don't get a message about rows affected but it's about rows inserted.

    Could you give more details, for example which exact SQL tab you are using? and when you click on Edit, do you get a distinct query window to edit the query?

     
  • I think I am not installing phpmyadmin properly. I always replace the files on my phpmyadmin folder which comes with xampp.

    I guess some files do not get overwritten, is that possible?

    I removed the folder and extracted the files again and it seems to work fine now.

     
  • Marc Delisle
    Marc Delisle
    2013-07-29

    • status: open --> works-for-me
    • assigned_to: Marc Delisle