Bug #16906 Updated: Warning: MySQL: Unable to save result set in ...

ID: 16906 Updated by: cynic@php.net Reported By: vermut@aija.net -Status: Open +Status: Assigned Bug Type: MySQL related Operating System: FreeBSD PHP Version: 4.1.2, 4.2.0 -Assigned To: +Assigned To: cynic New Comment: this works with 4.3.0-dev, I'll have to try 4.2.1 tomorrow. roman@freepuppy ~/install/php4 > cat ./config.nice.cli+apxs 192:0 #! /bin/sh # # Created by configure './configure' \ '--enable-cli' \ '--enable-inline-optimization' \ '--enable-ftp' \ '--enable-shmop' \ '--enable-sysvsem' \ '--enable-sysvshm' \ '--enable-sockets' \ '--enable-tokenizer' \ '--disable-session' \ '--disable-shared' \ '--with-apxs=/usr/local/sbin/apxs' \ '--with-openssl' \ '--with-zlib' \ '--with-bz2' \ '--with-curl' \ '--with-gettext' \ '--with-iconv' \ '--with-mcrypt=/usr/local' \ '--with-mhash=/usr/local' \ '--with-ncurses' \ '--with-readline' \ '--with-pear' \ '--with-config-file-path=/usr/local/etc' \ '--with-mysql=/usr/local' \ "$@" <? mysql_connect('localhost', 'root', ''); mysql_select_db('mysql'); $rs = mysql_query("UPDATE user set user='root' where user='root'"); if (!$rs) printf("%d: %s\n\n", mysql_errno(), mysql_error()); else print("all clear\n\n"); output: all clear Previous Comments: ------------------------------------------------------------------------ [2002-05-02 13:24:13] vermut@aija.net As I said - every update query fails. I use this example: <?php define ("DB_HOST","localhost"); define ("DB_LOGIN","root"); define ("DB_PSW","password"); define ("DB_NAME","mysql"); mysql_connect(DB_HOST,DB_LOGIN,DB_PSW); mysql_select_db(DB_NAME); mysql_query("UPDATE user set user='root' where user='root'"); ?> Query, executed directly in mysql, works. ------------------------------------------------------------------------ [2002-05-02 06:34:30] sniper@php.net Please add SHORT but complete example script to this report which can be used to reproduce this. --Jani ------------------------------------------------------------------------ [2002-05-01 05:31:49] vermut@aija.net The problem is: _every_ UPDATE query executed from PHP reports this warning. Data become updated, but execution stops. The same query executed in plain mysql does the same, but does not report a warning. ------------------------------------------------------------------------ [2002-04-30 20:12:41] msopacua@idg.nl This error occured with me, when synching topics in phpBB admin. But my theory is, that for some MySQL errors, php is unable to get the right error string and defaults to 'unable to get result'. The error does show, when you use the mysql client CLI. Could you test that, by executing the exact query that fails, via the mysql client CLI? ------------------------------------------------------------------------ [2002-04-29 11:35:39] vermut@aija.net mysql> CHECK TABLE wpm_tree_en; +----------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+-------+----------+----------+ | project3.wpm_tree_en | check | status | OK | +----------------------+-------+----------+----------+ 1 row in set (0.03 sec) Everything fine, as i see. I do run phpBB, but i run a completely different and unrelated test script. I've done myisamchk -r on all tables. ------------------------------------------------------------------------ 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/16906 -- Edit this bug report at http://bugs.php.net/?id=16906&edit=1