Unable to add personal contact

[Anthony_Messina]

sing svn trunk@29866, I am unable to add personal contacts. I use LDAP for
accounts and contacts and PostgreSQL for my DB.

Database error

Invalid SQL: INSERT INTO egw_addressbook
(contact_tid,contact_owner,contact_private,cat_id,n_family,n_given,n_middle,n_prefix,n_suffix,n_fn,n_fileas,contact_bday,org_name,org_unit,contact_title,contact_role,contact_assistent,contact_room,adr_one_street,adr_one_street2,adr_one_locality,adr_one_region,adr_one_postalcode,adr_one_countryname,adr_two_street,adr_two_street2,adr_two_locality,adr_two_region,adr_two_postalcode,adr_two_countryname,tel_work,tel_cell,tel_fax,tel_assistent,tel_car,tel_pager,tel_home,tel_fax_home,tel_cell_private,tel_other,tel_prefer,contact_email,contact_email_home,contact_url,contact_url_home,contact_note,contact_tz,contact_pubkey,contact_created,contact_creator,contact_modified,contact_modifier,contact_uid,contact_id)
VALUES (‘n’,6,0,NULL,‘AAAA’,‘AAAA’,NULL,NULL,NULL,‘AAAA AAAA’,‘AAAA
AAAA’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,‘UNITED
STATES’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,‘0’,NULL,1271550399,6,1271550399,6,NULL,‘contact_etag=contact_etag+1’,0):
ERROR: syntax error at or near ","
LINE 1: …tor,contact_modified,contact_modifier,contact_uid,contact_i…
^

Click here to resume your eGroupWare Session.

This is a temporary fix until a real fix comes about:

diff --git a/addressbook/inc/class.addressbook_so.inc.php
b/addressbook/inc/class.addressbook_so.inc.php
index 4897b1b…9eb9434 100755
— a/addressbook/inc/class.addressbook_so.inc.php
+++ b/addressbook/inc/class.addressbook_so.inc.php
@@ -433,7 +433,7 @@ class addressbook_so
{
// delete customfields, can return 0 if there are no
customfields
if(!($this->somain instanceof addressbook_sql)) {

•                           $this->soextra->delete(array($this->extra_id 
  

=> $contact));
+// $this->soextra->delete(array($this->extra_id
=> $contact));
}

                    // delete from distribution list(s)

@@ -505,7 +505,7 @@ class addressbook_so

            // save customfields, if not already done by somain->save();
            if(!($this->somain instanceof addressbook_sql)) {

•                   $this->soextra->save($this->data2db($contact));
  

+// $this->soextra->save($this->data2db($contact));
}
return false; // no error
}

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E