mysql ERROR: Update Query Failed problem with 4.0.6
| From: | David Wartell | Date: | Fri, 13 Jul 2001 17:55:46 +0000 |
| Subject: | mysql ERROR: Update Query Failed problem with 4.0.6 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57771@lists.php.net to get a copy of this message | ||
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