WordPress.org

1. dhbarr
   Member
   Posted 5 years ago #
   

   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.

2. dhbarr
   Member
   Posted 5 years ago #
   

   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.

3. dhbarr
   Member
   Posted 5 years ago #
   

   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.

4. dhbarr
   Member
   Posted 5 years ago #
   

   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.

Topic Closed

This topic has been closed to new replies.