Author Topic: Ebox-Egroupware AddressBook  (Read 1224 times)

-seng-

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Ebox-Egroupware AddressBook
« on: May 18, 2010, 08:21:50 am »
Hi,

I am new to ebox. I'd install ebox 1.4.2 on Ubuntu 8.04 recently. Everything works fine but I got error when I import old Egroupware addressbook to this new Ebox-Egroupware.

My old egroupware version 1.4.004.

Error Message: Database error

Invalid SQL: INSERT INTO egw_addressbook (contact_owner,contact_private,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_two_region,adr_two_postalcode,contact_modified,contact_modifier,,contact_id) VALUES (2009,0,NULL,'Mr Khay Hock Ang','Mizuho Corporate Bank,LTD. Kuala Lumpur Representative Office: Ang, Khay Hock',NULL,'Mizuho Corporate Bank,LTD. Kuala Lumpur Representative Office',NULL,'Admin',NULL,NULL,NULL,'Level 34, Menara Maxis, ','Kuala Lumpur City Centre,',NULL,NULL,NULL,1274162871,2009,'contact_etag=contact_etag+1',2):
ERROR:  syntax error at or near ","
LINE 1: ..._two_postalcode,contact_modified,contact_modifier,,contact_i...

Thanks.

Seng

dzingis

  • Zen Monk
  • **
  • Posts: 66
  • Karma: +0/-0
    • View Profile
Re: Ebox-Egroupware AddressBook
« Reply #1 on: May 18, 2010, 11:33:01 am »

This is rather EGW question that Ebox, definitely INSERT INTO command is mistyped, with two commas at the end


contact_modified,contact_modifier,,contact_id)

I think that you should try EGW forums, help would come faster from there ...

« Last Edit: May 18, 2010, 11:41:58 am by dzingis »