• 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.

Viewing 15 replies - 1 through 15 (of 21 total)
  • I’ve got the same error.
    There`s a way to manually create the tables?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    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.

    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?!

    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

    it is not an problem with the sql user. also the root mysql user runs into that problem.
    pls help

    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.

    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

    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

    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

    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

    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

    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.

    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

    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

    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

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘Installation Problem (Windows Server 2008) – Tables Not Being Created?’ is closed to new replies.