Installing/Creating Db Error 1064

  • chalkmuppet

    (@chalkmuppet)


    18 years ago

    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

    (@chalkmuppet)

    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.