problem installing 1.0 on ms sql server

[emil]

hello list,

i'm trying to install mantis 1.0 stable on sql server but end up with the following error:

"BAD
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INT DEFAULT 0 NOT NULL, user_id INT DEFAULT 0 NOT NULL, access_reqd INT DEFAULT 0, type INT DEFAULT 90, value TEXT NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )
[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'mantis_config_table' in the database."

checking ms sql server after this error shows no Mantis bugtracker database been created.

does anybody has any clues?

regards,

Emil

[Narcissus]

Hi Emil,

Just wanted to make sure that this is actually a fresh install, and you're not actually upgrading a Mantis installation?

I'd have thought that error would show if you were doing an upgrade maybe...

Thanks,
Lincoln.

[emil]

Hi Lincoln,

It is a fresh install indeed.

In fact it is the first time I try installing Mantis on Microsoft SQL Server.

Til now we have had Mantis running on MySQL.

Regards,

Emil

[Jean-Noel]

Hello, i have the same problem, mantis installation stoped on [Create Schema ( CreateTableSQL on mantis_config_table )]
I have mantis installed with easyphp and mysql and it works fine.

But i wish to install mantis on sql server and this ... i don't understand. Is the schema are not good ?

Thxs

[vboctor]

Did you try install Mantis 1.0.6?

[Jean-Noel]

I try to install mantis 1.05 and 1.06 and 1.1.0a2 ... but nothing i'have the same error in the all case
I wih install in final mantis 1.05 because is this version who work actually in my society with mysql.

[vboctor]

Please report this in the bug tracker under [db mssql] category and also refer to this thread. This way we can keep track of it, test it and fix it if we can reproduce the problem.