View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0016878 | mantisbt | db mssql | public | 2014-01-24 10:19 | 2014-12-08 00:34 |
Reporter | sormiou | Assigned To | dregad | ||
Priority | high | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | Windows 2008 R2 | ||||
Product Version | 1.2.15 | ||||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0016878: Install triggers varchar to datetime conversion error on sql server 2008 | ||||
Description | the procedure for creating instalaltion based on SQL Server 2008 correctly. There is an error when adding the adminitrateur mantis_user_table in the table. BAD | ||||
Additional Information | The occurence of this error likely depends on the DATEFORMAT setting. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Would you be able to test the installation procedure using a nightly build from the master (1.3) branch ? Download from http://www.mantisbt.org/builds.php |
|
Hi, With the latest "MantisBT-1.3.0dev-master-a6a3a13" version is the message obtained. The base is created but contains only one table. See the attached file! thank you |
|
Marking as Suspended MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release. I'd strongly advise using MYSQL for now. The new DB layer already contains the appropriate fixes for MS SQL Support. |
|
We are having the same problems reported by sormiou, both with the stable version and with the latest nightly build. When is the new release - the one including the needed fixes to the db layer - expected to be ready? |
|
This is a bit difficult for me to check, as I not only do not use nor have access to an MSSQL instance, but also have limited knowledge with this db. I think the error is due to the fact that Mantis is using unix timestamps internally, which needs to be converted to a format usable by the RDBMS. The ADOdb library converts that to an ANSI SQL standard date format 'YYYY-MM-DD HH:MM:SS', which is apparently not recognized as a date by your DB server.
Let me know how it goes. |
|
OK, the issue was fixed, but the line had to be adjusted this way: var $fmtTimeStamp = "'Y-m-d\TH:i:s'"; Thanks |
|
Sorry, forgot the "\". I'll get that fixed upstream in ADOdb. |
|
Fix committed upstream [1], will be included in ADOdb 5.19 and fixed in Mantis 1.3 [1] https://github.com/ADOdb/ADOdb/commit/09dd1b56bb3c3b006a965460fdce9f659306c063 |
|
MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release. I'd strongly advise using MYSQL for now. The new DB layer already contains the appropriate fixes for MS SQL Support. |
|
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 |
|
Reminder sent to: dregad, grangeway Not sure, maybe this issue should be moved back to project mantis as the fix is targetted to 1.3, there is a fix committed upstream and dregad is assigned. If so, grangeway could make a copy of it in project "Track DBAL replacement" |
|
Definitely should be moved, fix for this is covered in pending pull request https://github.com/mantisbt/mantisbt/pull/181 |
|
Issue cloned back into Track DBAL replacement as requested. My advice to end users is still to wait on upgrading to 1.3 for the new db layer which Victor has said we can do a release of within a month of 1.3 Paul |
|
With ADOdb 5.19 now merged in master branch, this issue should be resolved. |
|
MantisBT: master a2b23b3b 2014-07-09 08:18 Details Diff |
Update ADOdb to 5.19 - update the submodule - back to ADODB_FETCH_ASSOC for oci8 - fix db_query_bound() $p_arr_parms null default issue Fixes pull request https://github.com/mantisbt/mantisbt/pull/181 |
Affected Issues 0012150, 0016878 |
|
mod - core/constant_inc.php | Diff File | ||
mod - core/database_api.php | Diff File | ||
mod - core/project_hierarchy_api.php | Diff File | ||
mod - core/summary_api.php | Diff File | ||
mod - core/user_api.php | Diff File | ||
mod - library/README.libs | Diff File | ||
mod - library/adodb | Diff File | ||
mod - manage_user_page.php | Diff File |