Date: Sat, 6 Sep 2008 11:55:20 GMT From: "O. Hartmann" <ohartman@mail.zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/127144: flyspray 0.9.9.2_1: FS#1402 - cache.topic datatype mis-match error in postgres Message-ID: <200809061155.m86BtKr4052654@www.freebsd.org> Resent-Message-ID: <200809061200.m86C09aa037371@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 127144
>Category: ports
>Synopsis: flyspray 0.9.9.2_1: FS#1402 - cache.topic datatype mis-match error in postgres
>Confidential: no
>Severity: critical
>Priority: high
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Sat Sep 06 12:00:08 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator: O. Hartmann
>Release: FreeBSD 7.1-PRE/i386
>Organization:
FU Berlin
>Environment:
FreeBSD 7.1-PRE/i386 (last buildworld: 05.09.2008)
flyspray-0.9.9.2_1 (Outdated, see notes at www.flyspray.org commiting bug reports prior to 0.9.9.5!!!)
lighttpd-1.4.19_1
postgresql-server-8.3.3
Webbrowser: Firefox3, IE 7/IE 6
>Description:
Connecting to a fresh installation (from the most recent updated ports) of flyspray results in this error:
=====
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.)
=====
Obviously ist this error well known, as this bug-report seems to show:
http://bugs.flyspray.org/task/1402
FS#1402 - cache.topic datatype mis-match error in postgres
The port is hopeless outdated, as this statement on the FlySpray site reveals:
"... Do not issue bugs reports against versions earlier than 0.9.9.5"
>How-To-Repeat:
Use flyspray as taken from the recent ports (06.09.2008) and use backend postgresql 8.3. Then try to connect to the fresh installation for the very first time.
>Fix:
Fixes seems to exist in bug-fixed versions newer than the outdated version in the ports. See
FS#1402 - cache.topic datatype mis-match error in postgres
at www.flyspray.org bug reports.
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200809061155.m86BtKr4052654>