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 PHP Version: 4.0.6 & 4.0.5 & latest dev as of 7/16/2001 New Comment: using MySQL version 3.23.39 Previous Comments: ------------------------------------------------------------------------ [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