From: rodney at nerdsindenial dot com
Operating system: Windows XP Pro/sp2
PHP version: 5.1.4
PHP Bug Type: MySQL related
Bug description: libmysql.dll and/or php_mysql.dll
Description:
------------
I have the same problem and have tried most of the proposed solution
(change PHPRC, eliminate all of the php.ini files but one; move
php_mysql.dll and/or libmysql.dll to php/ext and php). I can create and
populate a database
in MySQL v5.1; install and run PHP5.2 (this is from the daily build
directory to pick up the fixes php5_apache2.dll -> php_apache2_2.dll to
solve dependency issues with missing dll for LoadModule php5_module
modules/php_apache2.dll (broken, need new name) in "X":\php\php.ini) I
found this solution and directory in the www.php.net FAQ's. I was able to
run PHP scripts from a mozilla FireFox client on the Apache server in the
.\Apache2.2\httdocs directory including phpinfo(). The Apache v2.2.2
server installed and ran without a hitch. HOWEVER, I COULD NOT link to
mysql_connect() or any other mysql function within a PHP script. I finally
changed display_startup_errors in the php.ini file from off-to-on and
restarted
the Apache 2.2.2 server. It displayed the following in a warning dialog
box:
PHP Startup: Unable to initialize module
Module compiled with module API=20050613, debug=0, thread-safety=1
PHP compiled with module API=20050922, debug=0, thread-safety=1
These options need to match
OK
I am not able to compile the source for libmysql.dll or php_mysql.d..
(PECL).
It looks like a recompile of the mysql "shared" libraries may solve either
all
or part of the problem. I hope the developers at www.php.net are
listening??
Irie
Rodney
Reproduce code:
---------------
<?PHP
$dbUser = "root";
$dbPass = "";
$dbName = "DVDRentals";
$dbHost = "THIRDWORLD";
if(!($link=mysql_pconnect($dbHost, $dbUser, $dbPass)))
{
error_log(mysql_error(), 3, "/tmp/phplog.err");
}
if(!mysql_select_db($dbName, '127.0.0.1'))
{
error_log(mysql_error(), 3, "/tmp/phplog.err");
}
$queryDVD = "SELECT \* FROM DVDs";
$result = mysql_query($queryDVD, $link1);
$array1 = mysql_fetch($result);
print($array1);
mysql_close($link);
?>
Expected result:
----------------
At least an attempted connect to the database.
Actual result:
--------------
Connect To MySQL Server and List DVD's
Fatal error: Call to undefined function mysql_pconnect() in D:\Program
Files\Apache Software Foundation\Apache2.2\htdocs\listDVDs.html on line 14
--
Edit bug report at http://bugs.php.net/?id=38070&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38070&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38070&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38070&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38070&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38070&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38070&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38070&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38070&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38070&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38070&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38070&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38070&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38070&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38070&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38070&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38070&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38070&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38070&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38070&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38070&r=mysqlcfg
