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>