[horde] Group members

[Tom Plancon]

>
> Hello all,
> >
> > I've installed Horde-webmail-1.1.1 on a CentOS 5.1 system using  
> > Postgresql as the database back end. I'm able to create groups but  
> > when I attempt to add group members I see a "DB Error: no such  
> > field" in the interface. When checking the horde log I see these 2  
> > entries around the time I've attempted to add group members:
> > "Jul 02 15:31:36 HORDE [error] [horde] DB Error: no such field:  
> > SELECT lock_id, lock_owner, lock_scope, lock_principal,  
> > lock_origin_timestamp, lock_update_timestamp, lock_expiry_timestamp,  
> > lock_type FROM horde_locks WHERE lock_expiry_timestamp >= 1215027096  
> > AND lock_principal = '/kronolith/tplancon/tplancon.ics' AND  
> > lock_scope = 'webdav' [nativecode=ERROR:  column "lock_owner" does  
> > not exist]
>   
>
> This error is just what it says, your horde_locks table is missing the  
> lock_owner field. This was fixed some time ago according to CVS  
> history, but perhaps you created this table before the fix was  
> implemented in the creation script. You'll need to either add the  
> missing field or recreate the entire table.
>   
OK, I re-created the "horde-locks" table and now it appears to have all 
required fields. Unfortunately, it does not appear to solve the 
group-member problem. I tried adding group members and still got the "DB 
Error: no such field" notice in the interface. I did not see any error 
horde.log, logging level set to PEAR_LOG_NOTICE. I checked the 
postgresql log, pg_log and saw "ERROR column '1' does not exist".

Any idea what that means? Thanks.
-- 
Thomas E. Plancon
CAD/IS Manager

B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302

tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com <http://www.bkaarchs.com/>