2.0 Install: Yet Another DB error.

Sorry, but I don’t see any posts in the forum that seem to fix this.

I have all the minimum requirements satsified with my hosting server. I’ve walked carefully through all the setup steps and believe I have them correct. When I get to step 2, I see the errors below. Some of the tables don’t get created and/or populated. Please help, and thanks!

Second Step

Now we’re going to create the database tables and fill them with some default data.

WordPress database error: [Column ‘meta_key’ is used with UNIQUE or INDEX but is not defined as NOT NULL]
CREATE TABLE wp_postmeta ( meta_id bigint(20) NOT NULL auto_increment, post_id bigint(20) NOT NULL default ‘0’, meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY post_id (post_id), KEY meta_key (meta_key) )

WordPress database error: [Column ‘meta_key’ is used with UNIQUE or INDEX but is not defined as NOT NULL]
CREATE TABLE wp_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default ‘0’, meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )

WordPress database error: [You have an error in your SQL syntax near ‘autoload = ‘no’ WHERE option_name = ‘moderation_keys” at line 1]
UPDATE wp_options SET autoload = ‘no’ WHERE option_name = ‘moderation_keys’

WordPress database error: [You have an error in your SQL syntax near ‘autoload = ‘no’ WHERE option_name = ‘recently_edited” at line 1]
UPDATE wp_options SET autoload = ‘no’ WHERE option_name = ‘recently_edited’

WordPress database error: [You have an error in your SQL syntax near ‘autoload = ‘no’ WHERE option_name = ‘blacklist_keys” at line 1]
UPDATE wp_options SET autoload = ‘no’ WHERE option_name = ‘blacklist_keys’

WordPress database error: [You have an error in your SQL syntax near ‘rel_id, post_id, category_id) VALUES (1, 1, 1)’ at line 1]
INSERT INTO wp_post2cat (rel_id, post_id, category_id) VALUES (1, 1, 1)

WordPress database error: [You have an error in your SQL syntax near ‘(‘7669c5’), ‘g3000@mac.com’, NOW(), ‘g3000’, ‘admin’)’ at line 1]
INSERT INTO wp_users (ID, user_login, user_pass, user_email, user_registered, display_name, user_nicename) VALUES ( ‘1’, ‘admin’, MD5(‘7669c5’), ‘g3000@mac.com’, NOW(), ‘g3000’, ‘admin’)

WordPress database error: [Table ‘press.wp_usermeta’ doesn’t exist]
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (2, ‘wp_user_level’, ’10’);

WordPress database error: [Table ‘press.wp_usermeta’ doesn’t exist]
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (2, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’);

Finished!

Now you can log in with the username “admin” and password “xxxxx”.

Note that password carefully! It is a random password that was generated just for you. If you lose it, you will have to delete the tables from the database yourself, and re-install WordPress. So to review:

Username
admin
Password
********[password moderated]
Login address
wp-login.php