php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #11015 Warning: MySQL: Unable to save result set in
Submitted: 2001-05-22 08:54 UTC Modified: 2001-05-22 23:05 UTC
From: iplount at comcity dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.5 OS: Redhat 7.0
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-05-22 08:54 UTC] iplount at comcity dot 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.
*/

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-22 17:25 UTC] 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 22:58 UTC] iplount at comcity dot com 
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?
 [2001-05-22 23:05 UTC] sniper@php.net 
solved -> closed. 

Try looking into php.ini-dist file and you'll find the 
directive..

--Jani
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 19 15:01:28 2024 UTC