php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #12148 mysql ERROR: Update Query Failed problem with 4.0.6
Submitted: 2001-07-13 13:51 UTC Modified: 2001-11-20 19:14 UTC
From: david at actionwebservices dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.6 & 4.0.5 OS: Solaris x86
Private report: No CVE-ID: None
 [2001-07-13 13:51 UTC] david at actionwebservices dot 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



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-07-16 11:35 UTC] david at actionwebservices dot com
using MySQL version 3.23.39
 [2001-07-16 12:42 UTC] david at actionwebservices dot com
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.

 [2001-11-20 19:14 UTC] mfischer@php.net
Closing this one, but not quite sure.
Speak up if you don't agree.

Closed.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 28 04:01:29 2024 UTC