Mantis 1.3 installation with MSSQL with BAD ALTER TABLE err

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
tzuchikl
Posts: 1
Joined: 09 Aug 2016, 03:09

Mantis 1.3 installation with MSSQL with BAD ALTER TABLE err

Post by tzuchikl »

Dear Sir/Madam,

After configuring IIS and PHP with MSSQL driver and ODBC connect, while I try to run installation through http://localhost/mantis/admin/install.php

it is displaying an error as below and the installation abort without completed.

Schema step 65: AlterColumnSQL ( mantis_user_pref_table )
BAD
ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay INT DEFAULT 0 NOT NULL
SQLState: 42000 Error Code: 156 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'DEFAULT'.

I am not a developer, just a normal IT support, searching through mantis knowledge based and found that need to execute some sql command manually to solve the problem. Which I don't know how to do it? Appreciate if someone can help to provide some details procedure for me to follow.

I am using MS SQL 2008 R2.

Thanks
jhptm
Posts: 1
Joined: 18 Aug 2016, 14:56

Re: Mantis 1.3 installation with MSSQL with BAD ALTER TABLE

Post by jhptm »

Hi,
I have the same problem.

I found in search.php?keywords=AlterColumnSQL&t=21339&sf=msgonly

"... in mantis 1.3 in datadict-mssqlnative.inc.php has no SUPPORT for ALTERCOLUMNSL function.
this function is COMMENTED! ..."

Does anyone have a solution?
Post Reply