Title: Installing/Creating Db Error 1064
Last modified: August 18, 2016

---

# Installing/Creating Db Error 1064

 *  [chalkmuppet](https://wordpress.org/support/users/chalkmuppet/)
 * (@chalkmuppet)
 * [19 years, 6 months ago](https://wordpress.org/support/topic/installingcreating-db-error-1064/)
 * Hi
 * The install script returns with a host of My Sql errors of type 1064 (see later).
   I saw the answers to the other queries about importing/exporting but this is 
   a new install and i can’t seem to use those solutions.
 * I’m running on MySQL server and client verion 4.x. this is a clean install into
   a new host.
 * below is one example run directly into the sql command line. it does not seem
   to like the like beginning primary key.
 * All and any help appreciated!
 * thanks
 * Simon
 * SQL query:
 * CREATE TABLE (
    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))
 * MySQL said: Documentation
    #1064 – 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 ‘( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(2

Viewing 1 replies (of 1 total)

 *  Thread Starter [chalkmuppet](https://wordpress.org/support/users/chalkmuppet/)
 * (@chalkmuppet)
 * [19 years, 6 months ago](https://wordpress.org/support/topic/installingcreating-db-error-1064/#post-483327)
 * Hi
 * Just been through this a little more and it seesm that the SQL queries have no
   table names associated with them…
 * CREATE TABLE ( 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) )
 * … and, oddly, this seems to cause the problems I’m having.
 * So this suggests that something in my initial config is screwy as i suggest the
   table names are generated from (uninitisliased) variables.
 * So, given this, any ideas what i should look at ?
 * Thanks
 * Simon

Viewing 1 replies (of 1 total)

The topic ‘Installing/Creating Db Error 1064’ is closed to new replies.

## Tags

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

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 1 participant
 * Last reply from: [chalkmuppet](https://wordpress.org/support/users/chalkmuppet/)
 * Last activity: [19 years, 6 months ago](https://wordpress.org/support/topic/installingcreating-db-error-1064/#post-483327)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics