Date: Mon, 15 Sep 2008 17:49:17 -0400 From: Bill Moran <wmoran@potentialtech.com> To: "O. Hartmann" <ohartman@zedat.fu-berlin.de> Cc: freebsd-questions@freebsd.org Subject: Re: flyspray and php 5/postgresql weirdness, help ... Message-ID: <20080915174917.0a01255e.wmoran@potentialtech.com> In-Reply-To: <48C13CBA.4070407@zedat.fu-berlin.de> References: <48C13CBA.4070407@zedat.fu-berlin.de>
next in thread | previous in thread | raw e-mail | index | archive | help
In response to "O. Hartmann" <ohartman@zedat.fu-berlin.de>: > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080915174917.0a01255e.wmoran>