Mantis 2.4 SQl Server wrong query generated
Posted: 16 May 2018, 14:28
Mantis 2.4 install on MS sql srv 2005 wrong query generated.
Schema step 2: CreateTableSQL ( mantis_bug_file_table )
the generated query is:
CREATE TABLE mantis_bug_file_table ( id INT IDENTITY(1,1) NOT NULL, bug_id INT DEFAULT 0 NOT NULL, title VARCHAR(250) DEFAULT '' NOT NULL, description VARCHAR(250) DEFAULT '' NOT NULL, diskfile VARCHAR(250) DEFAULT '' NOT NULL, filename VARCHAR(250) DEFAULT '' NOT NULL, folder VARCHAR(250) DEFAULT '' NOT NULL, filesize INT DEFAULT 0 NOT NULL, file_type VARCHAR(250) DEFAULT '' NOT NULL, date_added TIME DEFAULT '1970-01-01T00:00:00' NOT NULL, content IMAGE NULL, PRIMARY KEY (id) )
TIME is not valid data type. I think it should be DATETIME instead.
I cannot continue with the installatoin even if I ran the correct query by hand on the data base.
Any solution for this kind of problem? I will have problems with all the TIME columns
Schema step 2: CreateTableSQL ( mantis_bug_file_table )
the generated query is:
CREATE TABLE mantis_bug_file_table ( id INT IDENTITY(1,1) NOT NULL, bug_id INT DEFAULT 0 NOT NULL, title VARCHAR(250) DEFAULT '' NOT NULL, description VARCHAR(250) DEFAULT '' NOT NULL, diskfile VARCHAR(250) DEFAULT '' NOT NULL, filename VARCHAR(250) DEFAULT '' NOT NULL, folder VARCHAR(250) DEFAULT '' NOT NULL, filesize INT DEFAULT 0 NOT NULL, file_type VARCHAR(250) DEFAULT '' NOT NULL, date_added TIME DEFAULT '1970-01-01T00:00:00' NOT NULL, content IMAGE NULL, PRIMARY KEY (id) )
TIME is not valid data type. I think it should be DATETIME instead.
I cannot continue with the installatoin even if I ran the correct query by hand on the data base.
Any solution for this kind of problem? I will have problems with all the TIME columns