Mantis Bug Tracker - Forums

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

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.

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

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

Did you try install Mantis 1.0.6?

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.

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.