[imp] ERROR: column "pref_value" is of type text but expression is of type boolean

[Jan Schneider]

Zitat von Peter Ahearn <pahearn at teratron.com>:

> I've searched both the internet and the mailing lists extensively and
> haven't found an answer to the problem I'm having so I thought I'd see if
> anyone has any insight. I did find the same question posted a while ago but
> with no responses. Anyway here's what's happening:
>
> I'm running Horde 2.2.4 and Imp 3.2.2 on a Redhat 7.0 box, php-pgsql
> 4.2.2-8.0.5, postgresql 7.4-0.2PGDG. Everything works great when I don't try
> to enable user preferences, but when I do upon login I get the error
> message:
>
> A fatal error has occurred:
> DB Error: unknown error
> [line 341 of /var/www/html/horde/lib/Prefs/sql.php]
> Details have been logged for the administrator.
>
> ...the output of the postgres log is:
>
> ERROR:  column "pref_value" is of type text but expression is of type
> boolean
> HINT:  You will need to rewrite or cast the expression.

This (HINT) is exactly what we do (on the PHP level) since Horde 2.2.4.
Either you don't have this version or you have a PEAR DB version that is
broken.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - Neue Wege des Lernens
http://www.tip4all.de - Deine private Tippgemeinschaft