Re: Upgrade Issues

If you already *have* a db connection, use mysql_query() and pass it in, not mysql_db_query. Or even leave it off, and PHP will use the default one. -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Evan <php_questions@juiceplus.com> Newsgroups: php.general To: <php-general@lists.php.net> Sent: Saturday, October 06, 2001 9:51 PM Subject: Upgrade Issues I recently upgraded to PHP 4.06 from 4.02 and have encountered another possible problem. I create a link to the mysql database with mysql_connect, all future querys opt out of the link identifier with: mysql_db_query([db name], [query]); If the script makes too many querys, somewhere around 5 (I'm not sure), the link is dropped and the mysql_db_query command appears to try and re-establish the link. and the script returns the error: Warning: Access denied for user: 'nobody@localhost' (Using password: NO) in /home/httpd/html/distsupp/admin/security.inc on line 61 Warning: MySQL Connection Failed: Access denied for user: 'nobody@localhost' (Using password: NO) in /home/httpd/html/distsupp/admin/security.inc on line 61 Warning: MySQL: A link to the server could not be established in /home/httpd/html/distsupp/admin/security.inc on line 61 This line of code is: $result = mysql_db_query($distadmdb, $query) or error(mysql_error()); This didn't happen in 4.02. In fact, if I change back to 4.02 and reload the same page, I don't get this problem. Is this behavior to be expected, is there a configuration option that I should look for that sets the max querys per link?