View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0017011 | mantisbt | db mssql | public | 2014-02-20 10:41 | 2014-12-05 18:33 |
Reporter | jeckyll | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Windows Server 2003 | ||||
Product Version | 1.2.16 | ||||
Target Version | 1.2.18 | Fixed in Version | 1.2.18 | ||
Summary | 0017011: Graph « Cumulative by date » is not displayed in Summary > Advanced Summary | ||||
Description | with PHP 5.2.12 ~ FastCGI, SQL Server 2012 database with db_type = "mssql" On page Summary > Advanced Summary, the first graph (Cumulative by date) is not displayed. The HTML source code of the page show an SQL error : SQL Server complains that it cannot convert varchar to int. The faulty query can be found in <b>graph_api.php</b>, function <b>create_cumulative_bydate()</b>, second SELECT statement This bug may be specific to SQL Server, but it also occurs with db_type = "mssqlnative" | ||||
Steps To Reproduce | Go to Summary > Advanced Summary | ||||
Tags | No tags attached. | ||||
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. |
|
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 |
|
MantisBT: master-1.2.x 7e003e91 2014-02-20 06:31 jeckyhl Committer: dregad Details Diff |
Fix graph display in advanced summary with MSSQL Graph « Cumulative by date » is not displayed in Summary > Advanced Summary, SQL Server complains that it cannot convert varchar to int. Fixes 0017011, https://github.com/mantisbt/mantisbt/pull/142 Signed-off-by: Damien Regad <dregad@mantisbt.org> |
Affected Issues 0017011 |
|
mod - plugins/MantisGraph/core/graph_api.php | Diff File | ||
MantisBT: master 8f175254 2014-02-20 06:31 jeckyhl Committer: dregad Details Diff |
Fix graph display in advanced summary with MSSQL Graph « Cumulative by date » is not displayed in Summary > Advanced Summary, SQL Server complains that it cannot convert varchar to int. Fixes 0017011, https://github.com/mantisbt/mantisbt/pull/142 Signed-off-by: Damien Regad <dregad@mantisbt.org> |
Affected Issues 0017011 |
|
mod - plugins/MantisGraph/core/graph_api.php | Diff File |