WordPress › Support » Installation Problem (Windows Server 2008)

jeffmax
Member
Posted 1 year ago #

I've spent over a day trying to setup Wordpress on my Windows 2008 server but it doesn't seem to install. I've installed PHP and MySQL. They both seemed to install properly. I've done the step by step setup but when I go to the wordpress install page (http://localhost/blog/wp-admin/install.php)get the following error:

WordPress database error Table 'myblog.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('cron', 'a:2:{i:1220809724;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') made by add_option WordPress database error Table 'myblog.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('auth_salt', 'P!5jZIcs9*gt', 'yes') made by add_option

The database, username, password, and server (localhost) are all correct. I can connect to it fine. It almost seems that there aren't permissions to create the tables yet when I log into mysql with the credentials I can so I'm really stumped! Any help would be greatly appreciated.
Valdinei
Member
Posted 1 year ago #

I've got the same error.
There`s a way to manually create the tables?
Otto42
Moderator
Posted 1 year ago #

There's a way to manually create the tables?

No, because WordPress needs to have permissions to create and modify the tables.

If you can't get it to create the tables, then it won't work properly later anyway.
Grehund
Member
Posted 1 year ago #

I also have this same issue. I am installing WP onto SBS 2003 with IIS6 and have successfully Installed MySQL and PHP with FastCGI. I have confirmed my permissions on the wp sql user are correct.

Please help?!
ediren
Member
Posted 1 year ago #

iam facing the same problem. wp is installed on IIS6/W2K3 standard edition with running mysql and php with fastCGI.
mysql db connection works fine with configured user and password.
what could be the cause for this issue?
thx/br
ediren
Member
Posted 1 year ago #

it is not an problem with the sql user. also the root mysql user runs into that problem.
pls help
Grehund
Member
Posted 1 year ago #

I have also confirmed that the root user has the same problem. What version of WP are you running? I am going to try using an older version of WP.
ediren
Member
Posted 1 year ago #

my version of wp is 2.6.2 i am using PHP Version 5.2.6 as fastcgi under IIS6 (w2k3 se) and mysql 5.0.51b.

i've activated the error_log = syslog setting in the php.ini and after an IIS reset it worked fine for me because no related "create database table..." error was trown in course of the wordpress setup anymore . can anybody acknowledge to that?
thx/br
ed
sixdegreeguy
Member
Posted 1 year ago #

Yeah i'm having the same problem:

WordPress database error Table 'db_qsblog.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('cron', 'a:2:{i:1221141312;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') made by add_option WordPress database error Table 'db_qsblog.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('random_seed', 'f88857e4a1b43f7334ddaf3033360434', 'yes') made by add_option WordPress database error Table 'db_qsblog.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('auth_salt', ')^&uIMh31gD*', 'yes') made by add_option
squireb
Member
Posted 1 year ago #

I'm having this issue at the moment, while trying to install Wordpress 2.6.2 on my Vista machine.

Has anyone managed to resolve this issue, or have a workaround?

I'm using Vista (SP1) with IIS7, PHP 5.2.6 via FastCGI, with MySQL 5.0.45.

Thanks,
Bron
mirkonetit
Member
Posted 1 year ago #

same problem...
on windows 2008 iis7 , mysql 5.0 , php 5.2.6, wp 2.6.2

Has anyone managed to resolve this issue, or have a workaround?

bye, Mirko
brianurbanik
Member
Posted 1 year ago #

I was having the same problem. Here's what my error looked like:

WordPress database error Table 'brianurbanik_com.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('cron', 'a:2:{i:1221253094;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') made by add_option WordPress database error Table 'brianurbanik_com.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('random_seed', '11c57d5b8679ae8471ab492bd27c9052', 'yes') made by add_option WordPress database error Table 'brianurbanik_com.wp_options' doesn't exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('auth_salt', 'KBbqJN(@N5#8', 'yes') made by add_option

The above string of text was at the bottom of the install page, and because it was there I kind of freaked out, did some googling, found and read this thread, and when I didn't find an answer here I emailed the guy who runs the servers my site is hosted on. Here's his response:

Your WP appears to be installed now. There was not a problem with the server or the database, rather with the installation script. The script wanted to access a table in the database that was not yet created by the installation. I simply ignored the error message and installed it.

So, in my case at least, I was alarmed by the error and didn't try to go through with the remainder of the install (the part where you enter your username and password). My site works fine now (http://brianurbanik.com/blog) and the install seemed to work perfectly fine despite the error that made me panic in the first place.

This might not be applicable to everyone, but I hope that it's at least of help to some.

bau
squireb
Member
Posted 1 year ago #

Thanks for trying to assist, brianurbanik. Unfortunately in my case, WP still hasn't installed after getting that error message - no tables have been created at all in the database.
JJRose
Member
Posted 1 year ago #

Hello.

I also am having the same database error problem. It appeared on the first step of the installation process where you enter name and email. I pressed the install button anyway, and I was told that it successfully installed, but the error message was still there (on the Step2 page).

I understand Otto42, who says that without these tables, the progam won't work properly later on and so am reluctant to go ahead with any further setting up until I can resolve this issue. I also noted the comment by brianurbanik whose web host installed the program anyway even though the error messages still appeared (same as with me). I also noted that he mentioned it may have been a problem with the installation script.

Seeing as there are already many who are having this problem, and that there seem to be no responses yet except Otto's comment, I am wondering whether it is something Wordpress is looking into before replying?

It would be great if there could either be a response that the matter is being looked into, or if there could be provided some temporary workaround, or if it is the installation scrhipt, can a patch of some sort be done?

Thanks in advance.
JJRose
ediren
Member
Posted 1 year ago #

i've activated the error_log = syslog setting in the php.ini and after an IIS reset it worked fine for me because no related "create database table..." error was trown in course of the wordpress setup anymore . can anybody acknowledge to that?

has anybody tried this with the activated error_log = syslog setting in the php.ini? in my case it helped to install wp 2.6.2 successfully.
pleas acknowledge if this help you too.
thx & br
stooley
Member
Posted 1 year ago #

I change my php.ini and it all appears to work fine now. All database tables were populated and the site is up and running without any errors at the moment.

Server 2008 running fastcgi with PHP 5.2.6 btw
renteng
Member
Posted 1 year ago #

activated error_log = syslog

It is important! Thanks!
squireb
Member
Posted 1 year ago #

OK I have given in and set "error_log = syslog" to allow the installation to continue, and so far it seems OK.

But clearly there is an underlying issue here that I hope will be investigated - as JJRose said, maybe they are looking into the issue before replying about it, but it's been a week since it was originally reported and an issue like that in an installation would seem pretty important to fix...

Thanks all for your help.
brianurbanik
Member
Posted 1 year ago #

Hello again,

Well, it serves me right, but I started having problems with Wordpress (I'm the one who's support people told me to just go ahead and install and everything will be alright). I deleted my entire installation, cleared my database, and reinstalled, only to find the same error (of course). I did some searching around, and came across this link:

http://trac.wordpress.org/ticket/7724

Have a read through that page! I made the adjustments in the php files that are suggested in the Attachments section, refreshed my Wordpress install page, and the error disappeared. Wordpress 2.6.2 seems to be installed fine now, but I'll post back here if I have any more problems (or solutions).
dgallek
Member
Posted 1 year ago #

activated

error_log = syslog

setting in the php.ini and the install seems to work now
syedabbas
Member
Posted 1 year ago #

Read through.. wish I read it earlier. Had similar issues with my host.. they suggested I turn my Php safemode off, but that didn't help either.. changed the hosting to Linux..

-Abbas
Technology Nerd
tstizzle
Member
Posted 12 months ago #

ediren is correct. the stupid installer simply needs access to a location for logging. change the log file location and off you go.

blogs. they should be a forbidden.