Table names not set up in wp-settings.php

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.