this is the reference to the thread in the forum http://www.mantisbt.org/forums/viewtopic.php?t=1106&highlight=mssql+insert

I had the same error, you need to replace :
line 78
< var $fmtTimeStamp = "'Y-m-d h:i:sA'";

var $fmtTimeStamp = "'Y-d-m h:i:sA'";

Cordially,

Jonathan

I take it this is the case for all queries not just the initial install? (i.e. that 2007-08-07 and 2007-07-08 mean the same date depending on where you live in the world.

johnjohn33
replace line 78 of what file?

Sorry for answering so lately, you need to replace line 78 in adodb-mssql.inc.php file.

If you take it, it's for all queries.

I find this really strange, I never saw a date format that is Y-d-m, usually it is d-m-Y or m-d-Y or Y-m-d. Does this depend on the locale of the machine running the MS SQL server? That would be even worth.

If that proves to be a needed change in ADODB, please report it to ADODB and include the link to the bug here.

I found a solution for this (this works for EVERY language) so if your database is in french o any other language do the following

1)Copy the query to execute it directly in the mssql adding the following line

set language us_english
GO
/ and then the query /
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-04-16 02:00:14PM', '2007-04-16 02:00:14PM', 1, 0, 90, 3, 0, 0, '26dacbac22cb72b46c359b809ebf82cdc3339bdc7d0e83504b0842a352d55ff6')

2) Configure the user thar acces the database to have the default language in English to do this go to the Microsoft sql server management studio -> security->login and click the properties of the user that uses mantis to acces the database. Then change the Default language to English

This is not an ADODB problem it only the configuration of SQL SERVER

Hope this helps

Based on the last entry from @clan_destina, this is not an issue with MantisBT but caused by setup of MSSQL.

Mantis DB Account should be configured to have English as default language in MSSQL server management studio.

@rombert, as you initially confirmed this issue, feel free to reopen if you don't agree with the above statement.

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