CTRL + ENTER executing sql command 2 times

[spankandex]

Steps to reproduce

1. Select Database;
2. Select SQL query.
3. Use CTRL+Enter keys shortcut to execute query.

Expected behaviour

Executes the command once.

Actual behaviour

Executes the command twice. Try to insert only a row in a simple table. (It is inserted twice)

Server configuration

AWS AMI
Linux

Web server:
Nginx

Database:
MySQL 5.7

PHP version:
7.0.2

phpMyAdmin version:
Latest 4.8.2

Client configuration

Chrome latest version Win

[aroralakshya]

@williamdes, can you repro. this. I could not
server : apache2.4.18
php :7.2
mariadb : 10.3

[williamdes]

@nulll-pointer Yes

• Create an empty table
• Go to sql tab create an insert statement, fill with random data and CTRL+ enter
• Row is inserted twice !

Using Google Chrome

[aroralakshya]

Still can't reproduce this.

[spankandex]

Humm.. I've run the phpmyadmin "install" in a database. Then this issue started happening. Not sure if it was the update or the phpmyadmin tables

[spankandex]

I'll try to reproduce it in other server I have.
And maybe this could be a bug due to some extension like ad block or something. I'll try to reproduce in more environments. Thanks for the replies

[spankandex]

Okay. I ve found it. It only happens if you install phpmyadmin, aka running that script that create pma tables in a database. Can someone confirm this?

[spankandex]

Damn.. I've found it. I've created the phpmyadmin tables in my aplication database, not in phpmyadmin database as it is recommend to do. It was clearly my mistake. Not sure what to do with this ticket.

Resume of the situation:
-If you create the phpmyadmin tables in a database that is being used for something of your own, statements are executed twice if you use CTRL ENTER shortcut.

[spankandex]

Okay. Found it. It's another reason. Try to save a SQL query "Bookmark this SQL query" function. Once you do this, the issue I specified in bug details starts happening.

Sorry for so many redundant information.

[aroralakshya]

I could reproduce this on the demo server(master branch) by following the steps in your last comment.

[akankshya107]

Reproduced this exact error. Using the console, you can see that this error is reproduced for every single SQL command.
Server: apache2.4.18
PHP: 7.0

[vmcruz]

In summary, in order to reproduce this, the steps are:

• Go to SQL Tab and create an insert statement
• Before running the sql statement, "Bookmark this SQL query" by giving it a name
• Hit CTRL + Enter, SQL Query will be executed and saved in bookmarks, and 1 row will be inserted
• Go to SQL Tab again and create another insert statement
• Now when pressing CTRL + Enter, row is inserted twice, or PMA throws an error in case of primary keys duplicate

[Piyush3079]

Another way to reproduce this is:

1. Go to SQL Tab and execute a query by hitting CTRL + Enter.

2. The PHP server command line will show that request is sent on import.php twice.

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.