[horde] horde+imp+postgres problem (bad sql command?)

Tomas Potok potok at kopernik.cc.fmph.uniba.sk
Wed May 7 10:29:12 PDT 2003


hello!

I recently installed horde 2.2.3 with IMP 3.2 and I am trying to set up a 
prefs-container with Postgres DB. When IMP tries to save some preference, I get 
such an error logged:

box HORDE[1823]: [imp] DB Error: unknown error: insert into horde_prefs 
(pref_uid, pref_scope, pref_name, pref_value) values('potok', 'imp', 'delhide', 
TRUE) [nativecode=ERROR:  column "pref_value" is of type text but expression is 
of type boolean ^IYou will need to rewrite or cast the expression ] [on line 341 
of "/var/www/html/horde/lib/Prefs/sql.php"]

It looks like postgres is not allowing horde to insert a record, because it 
regards TRUE as Boolean-type, but the field in postgres is defined as text-type.
Is this horde's or postgres' fault? 

Postgres 7.3.2, RedHat 9.0.

Any idea how to solve this? 

Thank you, 

Tomas

-- 
Also doing mathematics this way?
http://kopernik.cc.fmph.uniba.sk/~potok/jokes/math.jpg




More information about the horde mailing list