[Tickets #513] NEW: PostgreSQL "Hide Deleted"

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=513
-----------------------------------------------------------------------
 Ticket     | 513
 Created By | pascal at quies.net
 Summary    | PostgreSQL "Hide Deleted"
 Queue      | IMP
 Version    | RELENG_3
 State      | Unconfirmed
 Priority   | 1. Low
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


pascal at quies.net (2004-08-29 06:19) wrote:

After a click on "Hide Deleted" the website reports:
A fatal error has occurred:
DB Error: unknown error
[line 341 of /usr/share/horde2/lib/Prefs/sql.php]
Details have been logged for the administrator.

/var/log/horde2/horde.log lists:
[emergency] [imp] DB Error: unknown error: insert into horde_prefs
(pref_uid, pref_scope, pref_name, pref_value) values('pascal', 'imp',
'delhide', TRUE) [nativecode=ERROR: column "pref_value" is of type 'text'
but expression is of type 'boolean'
    You will need to rewrite or cast the expression
] [on line 341 of "/usr/share/horde2/lib/Prefs/sql.php"]

I use PostgreSQL version 7.2