#31668 [Com]: multi_query works exactly every other time

ID: 31668 Comment by: camka at email dot ee Reported By: exaton at free dot fr Status: Open Bug Type: MySQLi related Operating System: WinXP PHP Version: 5CVS-2005-01-23 (dev) New Comment: setting query_cache_type to OFF didn't change anything. still the same error. Previous Comments: ------------------------------------------------------------------------ [2005-02-22 10:55:59] camka at email dot ee I used exaton at free dot fr 's code to reproduce the problem. And I succeeded. The following code works just as it was described above, giving the "You have an error in your SQL syntax" error or workind just fine. <?php $SQL = new mysqli(/* ... */); $SQL -> multi_query('SELECT 1;SELECT 2'); do { $res = $SQL -> store_result(); if ($SQL -> errno == 0) { while ($arr = $res -> fetch_assoc()) print_r($arr); $res -> free(); } else echo $SQL -> error; // (*) } while ($SQL -> next_result()); $SQL -> close(); ?> setting SQL_NO_CACHE directive didn't do the thing as ingmar at hackthenet dot org suggested. The query_cache_size server variable value is 0. mysql> show variables like '%query_cache%'; +------------------------------+---------+ | Variable_name | Value | +------------------------------+---------+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 0 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | +------------------------------+---------+ 6 rows in set (0.00 sec) and finally: explicite calling the query method before multy_query $SQL->query('select 343'); causes the "syntax error" error not to occure anymore. i'll try to set query_cache_type to OFF value and share the results soon. ------------------------------------------------------------------------ [2005-02-12 13:25:06] ingmar at hackthenet dot org hello, i had a very similar problem. The MySQL-Server hung up (SHOW PROCESSLIST says process is in the sleep-state) every time I refreshed the page where $db->multi_query() was called. But I found a workaround at least for SELECT-Queries. Simply use SELECT SQL_NO_CACHE * FROM tbl instead of SELECT * FROM tbl. ------------------------------------------------------------------------ [2005-02-11 19:11:33] exaton at free dot fr I'm afraid I can no longer help out here ; I needed to upgrade the DB layer my comany's web application framework fast, and have therefore switched to PostgreSQL in the meantime. camka at email dot ee, I leave this in your hands... ------------------------------------------------------------------------ [2005-02-11 16:15:00] georg@php.net Does this problem still occur when you disable MySQL's query cache? ------------------------------------------------------------------------ [2005-02-11 10:41:27] camka at email dot ee I'm facing the same problem on Linux environment. Looking forward to get the bug fixed. ------------------------------------------------------------------------ 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/31668 -- Edit this bug report at http://bugs.php.net/?id=31668&edit=1