Instalation with MSSQL

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
mdaron
Posts: 1
Joined: 20 Jan 2017, 13:54

Instalation with MSSQL

Post by mdaron »

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...
atrol
Site Admin
Posts: 8378
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Instalation with MSSQL

Post by atrol »

mdaron wrote: Please help...
Can't help, I don't use MSSQL
Might help some way http://www.mantisbt.org/bugs/view.php?id=22063
Please use Search before posting and read the Manual
Post Reply