ID: 41825 User updated by: rahulkorlipara at gmail dot com Reported By: rahulkorlipara at gmail dot com -Status: Bogus +Status: Closed Bug Type: MySQL related Operating System: Windows Server 2003 R2 PHP Version: 5.2.3 New Comment:
Scott - Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Previous Comments: ------------------------------------------------------------------------ [2007-06-27 14:37:13] [EMAIL PROTECTED] You can find more information on the MySQL bug at http://bugs.mysql.com/bug.php?id=28358 ------------------------------------------------------------------------ [2007-06-27 14:34:16] [EMAIL PROTECTED] This is a bug in MySQL 5.0.41 that prevents libmysql.dll being loaded correctly, use the libmysql.dll supplied with PHP rather than the one supplied with MySQL. ------------------------------------------------------------------------ [2007-06-27 14:30:33] rahulkorlipara at gmail dot com Description: ------------ ENVIRONMENT Windows 2003 Server R2 IIS 6.0 MySQL 5.0.41 PHP 5.2.3 PROBLEM All extensions except those for mysql working ERRORS FROM LOG: [27-Jun-2007 02:59:18] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\runtimes\php\phpext\php_mysql.dll' - Invalid access to memory location. in Unknown on line 0 [27-Jun-2007 02:59:18] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\runtimes\php\phpext\php_mysqli.dll' - Invalid access to memory location. in Unknown on line 0 [27-Jun-2007 02:59:18] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\runtimes\php\phpext\php_ffi.dll' - The specified module could not be found. in Unknown on line 0 ATTEMPTS - replaced php_mysql.dll & php_mysqli.dll in the ext folder from php 5.2.3 win32 distribution - extensions folder location provided to the ext folder in php.ini - provided 'full control' privileges to 'Everyone' to ext folder - both extensions enables in php.ini - both php folder and mysql/bin folder in Windows PATH - Replaced extension dlls with latest several times - Replaced libmysql.dll several times in the mysql/bin folder - Did a repair on using MySQL Windows installer - Restarted IIS as well as Server several times after every change OTHER PEOPLE WITH THE SAME PROBLEM http://forums.mysql.com/read.php?11,102233,159429#msg-159429 Reproduce code: --------------- test.php <?php // Connecting, selecting database $link = mysql_connect('localhost', 'username', 'password') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('databasename') or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM tablename'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?> Expected result: ---------------- "Connected successfully" the table's contents Actual result: -------------- None. Blank page is returned. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41825&edit=1
