Bug #12029 Updated: "--with-apxs" can cause the error "MySQL: Unable to save result set in"

ID: 12029 Updated by: levi@tamisoft.com Reported By: root@byone.com Status: Bogus Bug Type: MySQL related Operating System: Linux PHP Version: 4.0.6 and 4.1.0RC3 New Comment: I found the same problem with: mysql 3.23.51 php 4.1.2 later 4.2.1 roxen I found a possible way to resolv it. Use like this: $query="INSERT INTO test.test SET str=\"a test\""; @mysql_query($query); if (mysql_error()) {echo "Some error occured!";exit();} And this way you won't get the warning. The only thing is that you cannot use the returned value itself directly, you have to use mysql_error() to see if everything went ok. PLZ let me know if it's not ok. It is working for me fine. Previous Comments: ------------------------------------------------------------------------ [2002-01-23 10:48:20] mrobinso@php.net Apache is installed with mod_log_mysql and mod_auth-mysql, and php is installed with the built-in clients. http://www.php.net/manual/en/faq.databases.php#AEN73271 Please reopen with a url to a phpinfo() call if problem persists. ------------------------------------------------------------------------ [2002-01-23 09:29:40] mrobinso@php.net rami@eduix.com, can you post a page with phpinfo() on it somewhere so I can have a look please. I've never had any problems with mysql and pgsql co-existing with php. ------------------------------------------------------------------------ [2002-01-23 04:48:46] rami@eduix.com I'm pretty sure these unable to save result set are due to pgsql and mysql co-existence in self-compiled php. Our service worked well without problems for 8 months with only mysql compiled in, but php started complaining this immediately when we compiled the pgsql in also. So this looks like a true bug allright. ------------------------------------------------------------------------ [2001-11-27 02:23:32] mfischer@php.net Suspended at user request. ------------------------------------------------------------------------ [2001-11-27 01:44:01] root@byone.com I had upgraded mysql and recompiled php-4.1.0RC3 as "./configure" but still nothing changed. I think the error may relate to my apache-1.3.14. Unfortunately my job was changed, and now I have got no time to update my apache and other modules, sometime or other I will update them all, I wish all would be fine at that time. So if someone others didn't meet this problem, close this thread. THX for support. ------------------------------------------------------------------------ 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/12029 -- Edit this bug report at http://bugs.php.net/?id=12029&edit=1