Support » Installing WordPress » Wp_options table not available…

  • WordPress seems like a great option, but it is so hard to install. I could never figure out how to get the database tables set up in the MySql database. The repair option never worked for me, and I couldn’t find any SQL scripts on the internet to add the tables. I am about to give up on this. Any ideas how I can get around this problem?

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Please tell us how you’re trying to install WP. It should create its own tables once you create the database.

    Thread Starter carneyclegg3

    (@carneyclegg3)

    Tried to install, and the database tables did not get created, so I found schema.php and copied the section where the table were created using “Create Table”, then tried to run the config.php file, which allows the tables to be repaired, and it says they have been repaired, however, each time I try to open admin.php, I get the “Repair Database Table” error.

    I could never figure out how to get the tables installed during the installation process, so I imagine that is the problem I’m having. I do have both PHP and My SQL installed, have created a database, and again, manually created the correct database tables using the schema.php file.

    I am sure there is an easier way to do this, but it just didn’t work for me. Tried uninstalling the database and reinstalling it again, but that didn’t work.

    To be quite honest, I’ve been spending the week trying to learn about wordpress so that I could figure this out, but just can’t do it.

    I am using IIS as my web server, so that might have something to do with it…

    Thanks in advance for your help…

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    IF you’re just doing this for local hosting/dev, then use https://localwp.com to create a local WP environment.

    Thread Starter carneyclegg3

    (@carneyclegg3)

    Tried that, got the error message “Installation Aborted, Setup was not completed successfully”, Then tried deleting everything I had tried before, tried again and got the same message. I have the feeling that something I did earlier is messing this up, but I don’t know how to fix it…

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Where are you trying to install WordPress? Are you actually using “local”?

    Thread Starter carneyclegg3

    (@carneyclegg3)

    Set it up this way …

    C:\inetpub\wwwroot\wordpress\Local

    Is that not correct?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    IF you’re just doing this for local hosting/dev, then use https://localwp.com to create a local WP environment.

    Is this a site you’re exposing to the web or only for your own use?

    Jorge Luiz

    (@jluizsouzadev)

    Thread Starter carneyclegg3

    (@carneyclegg3)

    So here is my latest error message..
    WordPress database error Unknown column ‘wp_’ in ‘field list’ for query SELECT wp_
    The error occurs at
    http://localhost/wordpress/wp-admin/setup-config.php?step=2 when running localhost/wordpress/wp-admin/install.php

    Here is what I’ve done.
    1. Installed IIS, so that you can do a localhost
    2. Installed MySQL, Created a database,
    3. Downloaded and unzipped wordpress into the “WordPress’ directory at inetpub/wwwroot.
    3. Edited wp-config.php so that it includes all of the relevant information, added in the correct database information, left the prefix as it was “Wp_”, also updated this so that the key values have unique fields.
    3. Installed PHP, should be correct as you can do a PHP info in localhost, and you can do a php -v at a command prompt
    4. Updated PHP.INI so that display errors is set to on, and the error log is set to php errors.log, this was suggested on the internet for this type of error.

    In the past, I have added the tables manually, using the create table commands from schema.php, but decided this time to create a blank database and start from scratch.

    I’m thinking by the end of September I’ll be able to figure this out. Obviously, other people have been able to get wordpress installed, so if I keep trying I’ll probably get it.

    Just out of curiosity, which step is it that creates the tables in MYSQL? Maybe I could run that manually and get this to work.

    Again, thanks for your help. It probably is not that hard to install, other people seem to be able to get WordPress to work without any difficulty.

    Thread Starter carneyclegg3

    (@carneyclegg3)

    Figured out what was wrong. In order for the wordpress script to work, it had to have permission to run in IIS. By default, you have to have administrator permission in order to make changes to an IIS web site. I was able to get the install to work by changing the permissions in IIS.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Wp_options table not available…’ is closed to new replies.