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
Mantis 1.3 installation with MSSQL with BAD ALTER TABLE err
Moderators: Developer, Contributor
Re: Mantis 1.3 installation with MSSQL with BAD ALTER TABLE
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?
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?