Re: mysql ERROR: Update Query Failed problem with 4.0.6

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" <david@actionwebservices.com> To: <php-general@lists.php.net> Cc: <jbarrell@actionwebservices.com> 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net