0006888: Changelog doesn't work on MS SQL

ID	Project	Category	View Status	Date Submitted	Last Update
0006888	mantisbt	db mssql	public	2006-03-27 03:38	2014-05-16 15:00

Reporter	vboctor	Assigned To	vboctor
Priority	high	Severity	crash	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.0.1
Fixed in Version	1.1.0a1

Summary	0006888: Changelog doesn't work on MS SQL
Description	The following line in changelog_page.php doesn't work on MS SQL $t_issue_id = $t_result->fields['id']; The problem is that the fields array has the fields by index only, not by column names (i.e. it is not an associative array). The quick fix is to change it to: $t_issue_id = $t_result->fields[0]; However, not returning associative array will probably cause bugs in several areas and hence the cause of the problem should be found and fixed.
Tags	No tags attached.

vboctor 2006-04-20 10:30 manager ~0012649	changelog_page.php -> new revision: 1.18

grangeway 2014-05-16 15:00 reporter ~0040420	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