WordPress.org

Ready to get started?Download WordPress

Forums

install.php reports some sql query error. (10 posts)

  1. pcmanbiti
    Member
    Posted 6 years ago #

    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?

  2. vorsuc
    Member
    Posted 6 years ago #

    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.

  3. vorsuc
    Member
    Posted 6 years ago #

    Did you get this error using WordPress version 2.3.2 ?

    Try using 2.3.1, that seemed to work without issue for me.

  4. lordzoster
    Member
    Posted 6 years ago #

    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.

  5. codinghorror
    Member
    Posted 6 years ago #

    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.

  6. codinghorror
    Member
    Posted 6 years ago #

    update to previous:

    WordPress 2.3.3 does NOT work and causes the above error.

    WordPress 2.3.1 DOES work.

  7. sokai
    Member
    Posted 6 years ago #

    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/159992
    And maybe related in this:
    - 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

  8. Ian Dunn
    Member
    Posted 6 years ago #

    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/5613

  9. Ian Dunn
    Member
    Posted 6 years ago #

    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

  10. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic