Date: Mon, 24 Sep 2012 12:52:41 GMT From: Oliver Hartmann <ohartman@zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org 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 Message-ID: <201209241252.q8OCqfd4051897@red.freebsd.org> Resent-Message-ID: <201209241300.q8OD0OH9093862@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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 ( ?, ?, ?, ?, ?, ?, ?).
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201209241252.q8OCqfd4051897>