MYSQL error #1064
Posted: 19 Nov 2007, 18:42
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?
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?
?