View Issue Details

IDProjectCategoryView StatusLast Update
0007755mantisbtdb postgresqlpublic2014-05-16 15:02
Reporterfranklinhaut Assigned Tovboctor  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionduplicate 
PlatformLinuxOSFedora 5 
Product Version1.1.0a2 
Summary0007755: Install error on pgsql
Description

on install a new database on postgresql 8.1 happens this error

BAD
CREATE TABLE mantis_bug_table ( id SERIAL, project_id INTEGER DEFAULT 0 NOT NULL, reporter_id INTEGER DEFAULT 0 NOT NULL, handler_id INTEGER DEFAULT 0 NOT NULL, duplicate_id INTEGER DEFAULT 0 NOT NULL, priority INT2 DEFAULT 30 NOT NULL, severity INT2 DEFAULT 50 NOT NULL, reproducibility INT2 DEFAULT 10 NOT NULL, status INT2 DEFAULT 10 NOT NULL, resolution INT2 DEFAULT 10 NOT NULL, projection INT2 DEFAULT 10 NOT NULL, category VARCHAR(64) DEFAULT '' NOT NULL, date_submitted TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, last_updated TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, eta INT2 DEFAULT 10 NOT NULL, bug_text_id INTEGER DEFAULT 0 NOT NULL, os VARCHAR(32) DEFAULT '' NOT NULL, os_build VARCHAR(32) DEFAULT '' NOT NULL, platform VARCHAR(32) DEFAULT '' NOT NULL, version VARCHAR(64) DEFAULT '' NOT NULL, fixed_in_version VARCHAR(64) DEFAULT '' NOT NULL, build VARCHAR(32) DEFAULT '' NOT NULL, profile_id INTEGER DEFAULT 0 NOT NULL, view_state INT2 DEFAULT 10 NOT NULL, summary VARCHAR(128) DEFAULT '' NOT NULL, sponsorship_total INTEGER DEFAULT 0 NOT NULL, sticky BOOLEAN DEFAULT 0 NOT NULL, PRIMARY KEY (id) )
ERROR: column "sticky" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression.

TagsNo tags attached.

Relationships

duplicate of 0008675 closedgrangeway Incorrect use of boolean in postgres 8.2.4 

Activities

franklinhaut

franklinhaut

2007-02-07 13:24

reporter   ~0014009

on admin/schema.php line 95

change
sticky L NOTNULL DEFAULT '0'
the to
sticky L NOTNULL DEFAULT false

works to postgresql

franklinhaut

franklinhaut

2007-02-07 13:48

reporter   ~0014010

many others lines have some problem

i think that is an error on manipulate boolean fields on pgsql

franklinhaut

franklinhaut

2007-09-26 17:11

reporter   ~0015728

Last edited: 2007-10-05 12:09

other related bug 0008404 and 0007616

grangeway

grangeway

2014-05-16 15:02

reporter   ~0040556

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