Date: Sat, 6 Sep 2008 11:41:05 GMT From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org Subject: misc/127143: flyspray 0.9.9.2_1 BUG: ERROR: operator does not exist: character varying = integer LINE 3: Message-ID: <200809061141.m86Bf5f1043973@www.freebsd.org> Resent-Message-ID: <200809061150.m86Bo1Nw037108@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200809061141.m86Bf5f1043973>