Bug #12148 Updated: mysql ERROR: Update Query Failed problem with 4.0.6

ID: 12148 User updated by: david@actionwebservices.com Reported By: david@actionwebservices.com 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] david@actionwebservices.com using MySQL version 3.23.39 ------------------------------------------------------------------------ [2001-07-13 13:51:29] david@actionwebservices.com 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 /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-imap=/usr/local/lib --with-lz=/usr/local/lib ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=12148&edit=1