From owner-freebsd-ports-bugs@FreeBSD.ORG Mon Sep 24 13:00:29 2012 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 6A6EE1065677 for ; Mon, 24 Sep 2012 13:00:29 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 132518FC1A for ; Mon, 24 Sep 2012 13:00:25 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q8OD0Omb093869 for ; Mon, 24 Sep 2012 13:00:24 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q8OD0OH9093862; Mon, 24 Sep 2012 13:00:24 GMT (envelope-from gnats) Resent-Date: Mon, 24 Sep 2012 13:00:24 GMT Resent-Message-Id: <201209241300.q8OD0OH9093862@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Oliver Hartmann Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 746331065670 for ; Mon, 24 Sep 2012 12:52:42 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22]) by mx1.freebsd.org (Postfix) with ESMTP id 253D88FC0A for ; Mon, 24 Sep 2012 12:52:42 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.5/8.14.5) with ESMTP id q8OCqffg051898 for ; Mon, 24 Sep 2012 12:52:41 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.5/8.14.5/Submit) id q8OCqfd4051897; Mon, 24 Sep 2012 12:52:41 GMT (envelope-from nobody) Message-Id: <201209241252.q8OCqfd4051897@red.freebsd.org> Date: Mon, 24 Sep 2012 12:52:41 GMT From: Oliver Hartmann To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: 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 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 Sep 2012 13:00:29 -0000 >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 ( ?, ?, ?, ?, ?, ?, ?).