1.2.0rc2 + MS SQL = Not working?

[timmi]

Hi guys,

I can't get it to work.

With "Print SQL Queries instead of Writing to the Database" checked, I get some curious WARNINGS inside the sql statements:

SYSTEM WARNING: htmlentities() expects parameter 1 to be string, array given
;

One line above each of these warnings (they appear 14 times) are commands I've never seen before:

Code: Select all

date_migrate;

After deleting these warnings from the sql script I tried to run it but it seems that MS SQL couldn't interprete these _migrate commands (date_migrate & category_migrate)?
______________

After removing BOTH (_migrate commands & warning messages) the script stops at various ALTER TABLE commands the first one is this:

Code: Select all

ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay INT;

The error message looks like this:

Code: Select all

Meldung 5074, Ebene 16, Status 1, Zeile 425
Das Objekt-Objekt 'DF__mantis_us__redir__2739D489' ist vom Spalte-Objekt 'redirect_delay' abhängig.

Think it has something to do with bound private keys, constraints, ...

Can anyone help me?

Has anybody already installed 1.2.0rc2 with MS SQL Server 2005?


ty

timmi

Edit:

[atrol]

These are already known bugs
Have a look at
http://www.mantisbt.org/bugs/view.php?id=11364
There I provided a suggestion how to solve one of them, but until now there was no reaction from development.

[timmi]

I'm working on a manual hotfix for the sql insertions...

Edit:

What I have now on the login screen after integrating all alter table commands inside the create table commands manually:

APPLICATION WARNING #user_get_field() for NO_USER:

Warning: Admin directory should be removed.

Error: The database structure appears to be out of date (config(databaseversion) is 0 and old upgrade tables do not exist). Please check that your database is running - we can not retrieve the database schema version. Config Table did not return a valid database schema version - please ask for support on the mantis-help mailing list if required.

Any ideas?

[gonfva]

Just in case it helps, I have also edited the SQL creation script.

The problem "APPLICATION WARNING #user_get_field() for NO_USER" and general access to Mantis using SQL was solved editing the file

...\library\adodb\adodb.inc.php

and changing the line

define('ADODB_FETCH_ASSOC',2);

to

define('ADODB_FETCH_ASSOC',0);

[timmi]

Have you edited this file ONYL?

Everything else was okay? The whole installation script went through without errors?

Thank you!

[gonfva]

To make it working I had to edit the SQL schema creation script as you did. And once I had the database created I had the problem you mentioned (APPLICATION WARNING #user_get_field() for NO_USER). That's when I edited the file.

I documented the full process of mounting Mantis on MSSQL in my blog. I don't know if it's OK to post URLs, but you can Google for gonfva mantis

[timmi]

Related issue: http://www.mantisbt.org/bugs/view.php?id=11524