|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-01-10 06:26 UTC] georg@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2026 The PHP GroupAll rights reserved. |
Last updated: Wed Jan 07 18:00:02 2026 UTC |
Description: ------------ New version of libmysql.dll and php_mysql.dll do not support running more than one stored procedure within the same connection. The second stored procedure will cause the lost of connection. The old version 5.1.2 do not have this kind of problem. Reproduce code: --------------- <?php mysql_connect($hostname, $db_login, $db_pass, FALSE, 65536) or die("Could not connect: ".mysql_error()); mysql_select_db($database) or die("Could not select database: ".mysql_error()); $result = mysql_query("CALL SelectUsersCount()") or die("Query failed: ".mysql_error()); if (mysql_result($result, 0, 0)) { $result = mysql_query("CALL SelectUsers()") or die("Query failed: ".mysql_error()); } mysql_close(); ?> Expected result: ---------------- Should not lose the connection when executing the second stored procedure within the same connection Actual result: -------------- Lost connection to MySQL server during query