Title: install.php reports some sql query error.
Last modified: August 19, 2016

---

# install.php reports some sql query error.

 *  [pcmanbiti](https://wordpress.org/support/users/pcmanbiti/)
 * (@pcmanbiti)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/)
 * Hi,
 * My server is apache2.0.52/mysql4.1/php4.4.7, also I tested on apache 2.2.2/mysql5.0.24/
   php5.2.5, I have the same problem.
 * When I access install.php, it reports,
 * > WordPress database error Table ‘wp.wp_options’ doesn’t exist for query SELECT
   > option_value FROM wp_options WHERE option_name = ‘siteurl’ WordPress database
   > error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘home’ LIMIT 1 WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘siteurl’ LIMIT 1 WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘hack_file’ LIMIT 1 WordPress database 
   > error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘active_plugins’ LIMIT 1 WordPress database
   > error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘permalink_structure’ LIMIT 1 WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name,
   > option_value FROM wp_options WHERE autoload = ‘yes’ WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WordPress database error Table ‘wp.wp_options’ doesn’t exist
   > for query SELECT option_value FROM wp_options WHERE option_name = ‘category_base’
   > LIMIT 1 WordPress database error Table ‘wp.wp_options’ doesn’t exist for query
   > SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name,
   > option_value FROM wp_options WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_value FROM wp_options WHERE option_name
   > = ‘tag_base’ LIMIT 1 WordPress database error Table ‘wp.wp_options’ doesn’t
   > exist for query SELECT option_name, option_value FROM wp_options WHERE autoload
   > = ‘yes’ WordPress database error Table ‘wp.wp_options’ doesn’t exist for query
   > SELECT option_name, option_value FROM wp_options WordPress database error Table‘
   > wp.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options 
   > WHERE option_name = ‘template’ LIMIT 1 WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WHERE
   > autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’ doesn’t exist
   > for query SELECT option_name, option_value FROM wp_options WordPress database
   > error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value FROM
   > wp_options WHERE option_name = ‘stylesheet’ LIMIT 1 WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options
   > WHERE option_name = ‘siteurl’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WHERE
   > autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’ doesn’t exist
   > for query SELECT option_name, option_value FROM wp_options WordPress database
   > error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value FROM
   > wp_options WHERE option_name = ‘use_smilies’ LIMIT 1 WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_name, option_value
   > FROM wp_options WHERE autoload = ‘yes’ WordPress database error Table ‘wp.wp_options’
   > doesn’t exist for query SELECT option_name, option_value FROM wp_options WordPress
   > database error Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value
   > FROM wp_options WHERE option_name = ‘cron’ LIMIT 1 WordPress database error
   > Table ‘wp.wp_options’ doesn’t exist for query SELECT option_value FROM wp_options
   > WHERE option_name = ‘siteurl’
   >  Warning: Cannot modify header information – 
   > headers already sent by (output started at /www/users/pcman.biti.org.cn/temp/
   > wp2/wp-admin/install.php:2) in /www/users/pcman.biti.org.cn/temp/wp2/wp-admin/
   > install.php on line 18
 * after the error message, it was the welcom message.
 * > Welcome
   > Welcome to the famous five minute WordPress installation process! You may want
   > to browse the ReadMe documentation at your leisure. Otherwise, just fill in
   > the information below and you’ll be on your way to using the most extendable
   > and powerful personal publishing platform in the world.
   >  Information needed
   > Please provide the following information. Don’t worry, you can always change
   > these settings later.
 * although the installation can be continued, it reports many database error, because
   the mysql database not exsit.
 * why ? could you please fix it?

