ID: 47882 Updated by: johan...@php.net Reported By: ldjones at us dot ibm dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Windows XP SP3 PHP Version: 5.2.9 New Comment:
Your system loads libmysql.dll from 5.1 instead f the 5.0 version which was used when linking PHP but these libraries are incompatible. You can safely use the 5.0 dll to connect to a 5.1 serer though. Previous Comments: ------------------------------------------------------------------------ [2009-04-02 21:45:31] ldjones at us dot ibm dot com Description: ------------ I am wondering why Bug 46842 was closed with no resolution? The status shows as "Bogus". However, I just bought a new laptop and installed MySQL 5.1.33, Apache 2.2.11, and PHP 5.2.9-1. Then I couldn't run anymore because Apache dies with the exact same problem reported with Bug 46842. In other words, it's not bogus at all. I configured php.ini the same as I did on my old laptop (Apache 2.2.8, MySQL 5.0.22, PHP 5.2.5) by turning on CURL, MySQL, MySQLi, and OpenSSL. By the way, I got by the problem by following the advice of one of the people who posted on Bug 46842 - I copied the libmysql.dll from PHP 5.2.5 and overwrote the one supplied by PHP 5.2.9, but I only did that because I can't afford down time. I would gladly undo that change if someone would fix the problem. Thanks, Lonnie Jones Reproduce code: --------------- <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql: '.mysql_error()); echo 'Connected successfully'; mysql_close($conn); ?> Expected result: ---------------- Connected successfully. Actual result: -------------- The browser says Apache can no longer function and will close. Apache doesn't close, but I don't get a connection either. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47882&edit=1