View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008675mantisbtdb postgresqlpublic2007-12-16 10:272014-05-16 15:02
Reportergregab Assigned Tograngeway  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionfixed 
Platformx86_64OSopenSUSE LinuxOS Version10.3
Product Version1.1.0rc3 
Fixed in Version1.2.0a2 
Summary0008675: Incorrect use of boolean in postgres 8.2.4
Description

During the installation phase, installer will halt at several mantis tables containing boolean columns with default values.

After installation process has been fixed (schema.php), login will always fail due to type mismatch in checking the value in "enabled" column. There is a whole array of related issues that would have arose during normal operation.

Steps To Reproduce

Attempt to install running PostgreSQL 8.2.4.

Additional Information

ADODB is completely out of touch with reality. It remaps postgres8 to postgres7, which is far from similar.

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
has duplicate 0008667 closedvboctor Unable to create table in PostgreSQL because the integer default on boolean column 
has duplicate 0008404 closedvboctor Error in create table with type boolean with default 0 
has duplicate 0007755 closedvboctor Install error on pgsql 
related to 0007616 closedgrangeway Can't create tables on postgresql 

Activities

mirek

mirek

2008-01-03 06:00

reporter   ~0016535

I also have this problem (Ubuntu 7.10, PostgreSQL 8.1).
albertogranja

albertogranja

2008-02-14 12:53

reporter   ~0017047

to solve a problem, replace the strings below in admin\schema.php

Replace L NOTNULL DEFAULT '0' to I NOTNULL DEFAULT 0

And

Replace L NOTNULL DEFAULT '1' to I NOTNULL DEFAULT 1

Its no better solution, but..
grangeway

grangeway

2008-05-03 19:12

reporter   ~0017752

Hello all,

I think most of the postgres issues have been resolved in the latest SVN trunk from http://mantisbt.svn.sourceforge.net/viewvc/mantisbt/trunk/mantisbt/

If one of you could test the latest SVN code to see if it improves the support for postgres, it would be appreciated.

Paul
grangeway

grangeway

2014-05-16 15:02

reporter   ~0040550

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