ID: 12148
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
using MySQL version 3.23.39
------------------------------------------------------------------------
[2001-07-13 13:51:29] [EMAIL PROTECTED]
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
--
PHP Development 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]
