Title: Installation problem: syntax errors
Last modified: August 18, 2016

---

# Installation problem: syntax errors

 *  [jamestp](https://wordpress.org/support/users/jamestp/)
 * (@jamestp)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/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 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.

## Tags

 * [installation](https://wordpress.org/support/topic-tag/installation/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 0 replies
 * 1 participant
 * Last reply from: [jamestp](https://wordpress.org/support/users/jamestp/)
 * Last activity: [20 years, 3 months ago](https://wordpress.org/support/topic/installation-problem-syntax-errors/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics