ERROR 1064 while trying to import a sqlite converted to mysql into my database

Discussion in 'MySQL' started by j4sp3rr, Jun 29, 2012.

  1. #1
    i am trying to import a teamspeak 3 sqlite converted into mysql to my mysql on the same server to home for better stability and what not and to be able to control it better, however i get this error:
    ERROR 1064 (42000) at line 8565: 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 ')' at line 1
    Code (markup):
    the corresponding line is:
    CREATE TABLE tokens (  server_id         integer unsigned,  token_key         varchar(50) NOT NULL,  token_type        integer,  token_id1         integer unsigned,  token_id2         integer unsigned,  token_created     integer unsigned,  token_description varchar(255),  token_customset   varchar);
    Code (markup):
    could somebody please check this and see if i have done anything wrong?

    as far as i can tell i have the newest mysql.
     
    j4sp3rr, Jun 29, 2012 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hi,

    try setting token_customset varchar to token_customset varchar(255) and it works
    :)
     
    koko5, Jun 29, 2012 IP