Zentyal Forum, Linux Small Business Server

Zentyal Server => Installation and Upgrades => Topic started by: -seng- on May 18, 2010, 08:21:50 am

Title: Ebox-Egroupware AddressBook
Post by: -seng- 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
Title: Re: Ebox-Egroupware AddressBook
Post by: dzingis 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 ...