ID: 11015
User Update by: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
$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


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to