ID: 35333
Updated by: [EMAIL PROTECTED]
Reported By: camka at email dot ee
-Status: Open
+Status: Bogus
Bug Type: MySQLi related
Operating System: WinXP, Linux
PHP Version: 5CVS-2005-11-22 (snap)
New Comment:
Report that to Mysql, it is not PHP problem.
Previous Comments:
------------------------------------------------------------------------
[2005-11-22 23:15:51] camka at email dot ee
but still, if i use selects in multi_query:
$s -> multi_query("select 1;select 2");
and then
$s -> query("select 3");
i get more understandable error
- 2014 - Commands out of sync; you can't run this command now
Why then the server goes away in case of non-select queries?
Out of sync error would be less confusing.
------------------------------------------------------------------------
[2005-11-22 19:42:49] [EMAIL PROTECTED]
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php
After executing mysqli_multi_query you have first process the
resultsets before sending any another statement to the server,
otherwise your socket is still blocked.
Please note that even if your multi statement doesn't contain SELECT
queries, the server will send result packages containing errorcodes (or
OK packet) for single statements.
------------------------------------------------------------------------
[2005-11-22 18:02:15] camka at email dot ee
the same behaviour with the latest snapshot. no changes.
------------------------------------------------------------------------
[2005-11-22 17:49:00] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
------------------------------------------------------------------------
[2005-11-22 16:07:36] camka at email dot ee
may be related to bug #31668
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35333
--
Edit this bug report at http://bugs.php.net/?id=35333&edit=1
