|  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: david at actionwebservices dot com
New email:
PHP Version: OS:


 [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/ 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/ --with-imap=/usr/local/lib --with-lz=/usr/local/lib


Add a Patch

Pull Requests

Add a Pull Request


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]
Closing this one, but not quite sure.
Speak up if you don't agree.

PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Sun May 28 13:03:46 2023 UTC