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

ID: 11015 User Update by: iplount@comcity.com Old-Status: Feedback Status: Open Bug Type: MySQL related Operating system: Redhat 7.0 PHP Version: 4.0.5 Description: Warning: MySQL: Unable to save result set in Well I fixed my problem. I had to go through and find every file and directory that PHP created and delet them. Be sure to also delete the php4 module directory in your apache source tree. Now presumably all things related to the existing PHP install are gone. Now delete your existing php source directory. Then unzip and de-tar the php distribution again. When you configure php this time use the following config parameters --prefix=/path/to/some/directory --exec-prefix=/path/to/someother/directory Now I assume I know exactly where everything is going and PHP won't look anywhere else for the items that get installed in the above locations. This way I know it is using the latest compiled stuff. It seems that if you configure, make, make install it doesn't necassarily write over older files. Very frustrating. Should'nt older item be overwritten when you re-configure and install? Anyway this is how I got PHP to work again. The previous suggestion did not work. Also, I couldn't find a documented case for mysql.default_socket for the PHP.ini file in any of the online documentation? Previous Comments: --------------------------------------------------------------------------- [2001-05-22 17:25:09] sniper@php.net Check where the unix socket is pointing '/path/to/mysql_config --socket' and try adding that to php.ini: mysql.default_socket=/path/to/socket --Jani --------------------------------------------------------------------------- [2001-05-22 08:54:12] iplount@comcity.com $SQLStmt = CreateSQLArray(); $numElements = Count($SQLStmt); //dies here when trying to make the link $link = mysql_connect($host, $user, $password); //other mysql functions seem to work fine at times for($x = 0; $x < $numElements; $x++){ mysql_db_query($dbname, $SQLStmt[$x], $link); if(mysql_error($link) != ""){ $SQLErrors[] = mysql_error($link); } } /* I have included the absolute path to my mysql install directory during configuration and I continue to get this error. I have compiled and recompiled mysql, apache, and php I don't know how many times. This is very frustrating as I have succesfully installed previous version of all with minor problems compared to this. */ --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=11015