WordPress.org

Ready to get started?Download WordPress

Forums

Table names not set up in wp-settings.php (2 posts)

  1. jeremiahnewbie
    Member
    Posted 8 years ago #

    Hello all,

    I'm new to the world of WordPress and I'm trying to get it installed on a website I'm building for a friend.

    Hosting Service = Revolution Hosting (revolutionhosting.com)
    PHP version = 4.3.8
    MySQL version = 4.1.18-standard

    I tried going through the install but when I reach Part 2 of the install I get a page full of MySQL errors such as:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(option_name, option_value, option_description, autoload) VALUES]
    INSERT INTO (option_name, option_value, option_description, autoload) VALUES ('siteurl', 'http://www.violetstatic.com', 'WordPress web address', 'yes')

    I'm a bit rusty with my SQL but I noticed that the name of the table was missing in all the error messages, e.g.: wp_options or wp_users. After some digging through these forums, including this thread here:

    http://wordpress.org/support/topic/62694

    I belive that that for some reason the Table Names in wp-settings.php are not being created properly. Meaning this bit of code in that file:

    // Table names
    $wpdb->posts = 'wp_posts';
    $wpdb->users = 'wp_users';
    $wpdb->categories = 'wp_categories';
    $wpdb->post2cat = 'wp_post2cat';
    $wpdb->comments = 'wp_comments';
    $wpdb->links = 'wp_links';
    $wpdb->linkcategories = 'wp_linkcategories';
    $wpdb->options = 'wp_options';
    $wpdb->postmeta = 'wp_postmeta';
    $wpdb->usermeta = 'wp_usermeta';

    doesn't work for my server, or at least it's assinging a value of null/blank to those variables instead.

    Any idea why this is happening or what could be casuing it? I haven't the foggiest idea. Thanks in advance for any help you could provide.

  2. jeremiahnewbie
    Member
    Posted 8 years ago #

    In addition to the above: I was able to install wordpress a different webserver without any errors. I exported the database on that server into SQL and ran it on my main server to create the database.

    After changing the path values to point the the main server, I tried to log into wordpress but I received this error:

    It doesn't look like you've installed WP yet. Try running install.php.

    Again checking the code it looks like the MySQL statement that checks if the database was installed will not work because the table name is not included in the querry.

    Please, if you can think of any reason why this would be happening I would apprecaite it. Thanks again in advance.

Topic Closed

This topic has been closed to new replies.

About this Topic