View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0009356mantisbtdb mssqlpublic2008-07-07 10:472014-05-16 15:00
ReporterLordLarry Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionno change required 
PlatformWindowsOSWindows ServerOS Version2003
Product Version1.2.0a1 
Summary0009356: ADODB uses wrong query to get LastID
Description

It uses SCOPE_IDENTITY() which is safer, but fails to return a result after a sp_execute which mantis uses.

Using @@identity solves the problem, but is less safe

Steps To Reproduce

Report a bug on a MSSQL database and see that it fails reporting bug_text is NULL

TagsNo tags attached.

Activities

LordLarry

LordLarry

2008-07-07 10:55

reporter   ~0018325

Forget to set this to major
giallu

giallu

2008-07-09 09:20

reporter   ~0018347

is this reported to ADODB developers?
grangeway

grangeway

2008-07-15 15:32

reporter   ~0018557

Larry,

Mantis doesn't use StoredProcs - it uses bound query strings, Or am i missing your meaning of sp_Execute

Paul
LordLarry

LordLarry

2008-07-23 05:08

reporter   ~0018643

True. It's ADODB that uses sp_executesql to execute the query. In the end mantis does not work with the version of ADODB it supplies.
LordLarry

LordLarry

2008-07-24 06:38

reporter   ~0018659

Reported here: http://phplens.com/lens/lensforum/msgs.php?id=17541
LordLarry

LordLarry

2008-11-26 10:37

reporter   ~0020067

Received only the suggestion to use the MSSQL php driver
grangeway

grangeway

2012-02-05 14:25

reporter   ~0031142

Doing a bit of tidyup on the issue tracker atm - 1.3.x when it gets released should have better support for mssql, especially now that MS have done some work on php.
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040372

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