From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Sep 6 12:00:09 2008 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 65AB51065676 for ; Sat, 6 Sep 2008 12:00:09 +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 4771C8FC1D for ; Sat, 6 Sep 2008 12:00:09 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m86C0971037372 for ; Sat, 6 Sep 2008 12:00:09 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m86C09aa037371; Sat, 6 Sep 2008 12:00:09 GMT (envelope-from gnats) Resent-Date: Sat, 6 Sep 2008 12:00:09 GMT Resent-Message-Id: <200809061200.m86C09aa037371@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, "O. Hartmann" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0F3F9106564A for ; Sat, 6 Sep 2008 11:55:21 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 03D978FC1B for ; Sat, 6 Sep 2008 11:55:21 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m86BtKnD052673 for ; Sat, 6 Sep 2008 11:55:20 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m86BtKr4052654; Sat, 6 Sep 2008 11:55:20 GMT (envelope-from nobody) Message-Id: <200809061155.m86BtKr4052654@www.freebsd.org> Date: Sat, 6 Sep 2008 11:55:20 GMT From: "O. Hartmann" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/127144: flyspray 0.9.9.2_1: FS#1402 - cache.topic datatype mis-match error in postgres 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: Sat, 06 Sep 2008 12:00:09 -0000 >Number: 127144 >Category: ports >Synopsis: flyspray 0.9.9.2_1: FS#1402 - cache.topic datatype mis-match error in postgres >Confidential: no >Severity: critical >Priority: high >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Sat Sep 06 12:00:08 UTC 2008 >Closed-Date: >Last-Modified: >Originator: O. Hartmann >Release: FreeBSD 7.1-PRE/i386 >Organization: FU Berlin >Environment: FreeBSD 7.1-PRE/i386 (last buildworld: 05.09.2008) flyspray-0.9.9.2_1 (Outdated, see notes at www.flyspray.org commiting bug reports prior to 0.9.9.5!!!) lighttpd-1.4.19_1 postgresql-server-8.3.3 Webbrowser: Firefox3, IE 7/IE 6 >Description: Connecting to a fresh installation (from the most recent updated ports) of flyspray results in this error: ===== Query {SELECT p.*, c.content AS pm_instructions, c.last_updated AS cache_update FROM "flyspray_projects" p LEFT JOIN "flyspray_cache" c ON c.topic = p.project_id AND c.type = 'msg' WHERE p.project_id = ?} with params {1} Failed! (ERROR: operator does not exist: character varying = integer LINE 3: ... LEFT JOIN "flyspray_cache" c ON c.topic = p.projec... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.) ===== Obviously ist this error well known, as this bug-report seems to show: http://bugs.flyspray.org/task/1402 FS#1402 - cache.topic datatype mis-match error in postgres The port is hopeless outdated, as this statement on the FlySpray site reveals: "... Do not issue bugs reports against versions earlier than 0.9.9.5" >How-To-Repeat: Use flyspray as taken from the recent ports (06.09.2008) and use backend postgresql 8.3. Then try to connect to the fresh installation for the very first time. >Fix: Fixes seems to exist in bug-fixed versions newer than the outdated version in the ports. See FS#1402 - cache.topic datatype mis-match error in postgres at www.flyspray.org bug reports. >Release-Note: >Audit-Trail: >Unformatted: