PHP 4.0 Bug #5546 Updated: Mysql Update Bug

ID: 5546 Updated by: sniper Reported By: am@pixelhouse.de Status: Closed Bug Type: MySQL related Assigned To: Comments: No feedback from user. Closed. --Jani Previous Comments: [2000-08-12 04:10:55] 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-08-11 20:50:40] 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-10 08:52:02] 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-07-13 04:03:22] am@pixelhouse.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 --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=5546