View Issue Details

IDProjectCategoryView StatusLast Update
0017053mantisbtdb mssqlpublic2023-05-04 16:23
Reporterraf123ca Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Summary0017053: Database query failed 0008115
Description

When editing an existing logged issue, and entering any new text on the description as well as on Notes. Scenario would be to update the description and also add a new note (both at the same time); we get an error message saying Database query failed. This issue is reproducible.

TagsNo tags attached.
Attached Files
Mantis_DB_error.png (30,032 bytes)   
Mantis_DB_error.png (30,032 bytes)   
Mantis.zip (290,196 bytes)

Relationships

has duplicate 0017052 closedatrol Database query failed 0008115 

Activities

raf123ca

raf123ca

2014-02-27 14:02

reporter   ~0039577

a video is also available to reproduce the issue.

grangeway

grangeway

2014-03-27 19:12

reporter   ~0039750

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   ~0040326

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

dregad

dregad

2023-04-22 10:41

developer   ~0067686

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue.

[1] http://www.mantisbt.org/download.php