MYSQL error #1064

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Teqskater
Posts: 2
Joined: 19 Nov 2007, 18:37

MYSQL error #1064

Post by Teqskater »

Ive the newest version of mantis, newest version of mysql etc (everything the newest version for sure) and i get this error when i try to install:

Fout

SQL-query:

CREATE TABLE mantis_config_table(
config_id VARCHAR( 64 ) NOT NULL ,
project_id INTEGER NOT NULL DEFAULT 0,
user_id INTEGER NOT NULL DEFAULT 0,
access_reqd INTEGER DEFAULT 0,
TYPE INTEGER DEFAULT 90,
value XS NOT NULL ,
PRIMARY KEY ( config_id, project_id, user_id )
) TYPE = MYISAM ;

MySQL retourneerde: Documentatie
#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 'XS NOT NULL,
PRIMARY KEY (config_id, project_id, user_id)
)TY' at line 7


Help?
Teqskater
Posts: 2
Joined: 19 Nov 2007, 18:37

Re: MYSQL error #1064

Post by Teqskater »

Is there any support in here :( :? ?
seiji
Posts: 15
Joined: 03 Nov 2007, 09:43
Location: Chiba, Japan

Re: MYSQL error #1064

Post by seiji »

Post Reply