WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Can't install wordpress, mysql extensions won't load? (17 posts)

  1. 1DMF
    Member
    Posted 3 years ago #

    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.

  2. Samuel Wood (Otto)
    Tech Ninja
    Posted 3 years ago #

    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.

  3. 1DMF
    Member
    Posted 3 years ago #

    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?

  4. Samuel Wood (Otto)
    Tech Ninja
    Posted 3 years ago #

    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.

  5. 1DMF
    Member
    Posted 3 years ago #

    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?

  6. elfin
    Moderator
    Posted 3 years ago #

    create a quick php page that has:

    <?php
    phpinfo();
    ?>

    and then view that via the webserver.

  7. 1DMF
    Member
    Posted 3 years ago #

    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?

  8. elfin
    Moderator
    Posted 3 years ago #

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

  9. 1DMF
    Member
    Posted 3 years ago #

    Nope, only ODBC.

    Why not is the puzzler?

  10. elfin
    Moderator
    Posted 3 years ago #

  11. 1DMF
    Member
    Posted 3 years ago #

    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

  12. elfin
    Moderator
    Posted 3 years ago #

    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.

  13. 1DMF
    Member
    Posted 3 years ago #

    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!

  14. elfin
    Moderator
    Posted 3 years ago #

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

  15. 1DMF
    Member
    Posted 3 years ago #

    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.

  16. elfin
    Moderator
    Posted 3 years ago #

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

  17. 1DMF
    Member
    Posted 3 years ago #

    No problem, if only it had been as simple as just re-installing.

    I did that three times and got no-where.

    It was only when someone helped track down the error that I found the v5.2.14 has the wrong mysql.dll files in it and that v5.3.3 has the php5isapi.dll missing from it.

    3 days of banging my head before I finally got it working from both zip files!

    I sure hope WordPress is easier to use :-)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.