View Issue Details

IDProjectCategoryView StatusLast Update
0017011mantisbtdb mssqlpublic2014-12-05 18:33
Reporterjeckyll Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformWindows Server 2003 
Product Version1.2.16 
Target Version1.2.18Fixed in Version1.2.18 
Summary0017011: 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
One graph is missing

TagsNo tags attached.

Activities

grangeway

grangeway

2014-02-20 12:02

reporter   ~0039479

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.

grangeway

grangeway

2014-03-27 19:12

reporter   ~0039751

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.

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040327

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

Related Changesets

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