Viewing 9 replies - 1 through 9 (of 9 total)

 *  [vorsuc](https://wordpress.org/support/users/vorsuc/)
 * (@vorsuc)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676865)
 * I get the same error on Windows. Don’t get the welcome message and the tables
   aren’t created in the DB.
 * Odly though, the WordPress MU version installs fine.
 *  [vorsuc](https://wordpress.org/support/users/vorsuc/)
 * (@vorsuc)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676866)
 * Did you get this error using WordPress version 2.3.2 ?
 * Try using 2.3.1, that seemed to work without issue for me.
 *  [lordzoster](https://wordpress.org/support/users/lordzoster/)
 * (@lordzoster)
 * [18 years, 1 month ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676880)
 * i’m getting same error on WP2.3.3eng on a Windows IIS5.
    BTW it’s seems it’s 
   running fine… i’m keeping on test.
 *  [codinghorror](https://wordpress.org/support/users/codinghorror/)
 * (@codinghorror)
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676899)
 * I have the same problem! Exactly!
 * IIS7 / mysql 5.0.51a / php 5.2.5 / WordPress 2.3.3
 * I know MySQL and PHP are both working fine: phpMyAdmin is running *great* with
   the very same credentials in a subfolder off the root. And I can log in to MySQL
   at the command line with these credentials and create database, tables, etc. 
   no problem.
 * However the WordPress install.php cannot seem to create any tables in the database
   and regurgitates a ton of failed SQL queries back on the page.
 * I am really stuck on this. Any ideas??
 * I think I’ll try an older version of WordPress in a sec.
 *  [codinghorror](https://wordpress.org/support/users/codinghorror/)
 * (@codinghorror)
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676900)
 * update to previous:
 * WordPress 2.3.3 does NOT work and causes the above error.
 * WordPress 2.3.1 DOES work.
 *  [sokai](https://wordpress.org/support/users/sokai/)
 * (@sokai)
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676902)
 * I have the same problem with a today-svn-snapshot of 2.5 (and an older stable
   release of 2.3.2) and I can’t solve… *bump*
    My sytem is Linux (CentOS 4.3), 
   Apache (2.2.8), MySQL (5.1.11-beta) and PHP (4.4.7 & 5.2.3)
 * Furthermore I have found that problem on several other forum-posts:
    – [http://wordpress.org/support/topic/158018](http://wordpress.org/support/topic/158018)–
   [http://wordpress.org/support/topic/159992](http://wordpress.org/support/topic/159992)
   And maybe related in this: – [http://wordpress.org/support/topic/131976](http://wordpress.org/support/topic/131976)
   That reports are not resolved too.
 * I think after some tests the “only” problem is the initial installation of the
   database. – Is there a way to manually install the wp-database? (I couldn’t find
   some SQL-files like other projects have…)
 * sofar & thanks a lot
    sokai
 *  [Ian Dunn](https://wordpress.org/support/users/iandunn/)
 * (@iandunn)
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676907)
 * I’m getting this error too. It started in 2.3.2 and still exists in 2.5RC1. I’m
   on IIS 6, PHP 5.2.5, MySQL 5.
 * There are a couple of bug reports, but it doesn’t look like it’s being dealt 
   with.
 * [http://trac.wordpress.org/ticket/5720](http://trac.wordpress.org/ticket/5720)
   
   [http://trac.wordpress.org/ticket/5613](http://trac.wordpress.org/ticket/5613)
 *  [Ian Dunn](https://wordpress.org/support/users/iandunn/)
 * (@iandunn)
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676908)
 * I got it working by setting log_errors to ‘On’ and error_log to a file that PHP
   can write to.
 * [http://trac.wordpress.org/ticket/5720](http://trac.wordpress.org/ticket/5720)
 *  Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676909)
 * Also reference:
    [http://trac.wordpress.org/ticket/5771](http://trac.wordpress.org/ticket/5771)

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘install.php reports some sql query error.’ is closed to new replies.

## Tags

 * [installation](https://wordpress.org/support/topic-tag/installation/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 9 replies
 * 7 participants
 * Last reply from: [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * Last activity: [18 years ago](https://wordpress.org/support/topic/installphp-reports-some-sql-query-error/#post-676909)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics