misc/127143: flyspray 0.9.9.2_1 BUG: ERROR: operator does not exist: character varying = integer LINE 3:

[O. Hartmann]

>Number:         127143
>Category:       misc
>Synopsis:       flyspray 0.9.9.2_1 BUG:  ERROR: operator does not exist: character varying = integer LINE 3:
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sat Sep 06 11:50:01 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     O. Hartmann
>Release:        
>Organization:
FU Berlin
>Environment:
FreeBSD 7.1-PRE/i386
PostgreSQL 8.3.3
PHP 5.2.6
FlySpray 0.9.9.2_1
Lighttpd 1.4.19_1
>Description:
Trying to connect to a freshly setup flyspray service on a server results in this query-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.)

This seems similar to this bug:

http://bugs.flyspray.org/task/1419
>How-To-Repeat:

>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: