• Resolved 1DMF

    (@1dmf)


    Hi,

    I’ve installed IIS 5.1 on my XP machine.
    I’ve installed PHP 5.2.14 and is running ok.
    I’ve installed mySQL 5.1.50 configuration was successfull.

    wordpress errors with…

    Your PHP installation appears to be missing the MySQL extension which is required by WordPress

    I have the php_mysql extension, I’ve edited the php.ini file, I’ve added/amended the system environment variables for PATH & PHPRC to C:\PHP

    What have I missed that is stopping wordpress from working?

    Cheers,
    1DMF.

Viewing 15 replies - 1 through 15 (of 16 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Did you restart the web server after editing the INI file?

    If it says it’s missing the extension, then that means it’s missing the extension. It can’t be mistaken on that point.

    Thread Starter 1DMF

    (@1dmf)

    1. yes, my machine has been rebooted many times since also, I have run a special PHP file I put together with the following commands to ensure PHP was running and with my ini file.

    <?php 
    
    echo phpinfo();
    
    $inipath = php_ini_loaded_file();
    
    if ($inipath) {
        echo 'Loaded php.ini: ' . $inipath;
    } else {
        echo 'A php.ini file is not loaded';
    }
    
    ?>

    all seems OK.

    2. I have set

    extension_dir = "C:\PHP\ext" in the ini file.

    un-commented

    extension=php_mysql.dll
    extension=php_mysqli.dll

    I have also ensured IIS IUSR has access to the PHP folder and the sub folder ext with ‘full control’, also the ext folder does contain the php_mysql.dll file.

    I’ve ensured the environment variables are set and that the PHP folder contains the libmysql.dll

    So from what I can tell no , it isn’t missing?

    Got any other ideas?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Do you see the mysql extension in the phpinfo(), when run via a web page?

    Sometimes webservers use a different php.ini file than the command line versions use. Check around for that.

    Thread Starter 1DMF

    (@1dmf)

    Where would I see this? under what section. A quick scan of the doc for ‘extension’ only throws up this match

    extension_dir C:\PHP\ext C:\PHP\ext

    The path shown for the ini file being used is correct with that code I showed….

    1Loaded php.ini: C:\PHP\php.ini

    So it seems to be reading the correct php.ini file, what sort of mistake might I need to look for if the extensions section is being ignored?

    create a quick php page that has:

    <?php
    phpinfo();
    ?>

    and then view that via the webserver.

    Thread Starter 1DMF

    (@1dmf)

    huh? I’ve done that with this code…

    <?php 
    
    echo phpinfo();
    
    $inipath = php_ini_loaded_file();
    
    if ($inipath) {
        echo 'Loaded php.ini: ' . $inipath;
    } else {
        echo 'A php.ini file is not loaded';
    }
    
    ?>

    So where am I looking in the result for the extensions and if they aren’t showing , what might be wrong with my php.ini file?

    well do you see any reference to mysql, mssql or any other databases within that output?

    Thread Starter 1DMF

    (@1dmf)

    Nope, only ODBC.

    Why not is the puzzler?

    Thread Starter 1DMF

    (@1dmf)

    Thanks but still no go…infact I did the php_mbstring.dll for PHPMyAdmin, yet I still get…

    The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

    I’ve even copied all the extensions to the C:\PHP folder as someone suggests including the php_mbstring.dll extension but still no dice.

    Interesting though… I decided to uncomment ALL SQL extensions , and lo and behold, I now have MS SQL extensions loaded just no mySQL, what is wrong with PHP 5?

    On a side note, can you confirm if it’s possible to run both IIS & Apache or XAMPP on the same server? I’m assuming on any one box you can only run one web server

    I could run as many different servers as I want, just not at the same time… (and you can run several at once, but it gets complicated…)

    You won’t find as many people using IIS. Which makes trying to support it more difficult, though you may get a better response on a dedicated IIS support forum (I don’t know of one before you ask).

    I personally use EasyPhp, a nice package of apache, php & mysql, and only requires minimal set up. Last time I installed it I had it running in about 5 minutes flat.

    Thread Starter 1DMF

    (@1dmf)

    That’s what I thoguht which means if I can’t get it to run on IIS it’s not an option.

    I have one production server runnign IIS & MS SQL, with over 40+ websites for 35+ companies, mission critical applications etc.

    This is all running under windows on IIS, so apache, XAMPP or any other webserver is NOT an option.

    oh well I was looking forward to getting my teeth into WordPress, guess I need to consider alteratives instead.

    Never rains does it!

    well if you find a good IIS support forum I’m sure they would be able to help out.

    Thread Starter 1DMF

    (@1dmf)

    It’s ok , got it working.

    Had nothing to do with needing IIS help, it was the fact the PHP zip files are corrupt and have the wrong files in them or missing files.

    I managed to get it working by cribing files form both v5.2.14 & v5.3.3 zip files.

    Total nightmare but got there in the end.

    Cheers,
    1DMF.

    thanks for coming back, never would have thought to reinstall php!

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Can't install wordpress, mysql extensions won't load?’ is closed to new replies.