View Issue Details

IDProjectCategoryView StatusLast Update
0008599mantisbtdb mssqlpublic2014-05-16 15:00
Reporterrbendig Assigned Torombert  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Product Version1.1.0rc2 
Summary0008599: Error during isnert of mantis user...
Description

The Installation of mantis failed, while inserting the admin user into the users table of mantis.

I dindn't mark this as block, because support for mssql is still experimental, but i think this should getting fixed ;)

Additional Information

I am gettint this error during install:

--- snip ---
BAD
INSERT INTO mantis_user_table(username, realname, email, password, date_created, last_visit, enabled, protected, access_level, login_count, lost_password_request_count, failed_login_count, cookie_string) VALUES ('administrator', '', 'root@localhost', '63a9f0ea7bb98050796b649e85481845', '2007-11-22 11:55:48', '2007-11-22 11:55:48', 1, 0, 90, 3, 0, 0, '0ab9f872ad18615f28c41af9380fa167c1d9abf6a8c7444c11d8136a313c6b22')
Die Anweisung wurde beendet.
--- /snip --

It was not clear to me, so i went to my sql manager and paste the query directly to the sqlserver, then i got a - much better - other errormessage:

--- snip ---
Meldung 242, Ebene 16, Status 3, Zeile 3
Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert außerhalb des gültigen Bereichs.
Die Anweisung wurde beendet.
---/snip ---

on English this means
--- snip ---
The conversion of a char data type to a datetime data type resulted in

an out-of-range datetime value.
--- /snip ---

Tagsinstall, mssql

Relationships

duplicate of 0007905 closeddregad Install check failed 

Activities

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040386

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul