ID: 12148
User updated by: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Solaris x86
Old PHP Version: 4.0.6 & 4.0.5 & latest dev as of 7/16/2001
PHP Version: 4.0.6 & 4.0.5
New Comment:

Here is how I got things to work.  I did this with the latest php4 dev CVS snapshot 
(which also has the same error) but it should
work on 4.0.6 also.  I believe this problem is a problem with different version of the 
MySQL API that PHP is using.  MySQL just made
some changes to their API with the last couple of versions the latest 3.23.39 is what 
I am running and what I experienced the
problem with.

Build PHP with --with-mysql but DO NOT specify the path to mysql.  By not specifying 
the path mysql will use its built-in static
version of the mysql client lib.  There is a warning that doing this this way will not 
work when using mysql-auth apache module but
I use the latest version of mysql-auth and found no problems.

Previous Comments:

[2001-07-16 11:35:55] [EMAIL PROTECTED]

using MySQL version 3.23.39


[2001-07-13 13:51:29] [EMAIL PROTECTED]

Im using PHP 4.0.6 install on Solaris x86 with mysql 3.23.39.  The following code 
produces causes mysql_query to return false, but the database update works!

$query .= "WHERE User_Name = '$User_Name[$i]'" ;
    $sth = mysql_query($query) or die ("<p>ERROR: Update Query Failed<p>$query<BR>") ;
    if ($verbose) {
        print ("$query<BR>");

Here is the error message generated by the code:
ERROR: Update Query Failed
UPDATE Padmin SET Full_Name = 'Corin Cody', Admin = 1 WHERE User_Name = 'ccody'

I was recieving the following warning from the code above until I changed 
error_reporting = E_ERROR
Warning: MySQL: Unable to save result set in 
 on line 26

Here are my PHP build options:
CC=gcc OPTIM="-O2" EXTRA_LIBS=/usr/local/lib LIBS=-lz ./configure  
--with-apxs=/usr/local/httpd/bin/apxs --with-mysql=/usr/local/mysql/ 
--with-png-dir=/usr/local/lib/ --with-imap=/usr/local/lib 


Edit this bug report at

PHP Development Mailing List <>
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