Hello,
I try to install mantis, but instalation crash at step 209:
Schema step 209: AlterColumnSQL ( mantis_api_token_table ) BAD
ALTER TABLE mantis_api_token_table ALTER COLUMN user_id INT NOT NULL
ALTER TABLE mantis_api_token_table ADD CONSTRAINT DF__mantis_api_token_table__user_id__747 DEFAULT 0 FOR user_id
ALTER TABLE mantis_api_token_table DROP CONSTRAINT DF__mantis_ap__date___6497E884
ALTER TABLE mantis_api_token_table ALTER COLUMN date_created INT NOT NULL
ALTER TABLE mantis_api_token_table ADD CONSTRAINT DF__mantis_api_token_table__date_created__6b74 DEFAULT 1 FOR date_created
ALTER TABLE mantis_api_token_table DROP CONSTRAINT DF__mantis_ap__date___658C0CBD
ALTER TABLE mantis_api_token_table ALTER COLUMN date_used INT NOT NULL
ALTER TABLE mantis_api_token_table ADD CONSTRAINT DF__mantis_api_token_table__date_used__489d DEFAULT 1 FOR date_used
SQLState: 42000 Error Code: 5074 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The index 'idx_user_id_name' is dependent on column 'user_id'. SQLState: 42000 Error Code: 4922 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]ALTER TABLE ALTER COLUMN user_id failed because one or more objects access this column.
versions of components:
nightli build mantisbt-2.0.0-master-dd6dd9f (2017-01-20 06:36:59)
PHP: 7.0.2 (use official connector for MSSQL (php_pdo_sqlsrv_7_ts_x64, php_sqlsrv_7_ts_x64)
MS SQL server: 2016 (SQL Server 13.0.1722.0)
When I use standard matis 2.0.0 instalation, problem is same.
At the time of instalation, there don't run any other instalation.
Please help...
Instalation with MSSQL
Moderators: Developer, Contributor
Re: Instalation with MSSQL
Can't help, I don't use MSSQLmdaron wrote: Please help...
Might help some way http://www.mantisbt.org/bugs/view.php?id=22063