I know a lot of people are having this problem too because there is a bug report with
the same/similar description for many
different platforms.
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.
good luck
-David
----- Original Message -----
From: "David Wartell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 1:55 PM
Subject: [PHP] mysql ERROR: Update Query Failed problem with 4.0.6
Im using PHP 4.0.6 install on Solaris x86 with mysql 3.23.39. The following code
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
/usr/www/netsite-docs/parda.actionwebservices.com/public-html/includes/admin_user_write.php
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/libpng.so.2 --with-i
map=/usr/local/lib --with-lz=/usr/local/lib
Any ideas?
Thanks,
David
--
PHP General 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]
--
PHP General 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]