Install fail – DB tables not created

  • Hi,

    I run my own servers and have full config access to them.
    I am having problems running wp-admin/install.php (WP 2.9.2)

    Calling the install URL results in a blank page, and these errors in my php error log:

    WordPress database error: [Table ‘wordpress.wp200_options’ doesn’t exist]
    SELECT option_value FROM wp200_options WHERE option_name = ‘cron’ LIMIT 1

    WordPress database error: [Table ‘wordpress.wp200_options’ doesn’t exist]
    INSERT INTO wp200_options (option_name, option_value, autoload) VALUES (‘cron’, ….

    I have created the MySQL database, database user and GRANTed all privileges (apart from SUPER) and flushed privileges. wp-config.php contains the correct info, and I have tried editing the DB_USER to one which doesn’t exist, which in turn gives me the bold “Error establishing a database connection” error message.

    The only thing I have done which is potentially slightly weird is checked my WP install directory in to a subversion repository, and the website is running from a checked-out directory of that code. However I run separate suite of other sites, with WP blogs, under the same scheme with no issues whatsoever.

    It seems to me that the CREATE TABLE queries are all failing (ungracefully). That would indicate a permissions error, but if it were as simple as that, then I’d expect a DB error message from WP, not a blank page and PHP error. AS far as I can tell, all my MySQL permissions are in order, and I can’t find any other error messages (particularly ones relating to failed CREATE TABLE)

    Any help greatly appreciated.

    Stu

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter jominystu

    (@jominystu)

    I am running PHP 5.2.6 and MySQL 5.0.45 on Fedora 8 (on EC2).

    Hi,

    Can you write a sample PHP script to create table in the database? If it doesn’t work then there is some problem that needs further investigation.

    Kailash

    If wp200_options doesn’t exist what tables do exist (SHOW TABLES)?

    Thread Starter jominystu

    (@jominystu)

    Dave, no tables have been created, the wordpress DB is empty.

    Kailash1 – good idea. I’ll give that a try and report back.

    I had a suggestion from a colleague that permissions on the WP files themselves may be the culprit. Does this chime with anyone else’s experience?

    Stu

    Thread Starter jominystu

    (@jominystu)

    I am able to successfully create tables via the WP code, within the wp-settings.php file, just a few lines of code above where the ‘table does not exist’ errors start appearing.

    The problems I am seeing commence with the inclusion of this line of code in wp-settings (around line 385):

    require (ABSPATH . WPINC . ‘/update.php’);

    …however I suspect that the create table queries are not being run when they should.

    By unpicking the code I see that the database tables are defined in /includes/schema.php
    This file isn’t included/parsed by install.php until several lines *after* wp-settings.php.
    The order of inclusion, as I make it, is this (indented files included by the parent above)

    wp-load.php
    wp-config.php
    wp-settings.php
    /includes/upgrade.php
    includes/admin.php
    includes/schema.php

    …which looks to me like it’s impossible that the tables can be created before the line in wp-settings.php, require (ABSPATH . WPINC . ‘/update.php’);.

    I am clearly missing something fundamental.
    Anyone any clue? My 5 minute WP install is taking days ??

    Stu

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Install fail – DB tables not created’ is closed to new replies.