Re: PHP 4.0 Bug #5546: Mysql Update Bug

i had this problem with php4.0.1pl2 on slackware, i suppose this is somewhat of a bug in the included mysql client libraries in that release. I fixed it simply by recompiling and specifying the location of my own mysql client libraries and it seems to fix everything, i considered writing a bug report but didn't see any other postings about it until now. Joshua ----- Original Message ----- From: <am@pixelhouse.de> To: <php-dev@lists.php.net> Sent: Thursday, July 13, 2000 3:03 AM Subject: [PHP-DEV] PHP 4.0 Bug #5546: Mysql Update Bug > From: am@pixelhouse.de > Operating system: Linux Redhat 6.2 > PHP version: 4.0.1pl2 > PHP Bug Type: MySQL related > Bug description: Mysql Update Bug > > 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 > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >