0008404: Error in create table with type boolean with default 0 - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update
0008404	mantisbt	db postgresql	public	2007-09-26 08:31	2014-05-16 15:02

Reporter	ssanti	Assigned To	vboctor
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	duplicate
OS	Windows	OS Version	W2KSP4
Product Version	1.1.0a4

Summary	0008404: Error in create table with type boolean with default 0
Description	In the installation process, when creating tables all sentences that has a bool with default 0 cause an error. For example: sticky boolean default 0 not null. The correct sentence is sticky boolean default `0` not null. How can I solve this?
Steps To Reproduce	Simple install mantis 1.1.0a4 in a postgresql 8.1.9 database.
Tags	No tags attached.

franklinhaut 2007-09-26 17:12 reporter ~0015729	related with case 0007755

ssanti 2007-09-26 17:54 reporter ~0015732	... and change '1' for true in schema.php too. I need too change all boolean '0' and '1' in insert commands in the same file.

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