php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #5546 Mysql Update Bug
Submitted: 2000-07-13 04:03 UTC Modified: 2000-09-03 19:38 UTC
From: am at pixelhouse dot de Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.1pl2 OS: Linux Redhat 6.2
Private report: No CVE-ID: None
View Developer Edit
 [2000-07-13 04:03 UTC] am at pixelhouse dot de 
Hi...

I have php4.01pl2 running on Redhat 6.2.
I start querrying Databases like this.

$link = mysql_connect($_Server,$_User,$_Spasswort);
@mysql_select_db($_Database,$link);
$result = mysql_fetch_array(mysql_query("select * from User where UID = '$TransID' and UsrTemp ='1' "));

The mysql_fetch_array works fine and all values are returned.

But if i make this at next.

$tempo = mysql_query("update User set UsrTemp='0' where UID = '$TransID' ");

This error appears:
Warning: MySQL: Unable to save result set in /www/httpd/foo.de/html/paygate/successcc.phtml on line 24

But the querry does in the Database what it has to do so there should no error be returned.
The querry works but the errormessage comes.

So what to do to fix this?

Regards

Alex

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-08-10 08:52 UTC] bmcadams@php.net 
Can you please specify what version of mySQL you are using?  Also, have you tried issuing the problematic SQL statement through the mySQL command line? If so, does it return an error?

This information would help us better assist you.
 [2000-08-11 20:50 UTC] bmcadams@php.net 
User states MySQL Version is 3.23.32-log.
PHP Generating SQL properly, SQL statement runs on command line.
Problem with mySQL support?
Opening bug assignment for outside assistance.
 [2000-08-12 04:10 UTC] bmcadams@php.net 
Per Mike Robinson:
"
This is a dupe of # 4759 (and others).
The user most likely has some other app using mysql (php3, auth-mysql),
so he has to specifiy the path to mysql in the php4 configure line,
otherwise the conflicting mysql-client versions wreak havoc.
"

Waiting for user feedback to see if this resolves the issue.
 [2000-09-03 19:38 UTC] sniper@php.net 
No feedback from user. Closed.

--Jani
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Mon Jun 29 04:00:02 2026 UTC