View Issue Details

IDProjectCategoryView StatusLast Update
0015582mantisbtinstallationpublic2013-03-19 18:43
Reporterianprice_stopford Assigned Todregad  
PriorityurgentSeverityblockReproducibilityalways
Status closedResolutionduplicate 
PlatformIIS7OSWindowsOS Version7
Product Version1.2.14 
Summary0015582: Unable to Install on MSSQL (SQL Server 2008)
Description

When installing to SQL Server 2008 all steps are green (Good) until the one detailing:

Schema DropColumnSQL ( mantis_tokens_table )

This shows in error, detail:

"BAD
ALTER TABLE mantis_tokens_table DROP CONSTRAINT
ALTER TABLE mantis_tokens_table DROP COLUMN timestamp
SQLState: 42000 Error Code: 102 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'CONSTRAINT'. "

This is preventing me installing the system to evaluate it for use.

This is not an upgrade - I have seen other issues for upgrades mentioning similar issues, but this related to a new installation.

PHP, etc is set up fine on IIS.

Tried a few times, and same each time.

Also; Ran with "Print SQL Queries instead of Writing to the Database " checked - the generated SQL does not run on MSSQL.

Attached screenshot of issue.

Steps To Reproduce

As description - installation on MSSQL, fails at database create stage.

TagsNo tags attached.
Attached Files
Mantis Error at Install.jpg (73,139 bytes)   
Mantis Error at Install.jpg (73,139 bytes)   

Relationships

duplicate of 0011524 closeddregad 1.2.0rc2 with MS SQL not installable 

Activities