postgresql problmes with IMP

Jeremy jeremy@electrosilk.net
Fri, 5 Jan 2001 17:04:11 +0800


Hi,

I am trying a new install of IMP and horde using postgresql.  I have had a
number of problems that should go in the FAQ perhaps.  More on them later.

My present problem is :

My system is RedHat 6.2, apache 1.3.14-2.6.2
Postgres 6.5.3.6
horde-1.2.3
imp-2.2.3
php-3.0.17-1.6.2horde1 (etc - all from the horde download site)

I have installed and configured to the best of my ability :-( and got horde
sort of working with the memory store.  With postgresql I have turned on a
debug flag on the horde scripts and got the errors displayed on my IE 5.5
screen when I start up IMP

>>>>>>>>>>>

Debug: query = SELECT val FROM active_sessions WHERE sid =
'1_137a35e38aa158291e57aef3d2d098ce' AND name = 'HordeSession'

Debug: query = update active_sessions set
val='base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7IA==',
changed='20010105163430' where sid='1_137a35e38aa158291e57aef3d2d098ce' and
name='HordeSession'

Debug: query = insert into active_sessions ( sid, name, val, changed )
values ('1_137a35e38aa158291e57aef3d2d098ce', 'HordeSession',
'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7IA==',
'20010105163430')

Warning: PostgresSQL query failed: ERROR: Cannot insert a duplicate key into
a unique index in /usr/local/phplib/db_pgsql.inc on line 52

Warning: Cannot add more header information - the header was already sent
(header information may be added only before any output is generated from
the script - check for text or whitespace outside PHP tags, or calls to
functions that output text) in /home/httpd/html/horde/imp/mailbox.php3 on
line 111

>>>>>>>>>>>>>>>>>>>>>

This seems like a problem in the horde program logic.  Any suggestions ?

Jeremy