Clean install of Mantis 1.2.15, W2008R2, SQL 2008 R2 Express

[dnandrews100]

Hi

I am trying to perform a new/clean installation of Mantis 1.2.15 on a WIndows 2008 R2 SP1 server, PHP 5.4.20 (x86) and SQL Express 2008 R2.

I have PHP working, including the SQLSRV extensions for PHP 5.4.

I have extracted the Mantis 1.2.15 files into the \inetpub\wwwroot folder and the Mantis install.php script can connect to the database and start the installaton process, creating tables etc.

However, at a point in the script, it fails with the following error at the following step:

Schema DropColumnSQL ( mantis_tokens_table )

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'.

I have found some forum posts relating to the problem where people have posted a variety of 'patch' files for some of the .php files in the /adodb/library directory but these appear to be quite old and I am not sure which (if any) I might need, or how to apply them in a Windows environment. There are also some adodb references to different versions and patches, but again, I am unsure if this is something I need to apply or how.

Can anyone provide some information on performing a clean installation for a Windows/SQL Server 2008 R2 environment, or the steps I need to take to complete the installation sucessfully?

Any help would be much appreciated.

Regards
David

[dnandrews100]

Hi

I have run through each of the SQL commands manually and corrected any Constraint commands to work with SQL Server.

I have then updated the config_inc.php file and it appears to be working.

I am able to log in and browse through the various menus etc. It needs more testing but appears to be OK at first glance.

Is there anything else I need to do that will not have been automated due to how I ran the scripts.

Thanks
David

[Coolpro21]

David - I'd be interested in step-by-step instructions for doing a clean installation in Windows Server 2008 R2 with MSSQL. Are there any steps you would take during the installation to avoid the Constraints errors, or is that something you have to deal with after installation, and what are those steps you used to correct the Constraints commands?

Regards,
JP