From owner-freebsd-questions@FreeBSD.ORG Mon Sep 15 21:49:19 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 AD3B7106567B for ; Mon, 15 Sep 2008 21:49:19 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id 7DF328FC15 for ; Mon, 15 Sep 2008 21:49:19 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from vanquish.ws.pitbpa0.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTPSA id 44D9EEBC09; Mon, 15 Sep 2008 17:49:18 -0400 (EDT) Date: Mon, 15 Sep 2008 17:49:17 -0400 From: Bill Moran To: "O. Hartmann" Message-Id: <20080915174917.0a01255e.wmoran@potentialtech.com> In-Reply-To: <48C13CBA.4070407@zedat.fu-berlin.de> References: <48C13CBA.4070407@zedat.fu-berlin.de> X-Mailer: Sylpheed 2.5.0 (GTK+ 2.12.11; i386-portbld-freebsd7.0) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: 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: Mon, 15 Sep 2008 21:49:19 -0000 In response to "O. Hartmann" : > 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. The problem is that flyspray does not work on PG 8.3. Use an older version of Postgres (I know that 8.1 works, and I suspect that 8.2 does) or help the FS people fix their SQL. :) -- Bill Moran http://www.potentialtech.com