[horde] Activesync on-device editing and synching periods..

[Simon Brereton]

> -----Original Message-----
> From: Simon Brereton [mailto:simon.brereton at buongiorno.com]
> 
> Hi
> 
> I realise this isn't probably an Activesync issue (unless I set
> something up wrong), but I cannot edit contacts details (number,
> email, IM, DoB, etc.) on my Android device.  (I can add a contact
> name, but not a number, email, IM, DoB, etc).
> 
> Is this an Activesync limitation or a user related issue?
> 
> Adding a calendar entry or contact on the server isn't an issue - and
> it replicates almost immediately.  Calendar changes or additions on
> the device do eventually make it onto the server, but the time for
> this to happen seems in excess of 45 minutes.  But address book
> changes/additions never show-up.

I might have discovered why this is - although it underlines my original query.  From the sync.log:

2011-10-11T18:03:57+01:00 INFO: Horde_ActiveSync_Driver_Horde::logon attempt for:  simon at mydomain.net
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] SYNC request received for user  simon at mydomain.net
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] loadDeviceInfo:  simon at mydomain.net
2011-10-11T18:03:57+01:00 INFO: Request being handled for device: androidc1387223434 Supporting protocol version: 2.5
2011-10-11T18:03:57+01:00 INFO: [androidc1387223434] Handling SYNC command.
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] Checking policykey for device  Key: 0 User:  simon at mydomain.net
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] loadDeviceInfo:  simon at mydomain.net
2011-10-11T18:03:57+01:00 DEBUG: Policykey:  verified.
2011-10-11T18:03:57+01:00 DEBUG: I  <Synchronize>
2011-10-11T18:03:57+01:00 DEBUG: I   <Folders>
2011-10-11T18:03:57+01:00 DEBUG: I    <Folder>
2011-10-11T18:03:57+01:00 DEBUG: I     <FolderType>
2011-10-11T18:03:57+01:00 DEBUG: I      Contacts
2011-10-11T18:03:57+01:00 INFO: [androidc1387223434] Syncing folder class: Contacts
2011-10-11T18:03:57+01:00 DEBUG: I     </FolderType>
2011-10-11T18:03:57+01:00 DEBUG: I     <SyncKey>
2011-10-11T18:03:57+01:00 DEBUG: I      {4e8a2ac3-bc08-4eb2-bca9-3f3753aa4b6d}32
2011-10-11T18:03:57+01:00 DEBUG: I     </SyncKey>
2011-10-11T18:03:57+01:00 DEBUG: I     <FolderId>
2011-10-11T18:03:57+01:00 DEBUG: I      Contacts
2011-10-11T18:03:57+01:00 INFO: [androidc1387223434] Folder server id: Contacts
2011-10-11T18:03:57+01:00 DEBUG: I     </FolderId>
2011-10-11T18:03:57+01:00 DEBUG: I     <DeletesAsMoves/>
2011-10-11T18:03:57+01:00 DEBUG: I     <GetChanges/>
2011-10-11T18:03:57+01:00 DEBUG: I     <WindowSize>
2011-10-11T18:03:57+01:00 DEBUG: I      4
2011-10-11T18:03:57+01:00 DEBUG: I     </WindowSize>
2011-10-11T18:03:57+01:00 DEBUG: I     <Options>
2011-10-11T18:03:57+01:00 DEBUG: I      <Truncation>
2011-10-11T18:03:57+01:00 DEBUG: I       7
2011-10-11T18:03:57+01:00 DEBUG: I      </Truncation>
2011-10-11T18:03:57+01:00 DEBUG: I     </Options>
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] Loading state for synckey {4e8a2ac3-bc08-4eb2-bca9-3f3753aa4b6d}32
2011-10-11T18:03:57+01:00 DEBUG: I     <Commands>
2011-10-11T18:03:57+01:00 DEBUG: I      <Add>
2011-10-11T18:03:57+01:00 DEBUG: I       <ClientEntryId>
2011-10-11T18:03:57+01:00 DEBUG: I        new_48_1318352650860
2011-10-11T18:03:57+01:00 DEBUG: I       </ClientEntryId>
2011-10-11T18:03:57+01:00 DEBUG: I       <Data>
2011-10-11T18:03:57+01:00 DEBUG: I        <POOMCONTACTS:LastName>
2011-10-11T18:03:57+01:00 DEBUG: I         Aardvark
2011-10-11T18:03:57+01:00 DEBUG: I        </POOMCONTACTS:LastName>
2011-10-11T18:03:57+01:00 DEBUG: I        <POOMCONTACTS:FirstName>
2011-10-11T18:03:57+01:00 DEBUG: I         Aal
2011-10-11T18:03:57+01:00 DEBUG: I        </POOMCONTACTS:FirstName>
2011-10-11T18:03:57+01:00 DEBUG: I        <POOMCONTACTS:FileAs>
2011-10-11T18:03:57+01:00 DEBUG: I         Aal Aardvark
2011-10-11T18:03:57+01:00 DEBUG: I        </POOMCONTACTS:FileAs>
2011-10-11T18:03:57+01:00 DEBUG: I       </Data>
2011-10-11T18:03:57+01:00 DEBUG: Horde::changeMessage(Contacts, )
2011-10-11T18:03:57+01:00 ERR: QUERY FAILED: Column 'object_workemail' cannot be null

INSERT INTO turba_objects (object_type, object_lastname, object_firstname, object_middlenames, object_nameprefix, object_namesuffix, object_homestreet, object_homecity, object_homeprovince, object_homepostalcode, object_workstreet, object_workcity, object_workprovince, object_workpostalcode, object_title, object_company, object_department, object_spouse, object_notes, object_url, object_imaddress, object_imaddress2, object_imaddress3, object_homephone, object_workphone, object_fax, object_homefax, object_pager, object_cellphone, object_assistantphone, object_photo, object_email, object_workemail, object_category, object_bday, object_anniversary, object_homecountry, object_workcountry, owner_id, object_uid, object_id) VALUES ('Object', 'Aardvark', 'Aal', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 'simon at mydomain.net', '20111011180357.CdpYH1yZnp9OlHb9L_1zkrA at webmail.mydomain.net', 'umVoDFyZnp9OlHb9L-yDkrA')
2011-10-11T18:03:57+01:00 DEBUG: I      </Add>
2011-10-11T18:03:57+01:00 DEBUG: I     </Commands>
2011-10-11T18:03:57+01:00 DEBUG: [androidc1387223434] Processed 1 incoming changes
2011-10-11T18:03:57+01:00 DEBUG: I    </Folder>
2011-10-11T18:03:57+01:00 DEBUG: I   </Folders>
2011-10-11T18:03:57+01:00 DEBUG: I  </Synchronize>

I don't understand why the (added by me) custom field object_workemail should be mandatory - it isn't if I add a contact on the server..

And as I said, they way it's working for me at the moment is that I can't add contact info to contacts on the device - so they will always fail...