Posted by Andy Hassall on 12/10/06 15:38

On 10 Dec 2006 02:39:42 -0800, "Curtis" <dyer85@gmail.com> wrote:

>Recently, I decided to upgrade to PHP 5.2.0. I have C:\php5 in the
>Windows XP PATH, so upgrading is quite painless; just unzip new
>release, and restart Apache! Usually it goes off without a hitch, but I
>noticed that phpMyAdmin was not able to utilize the MySQLi library
>(which was working with my last 5.1.x release). As I was looking
>through php_info(), I noticed that MySQLi didn't even load. However,
>when I restarted Apache after installing and setting up php.ini, there
>was NO error displayed, nor logged. Actually, I do get an error in the
>actual PHP code during runtime, which informs me that the mysqli class
>doesn't exist. Neither does the procedural forms of MySQLi.
>
>Some information: I run Apache 2.0.54 on Windows XP Pro. Last night, I
>upgraded to MySQL 5.0.27, in an attempt to see if it would improve the
>situation (previously, I ran on 4.1.x).
>
>php.net doesn't seem to make any special note about installing for
>5.2.0 (with the exception of Apache 2.2.x), so I'm not even sure how to
>go about troubleshooting, since I don't even have an error to go by.
>
>Other modules that load are: CURL, mbstring, mcrypt, mysql (standard
>mysql), and xsl. php_mysqli.dll was packed with my install, and is
>located in the same directory as the above modules which load.
>
>If anyone can point me in the right direction, I would be very
>grateful.

Some places to start that often sort this sort of thing out:

Try the command-line version of PHP. Start off with just "php -v" - you may
see some errors here which could shine some light on the situation.

Download Dependency Walker, and load php_mysqli.dll into it. This may
highlight missing dependencies that cause it to fail to load. (You can
_usually_ ignore delay-load dependency modules, if it complains about those).
You can see which libmysql.dll it's picking up as well.

The other factor tends to be that the webserver runs under a different
environment to your user; both in environment variables and filesystem
permissions, so check they're consistent and that the relevant DLLs are
accessible to whatever user Apache is running as.

For what it's worth, both the mysql and mysqli extensions load fine here on
PHP 5.2.0, Apache, Windows XP, MySQL 5.0.22 so it's not fundamentally broken in
5.2.0 as far as I can see.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]