ports/171917: databases/mantis: 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_g

[Oliver Hartmann]

>Number:         171917
>Category:       ports
>Synopsis:       databases/mantis: 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
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Sep 24 13:00:24 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     Oliver Hartmann
>Release:        FreeBSD 10.0-CURRENT/amd64 CLANG & FreeBSD 9.1-PRE/amd64 CLANG
>Organization:
FU Berlin
>Environment:
#1:
FreeBSD 10.0-CURRENT #12 r240857M: Sun Sep 23 15:33:47 CEST 2012 amd 64 CLANG built
postgresql-server-9.1.5 and postgresql-server-9.2.0

#2:
FreeBSD 9.1-PRERELEASE #0 r240772: Fri Sep 21 12:14:56 CEST 2012 amd64, CLANG built
postgresql-server-9.1.5 and postgresql-server-9.2.0
>Description:
Using MANTIS as present in the most recent ports collection on most recent CURRENT and PRE/STABLE FreeBSD 10 or 9 respectively with either PostgreSQL 9.1.5 or 9.2.0 servers, I receive messages and failures like shown below when trying to create/manage projects or subprojects.

Trying to create a subproject within an existing project ends up in:

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
( ?, ?, ?, ?, ?, ?, ?).


Trying to create a new project ends up in:

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
( ?, ?, ?, ?, ?, ?, ?).
>How-To-Repeat:
Install databases/mantis along with databases/postgresql9[1|2]-[server|client]. Follwo the installation/configure procedures.

When successfully logged in as the superuser of the Mantis bugtracking system, try to create your projects you'd like to maintain.
>Fix:
It is possible to manually insert a project with the command showed in the error. I guess the problem is in a type mismatch in a script and needs fix upstream. 

>Release-Note:
>Audit-Trail:
>Unformatted:
 _global ) VALUES ( ?, ?, ?, ?, ?, ?, ?).