Bug 239375 – www-apps/mantisbt-1.1.x: - postgresql support in mantisdb is broken.

• Product: Gentoo Linux
• Status: RESOLVED UPSTREAM

[Description Alexey 2008-10-02 21:36:36 UTC]

I'm using latest postgresql-server and mantisbt-1.1.2-r1, but when I install it, I get next 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.

I found this error on mantice site http://www.mantisbt.org/bugs/view.php?id=7755

Reproducible: Always

[Comment 1 Peter Volkov (RETIRED) 2008-10-04 17:18:21 UTC]

Alexey, regretfully current current stable branch (1.1.X) is broken with postgresql. This is not the only problem with mantisbt and postgresql but it's possible that most (all?) problems are already fixed in svn. Backporting of the patches is non trivial task I've tried to do but failed as too many intrusive changes were required.

Resume: Use mantisbt with mysql database. If you really need to run it with postgresql download svn sources from:
https://sourceforge.net/svn/?group_id=14963

So resolving this bug as UPSTREAM...

[Comment 2 Peter Volkov (RETIRED) 2008-10-04 17:26:40 UTC]

And as a final accord to this bug I've added notice to ebuild about this problem:
http://sources.gentoo.org/viewcvs.py/gentoo-x86/www-apps/mantisbt/mantisbt-1.1.2-r1.ebuild?r1=1.3&r2=1.4

And although we fixed nothing, thank you for report Alexey.