Installation problem: syntax errors
-
I am trying to install wordpress 2.0.1
Every thing went fine until the second step of the installation process.I recieved these errors:
—-
Second StepNow 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 SETautoload= ‘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 SETautoload= ‘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 SETautoload= ‘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 ‘(‘b86872’), ‘jpascale@uchicago.edu’, NOW(), ‘jpascale’, ‘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(‘b86872’), ‘jpascale@uchicago.edu’, NOW(), ‘jpascale’, ‘admin’)WordPress database error: [Table ‘jpascale.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 ‘jpascale.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!
—-Does anyone know what might be causing these errors?
Some tables are created by the install script, but those for which errors occur are not.
mysql –version produces:
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)Thank you for your help,
James
The topic ‘Installation problem: syntax errors’ is closed to new replies.