StoredProcedurenotreturningSelectStmt.result

In my webhosting environment (*mentioned below) When I m trying to execute stored procedure on PhpMydadmin which is having a select statement to get data from MYSQL database it is giving error below error.

Error :: "#1312 - PROCEDURE hemant04_namdev.Get_UserDetails can't return a result set in the given context"

Environment ::

IMySQL

Server: Localhost via UNIX socket
Server version: 5.1.56
Protocol version: 10
User: hemant04
MySQL charset: UTF-8 Unicode (utf8)

Web server

cpsrvd 11.30.6.3
MySQL client version: 5.1.56
PHP extension: mysql

phpMyAdmin

Version information: 3.4.9

But same stored procedure is running fine in old version on phpMyadmin which is a case in my development machine

Development Machine environment

MySQL

Server: localhost via TCP/IP
Server version: 5.5.16
Protocol version: 10
User: root
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1
MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $
PHP extension: mysql

phpMyAdmin

Version information: 3.4.5, latest stable version: 3.4.9

• Original URL: https://sourceforge.net/p/phpmyadmin/support-requests/1182/


• Original author: hemant04

该提问来源于开源项目：phpmyadmin/phpmyadmin