• 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 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 ‘(‘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.