From owner-freebsd-bugs@FreeBSD.ORG Sat Sep 6 11:50:02 2008 Return-Path: Delivered-To: freebsd-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 3CB7B106567E for ; Sat, 6 Sep 2008 11:50:02 +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 1F0E78FC25 for ; Sat, 6 Sep 2008 11:50:02 +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 m86Bo1NC037109 for ; Sat, 6 Sep 2008 11:50:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m86Bo1Nw037108; Sat, 6 Sep 2008 11:50:01 GMT (envelope-from gnats) Resent-Date: Sat, 6 Sep 2008 11:50:01 GMT Resent-Message-Id: <200809061150.m86Bo1Nw037108@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-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 E10BF1065676 for ; Sat, 6 Sep 2008 11:41:05 +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 D53D68FC1E for ; Sat, 6 Sep 2008 11:41:05 +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 m86Bf56n043984 for ; Sat, 6 Sep 2008 11:41:05 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m86Bf5f1043973; Sat, 6 Sep 2008 11:41:05 GMT (envelope-from nobody) Message-Id: <200809061141.m86Bf5f1043973@www.freebsd.org> Date: Sat, 6 Sep 2008 11:41:05 GMT From: "O. Hartmann" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: misc/127143: flyspray 0.9.9.2_1 BUG: ERROR: operator does not exist: character varying = integer LINE 3: X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 06 Sep 2008 11:50:02 -0000 >Number: 127143 >Category: misc >Synopsis: flyspray 0.9.9.2_1 BUG: ERROR: operator does not exist: character varying = integer LINE 3: >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Sat Sep 06 11:50:01 UTC 2008 >Closed-Date: >Last-Modified: >Originator: O. Hartmann >Release: >Organization: FU Berlin >Environment: FreeBSD 7.1-PRE/i386 PostgreSQL 8.3.3 PHP 5.2.6 FlySpray 0.9.9.2_1 Lighttpd 1.4.19_1 >Description: Trying to connect to a freshly setup flyspray service on a server results in this query-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.) This seems similar to this bug: http://bugs.flyspray.org/task/1419 >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted: