0008868: Warning when sorting users/updating a bug

ID	Project	Category	View Status	Date Submitted	Last Update
0008868	mantisbt	db mssql	public	2008-02-08 11:06	2014-05-16 15:00

Reporter	jeckyll	Assigned To	dhx
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	duplicate
Platform	IIS 6.0 (PHP 5.2.5)	OS	Windows Server 2003	OS Version	SR02
Product Version	1.1.1

Summary	0008868: Warning when sorting users/updating a bug
Description	When one's tries to sort Users list in «Users Management», Mantis display a warning message « Warning: in_array(): Wrong datatype for second argument » The same problem occurs when updating a bug. My Mantis works with SQL Server 2005 database.
Steps To Reproduce	Go to user's management page and try to sort users list (e.g. by real name)
Additional Information	It seems that the function db_field_names (core\database_api.php) always return false (witch causes a warning in function in_array in manage_user_page.php l.45)
Tags	No tags attached.

dhx 2010-01-16 23:07 reporter ~0024174	Fixed in 0010818

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