0014427: Cannot create a project on a fresh install

ID	Project	Category	View Status	Date Submitted	Last Update
0014427	mantisbt	db postgresql	public	2012-06-27 06:15	2014-05-16 15:02

Reporter	Artefact2	Assigned To	atrol
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	1.2.11

Summary	0014427: Cannot create a project on a fresh install
Description	I went through the install without issues, then logged in with the administrator account to create a project. When I submit the project creation form, I get the following error: "Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "true" for the query: INSERT INTO mantis_project_table ( name, status, enabled, view_state, file_path, description, inherit_global ) VALUES ( ?, ?, ?, ?, ?, ?, ?)." I am using PostgreSQL 9.1.
Tags	No tags attached.

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