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 --------------------------------------------------------------------- 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
