WordPress.org

Ready to get started?Download WordPress

Forums

Install fails at Step 2 with [Table 'wpress.wp_options' doesn't exist] (6 posts)

  1. bitflow
    Member
    Posted 8 years ago #

    Despite following what appear to be following good instructions, I can’t get past the “Second Step? page, it reads:

    --------------------------

    Second Step

    Now we’re going to create the database tables and fill them with some default data.

    WordPress database error: [Table 'wpress.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('siteurl', 'http://mydomain.com/wordpress', 'WordPress web address', 'yes')

    WordPress database error: [Table 'wpress.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('blogname', 'My Weblog', 'Blog title', 'yes')

    --------------------------
    Followed by another hundred of these errors. I would really appreciate some help.

    I’m running on a dedicated Fedora Linux box with:

    $ mysql -V
    mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

    $ php -v
    PHP 4.3.10 (cgi) (built: Dec 21 2004 10:27:48)
    Copyright (c) 1997-2004 The PHP Group
    Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
    with the ionCube PHP Loader v2.4, Copyright (c) 2002-2003, by ionCube Ltd.

    Here's what I did:

    $ cd ~/httpdocs

    $ lynx -source http://wordpress.org/latest.tar.gz > latest.tar.gz

    $ tar -xvzf latest.tar.gz
    wordpress/
    wordpress/wp-blog-header.php
    wordpress/wp-login.php
    ... <snip> ...
    wordpress/wp-commentsrss2.php
    wordpress/wp-atom.php
    wordpress/wp-settings.php

    $ cd wordpress/

    $ mysql -u admin -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 665855 to server version: 3.23.58

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> CREATE DATABASE wpress;
    Query OK, 1 row affected (0.00 sec)

    mysql> GRANT ALL PRIVILEGES ON wpress.* TO wpress@localhost IDENTIFIED BY "somepassword";
    Query OK, 0 rows affected (0.00 sec)

    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)

    mysql> EXIT
    Bye

    $ cp wp-config-sample.php wp-config.php

    $ vi wp-config.php
    [I edit the file]

    $ cat wp-config.php
    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'wpress'); // The name of the database
    define('DB_USER', 'wpress'); // Your MySQL username
    define('DB_PASSWORD', 'somepassword'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-includes/languages.
    // For example, install de.mo to wp-includes/languages and set WPLANG to 'de'
    // to enable German language support.
    define ('WPLANG', '');

    /* That's all, stop editing! Happy blogging. */

    define('ABSPATH', dirname(__FILE__).'/');
    require_once(ABSPATH.'wp-settings.php');
    ?>

    From here I go to http://mydomain.com/wordpress/wp-admin/install.php and get:

    Welcome to WordPress installation. We’re now going to go through a few steps to get you up and running with the latest in personal publishing platforms. You may want to peruse the ReadMe documentation at your leisure.
    First Step »

    Clicking First Step, I get:

    First Step

    Before we begin we need a little bit of information. Don't worry, you can always change these later.
    Weblog title:
    Your e-mail:

    , and I fill these out, and hit "Continue to Second Step", and this is where the mess starts. I get:

    Second Step

    Now we’re going to create the database tables and fill them with some default data.

    WordPress database error: [Table 'wpress.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('siteurl', 'http://mydomain.com/wordpress', 'WordPress web address', 'yes')

    WordPress database error: [Table 'wpress.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('blogname', 'My Weblog', 'Blog title', 'yes')

    WordPress database error: [Table 'wpress.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('blogdescription', 'Just another WordPress weblog', 'Short tagline', 'yes')

    <... snip a hundred errors like this ... >

    WordPress database error: [Table 'wpress.wp_users' doesn't exist]
    INSERT INTO wp_users (ID, user_login, user_pass, user_email, user_registered, display_name, user_nicename) VALUES ( '1', 'admin', MD5('97d6ff'), 'email@mydomain.com', NOW(), 'email', 'admin')

    WordPress database error: [You have an error in your SQL syntax near ' 'wp_user_level', '10')' at line 1]
    INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (, 'wp_user_level', '10');

    WordPress database error: [You have an error in your SQL syntax near ' 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}')' at line 1]
    INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

    Finished!

    Now you can log in with the username "admin" and password "97d6ff".

    Note that password carefully! It is a random password that was generated just for you. If you lose it, you will have to delete the tables from the database yourself, and re-install WordPress. So to review:

    Username
    admin
    Password
    97d6ff
    Login address
    wp-login.php

    Were you expecting more steps? Sorry to disappoint. All done! :)

    of course, loading wp-login.php results in:


    It doesn't look like you've installed WP yet. Try running install.php.

    Wonderful! Ok WP wizards - what am I doing wrong!?

    Thanks,

    bitflow

  2. prazetyo
    Member
    Posted 8 years ago #

    I also have same problem with this. But my wordpress installation is in Windows 2000. Using Apache 2.0.39, PHP 4.22, dan MySql 3.22.34-shareware-debug. All this component working good. But when the installation goes to step 2, the database table get error.

    Please someone can help me. Realy to try this wordpress and like to develop it.

    Thank you

  3. joelitespeed
    Member
    Posted 8 years ago #

    I had a similar problem on FreeBSD5.4 using the port mysql5 which install mysql 5.0.2 alpha. After upgrading to mysql 5.0.18 things were fine and dandy again.

    Try upgrading the mysql as 3.xx is very old.

  4. joelitespeed
    Member
    Posted 8 years ago #

    Ok, I take this back. I did perform that step above, but in another system it failed. Step two only produces half the displayed page and never completes writing the database even though it is upgraded. Both had php5.1.2.

    Anyone else have ideas?

  5. joelitespeed
    Member
    Posted 8 years ago #

    Sry to spam this thread, but I solved my own problem. After ruling out mysql versions, web server conf's, and php versions, it turns out that the php.ini file made a direct reference to the local sendmail. I had added the line long ago. When I removed it, email still worked "as was" but the wordpress install now completes step2 each time!

    Hope this helps someone.

  6. oneafrikan
    Member
    Posted 8 years ago #

    Commenting out the Win32 SMTP and sendmail from lines worked for me...

Topic Closed

This topic has been closed to new replies.

About this Topic