"#2014 - Commands out of sync; you can't run this command now" returned when stored procedure does not return any result set

[javide]

Describe the bug

In phpMyAdmin 4.8.3 if you call a stored procedure that contains a SELECT statement, when this SELECT does not return a result set, this error is displayed:
#2014 - Commands out of sync; you can't run this command now

When calling the same stored procedure from the mysql command line the expected output is returned instead:

Empty set (0.70 sec)
Query OK, 0 rows affected (0.70 sec)

To Reproduce

Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem.

Server configuration

• Operating system:
• Web server:
• Database version: Server version: 5.5.5-10.1.19-MariaDB MariaDB Server
• PHP version:
• phpMyAdmin version: phpMyAdmin 4.8.3

Client configuration

• Browser:
• Operating system:

Additional context

Add any other context about the problem here.

[williamdes]

Stackoverflow: https://stackoverflow.com/a/20435243/5155484

[williamdes]

@javide I remember having this issue, can you please explain how to reproduce this issue ?
Maybe you can try on https://demo.phpmyadmin.net/QA_4_8/ ?

[williamdes]

Create the procedure

DELIMITER $$
CREATE PROCEDURE `abc`()
    NO SQL
(SELECT * FROM mysql.user WHERE 0)
UNION
(SELECT * FROM mysql.user WHERE 0)$$
DELIMITER ;

And run

CALL abc()

[williamdes]

Found the solution on https://community-auth.com/blog-posts/commands-out-of-sync-error-when-using-stored-procedures

Fixed by 9178602

[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.