WordPress.org

Ready to get started?Download WordPress

Forums

Invalid argument error using IIS6, MySQL 4.1.10 and PHP 4.3.10 (7 posts)

  1. jlivingston
    Member
    Posted 9 years ago #

    When installing WP 1.5 on IIS 6, MySQL 4.1.10 and PHP 4.3.10 I receive a long error (see http://tinyurl.com/4qmzh). I've triple checked my config file and read about a million posts - just can't figure this out.

    At the bottom of the page it lets me go through the install to where I can view WordPress and admin tools fine, it just is really slow (dashboard takes over 7 sec to display on a DSL connection). It shouldn't be as I have a fast server. Any help would be much appreciated.

  2. jlivingston
    Member
    Posted 9 years ago #

    Two days later I'm still pulling my hair out. Here's what I'm getting...

    Warning: Invalid argument supplied for foreach() in D:\websites\Martin\www\wp-includes\functions.php on line 355

    WordPress database error: [Table 'wpmartin.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'permalink_structure'

    Warning: Invalid argument supplied for foreach() in D:\websites\Martin\www\wp-includes\functions.php on line 355

    WordPress database error: [Table 'wpmartin.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'category_base'

    Warning: Invalid argument supplied for foreach() in D:\websites\Martin\www\wp-includes\functions.php on line 355

    WordPress database error: [Table 'wpmartin.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'siteurl'

    Warning: Invalid argument supplied for foreach() in D:\websites\Martin\www\wp-includes\functions.php on line 355

    The last line repeats atleast 20-30 times but at the end of the page it shows "Welcome to WordPress Installation".

  3. S.K
    Member
    Posted 9 years ago #

    Did you create the database as indicated by you in the config file (define('DB_NAME', 'wordpress'); // The name of the database - "wordpress" to be changed as "wpmartin")?
    Did the installation sequence got completed without any error prompt.
    Prima facie, it is a db problem.

  4. RustIndy
    Member
    Posted 9 years ago #

    As I've noted on several occasions in the past (including a response earlier today to you), PHP4.3 and MySQL4.1 dislike each other because of the new authentication scheme in MySQL 4.1. The only workaround is to set MySQL4.1 into the lower security mode so it's compatible with clients (like PHP4.x) that use the older authentication library.

    Or upgrade to PHP5 - WordPress works fine with it, and it works fine with MySQL4.1.

  5. RustIndy
    Member
    Posted 9 years ago #

    Oh, the Dashboard can take some time on any connection (it usually takes 2 to 5 seconds on mine) because it is trying to display content from other blogs, not just information from your own.

  6. jlivingston
    Member
    Posted 9 years ago #

    RustIndy - How do you set MySQL 4.1 into the lower security mode?

  7. RustIndy
    Member
    Posted 9 years ago #

    From the MySQL 4.1 documentation:

    Tell the server to use the older password hashing algorithm:
    1. Start mysqld with the --old-passwords option (this can also be set in the MySQL INI file)
    2. Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
    mysql> SELECT Host, User, Password FROM mysql.user WHERE LENGTH(Password) > 16;
    For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described here:
    mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE User = 'some_user';
    mysql> FLUSH PRIVILEGES;

    So basically, add the -old-passwords option to the MySQL ini file, then use the bottom two queries to change your existing WordPress database login from the new password encryption to the old password encryption. Then run the WP installation again so it can create the proper tables with the proper rights.

    The link to the above information is at: http://dev.mysql.com/doc/mysql/en/old-client.html

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.