Support » Installing WordPress » Database Error: wp_options doesn’t exist

  • Resolved dhbarr

    (@dhbarr)


    The Setup

    • WordPress 2.3
    • PHP 5.2.5 (win32)
    • FastCGI for IIS6.0 (win32)
    • MySQL 5.0.45 (win32)
    • IIS6 (win32)
    • Win 2k3 Server, Ent. 32-bit

    IIS6 and MySQL are on two different machines.
    Have confirmed database connectivity between IIS6 and MySQL
    …via command-line logon
    …using MySQL credentials
    …assigned to WordPress.

    The Config

    define('DB_NAME', '**database**');

    define(‘DB_USER’, ‘**username**’);

    define('DB_PASSWORD', '**password**');

    define(‘DB_HOST’, ‘192.168.0.***’);

    define('DB_CHARSET', 'utf8');

    define(‘DB_COLLATE’, ”);

    $table_prefix  = 'wp_';

    define (‘WPLANG’, ”);

    On IIS6 box, http://localhost/wp-admin/install.php gives…

    The Error(s)
    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’
    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’
    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_name, option_value FROM wp_options

    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_name, option_value FROM wp_options
    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options WHERE option_name = ‘cron’ LIMIT 1
    WordPress database error Table ‘**database**.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’

    The Question
    If I were to manually create this table using the credentials assigned to WordPress, what would it look like?
    I’m open to other suggestions, of course.

    TIA,
    -dhbarr.

Viewing 3 replies - 1 through 3 (of 3 total)
  • As a followup, would anyone mind pointing me to a known-good “phpinfo(INFO_MODULES);” ? I’d like to see if perhaps my plugins aren’t behaving correctly (I know they’re loaded, I just don’t know what good WordPress-compatible behavior looks like).

    Thanks Again,
    -dhbarr.

    Anybody? As an alternative, has anyone ever extracted the SQL schema? I’m thinking of setting up a standalone installation, backing up the .sql CREATEs, and trying to force creation of the tables (which I have verified are not being created) before running setup….

    -dhbarr.

    MichaelH helped me get this resolved over at:
    http://wordpress.org/support/topic/150484

    The word is: some combinations of IIS6 + FastCGI + PHP5 work; some do not. Using php5isapi.dll as your .php handler seems more reliable.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Error: wp_options doesn’t exist’ is closed to new replies.