Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 05 Sep 2008 14:05:46 +0000
From:      "O. Hartmann" <ohartman@zedat.fu-berlin.de>
To:        freebsd-questions@freebsd.org
Subject:   flyspray and php 5/postgresql weirdness, help ...
Message-ID:  <48C13CBA.4070407@zedat.fu-berlin.de>

next in thread | raw e-mail | index | archive | help
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





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48C13CBA.4070407>