Doesn't you have any simpler answer??
Maybe installing the new version of mysql server - I have version 3.23.49 - should do the trick ----- Original Message ----- From: "Larry Brown" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 4:12 PM Subject: RE: [PHP] Re: PHP and MySQL bug > Since nobody is jumping in to say it is some simple configuration/setting > personally my next step would be to shut down all services on the box that > aren't absolutely necessary and stop everything in the registry under run > and stop anything in the start folder of the start menu and run the same > tests. If no positive results I would uninstall php completely and clean > any reference in the registry of it and then install with everything still > shut down. Retest, if no progress do the same with mysql. These are > radical and time-consuming methods, but it seems as though it is broken. If > you absolutely need this fixed fast you might resort to paying the > developers to give you a solution, although it may end up being what I just > listed, or it could be some simple fix that we aren't aware of. > > Larry S. Brown > Dimension Networks, Inc. > (727) 723-8388 > > -----Original Message----- > From: Nuno Lopes [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 4:31 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [PHP] Re: PHP and MySQL bug > > I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and > mysql 3.23.49. > Everything is working fine, except this. > With pconnect the error is the same! > > > ----- Original Message ----- > From: "Larry Brown" <[EMAIL PROTECTED]> > To: "MySQL List" <[EMAIL PROTECTED]> > Sent: Monday, January 06, 2003 6:28 PM > Subject: RE: [PHP] Re: PHP and MySQL bug > > > > This definitely sounds like a buggy installation or there may be some > > problem with the communication between the web server and the mysqld. Is > > the db on a different machine? Try using mysql_pconnect instead of > connect > > just to see what result you get. I have read some unfavorable statements > > about using pconnect with a large number of hits so if it works you should > > read the comments about it on php.net. Do a search for mysql_pconnect. > > > > Larry S. Brown > > Dimension Networks, Inc. > > (727) 723-8388 > > > > -----Original Message----- > > From: Nuno Lopes [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 06, 2003 1:09 PM > > To: MySQL List; [EMAIL PROTECTED] > > Subject: [PHP] Re: PHP and MySQL bug > > > > The problem is if I close the connection and reopen it the query is done, > > but if I remain with the same connection has the previous query, mysql > > returns an error. > > > > > > ----- Original Message ----- > > From: "Larry Brown" <[EMAIL PROTECTED]> > > To: "MySQL List" <[EMAIL PROTECTED]> > > Sent: Sunday, January 05, 2003 4:16 PM > > Subject: Re:PHP and MySQL bug > > > > > > > Try replacing the following line... > > > > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query > doesn't > > > work!!!! > > > > > > With... > > > > > > $query = "UPDATE d SET h='$h' WERE id='$id'"; > > > $queryr = mysql_query($query) or die("The sql statement does not > > execute"); > > > > > > if(mysql_affected_rows() !== 1) > > > { > > > die("The sql statement is successfully run however either h did not > > > change or there is an internal error. Try executing the sql from the > > > command line to make sure it otherwise works."); > > > } > > > > > > and see which is coming back. > > > > > > > > > Larry S. Brown > > > Dimension Networks, Inc. > > > (727) 723-8388 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
