Support » Installing WordPress » Wp_options table not available…
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]
-
Please tell us how you’re trying to install WP. It should create its own tables once you create the database.
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…
IF you’re just doing this for local hosting/dev, then use https://localwp.com to create a local WP environment.
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…
Where are you trying to install WordPress? Are you actually using “local”?
Set it up this way …
C:\inetpub\wwwroot\wordpress\Local
Is that not correct?
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?
I recommend you to try to install WP from scratch.
Maybe those guides could help you with the entire install process step by step: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.phpHere 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.
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.
- The topic ‘Wp_options table not available…’ is closed to new replies.