From owner-freebsd-questions@FreeBSD.ORG Fri Sep 5 14:08:01 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 234731065671 for ; Fri, 5 Sep 2008 14:08:01 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) by mx1.freebsd.org (Postfix) with ESMTP id D4A3C8FC1E for ; Fri, 5 Sep 2008 14:08:00 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost1.zedat.fu-berlin.de (Exim 4.69) for freebsd-questions@freebsd.org with esmtp (envelope-from ) id <1Kbbyh-00066m-IL>; Fri, 05 Sep 2008 16:07:59 +0200 Received: from telesto.geoinf.fu-berlin.de ([130.133.86.198]) by inpost2.zedat.fu-berlin.de (Exim 4.69) for freebsd-questions@freebsd.org with esmtpsa (envelope-from ) id <1Kbbyh-0005Gt-HO>; Fri, 05 Sep 2008 16:07:59 +0200 Message-ID: <48C13CBA.4070407@zedat.fu-berlin.de> Date: Fri, 05 Sep 2008 14:05:46 +0000 From: "O. Hartmann" Organization: Freie =?ISO-8859-15?Q?Universit=E4t_Berlin?= User-Agent: Thunderbird 2.0.0.16 (X11/20080903) MIME-Version: 1.0 To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: 130.133.86.198 Subject: flyspray and php 5/postgresql weirdness, help ... X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 05 Sep 2008 14:08:01 -0000 hello, for development in our scientific environment I setup /usr/ports/devel/flyspray, running with a postgresql 8.3.3 backend on a FreeBSD 7.1-PRE box. After a successful installation, I get this error while trying to reach the freshly installed server via https://host/flyspray/: 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.) I do not know whether the shown problem is postgresql-syntactical or a php 5 problem, so I guess it's a kind of both. By the way, the webserver is Lighttpd and not Apache, so it may could be a fastcgi.server problem? I would appreciate any hint or tip, thanks a lot ... Oliver