Mantis 1.3 installation with MSSQL with BAD ALTER TABLE err
Posted: 09 Aug 2016, 03:19
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
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