ports/127144: flyspray 0.9.9.2_1: FS#1402 - cache.topic datatype mis-match error in postgres

[O. Hartmann]

>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: