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

[Simon Brereton]

> -----Original Message-----
> From: horde-bounces at lists.horde.org [mailto:horde-
> bounces at lists.horde.org] On Behalf Of Rick Romero
> Quoting Simon Brereton <simon.brereton at buongiorno.com>:
> 
> >> -----Original Message-----
> >> From: horde-bounces at lists.horde.org [mailto:horde-
> >> bounces at lists.horde.org] On Behalf Of Rick Romero Quoting Simon
> >> Brereton <simon.brereton at buongiorno.com>:
> >>
> >> >> -----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 ERR: QUERY FAILED: Column
> >> > 'object_workemail' cannot be null
> >> >
> >> > INSERT INTO turba_objects (object_type, object_lastname,
> >>
> >> This looks like straight up SQL - is your new field marked as
> 'Null -
> >> Yes'  or 'Null - No'?
> >
> > Null - No.
> >
> > What's the difference?  When I added these fields there was no hint
> to
> > set these to null (or if there was, I missed it)..
> 
> That means it can't be NULL, which is where the problem is.   You
> have
> to set it to allow NULL Values.
> 
> ALTER table turba_objects Modify object_workemail varchar(50) null;

Thanks.  I just edited it in PHPMyAdmin.  I should be curious to know why it doesn't default to that, but I'm more concerned with the other issue - why it doesn't appear to allow me to introduce a contact number or email from the Android device, and how to speed up the sync between the device and the server.

Does anyone else (i.e. Michael) have an issue with entering contacts on the device)?  It's quite a show-stopper in terms of moving users away from SyncML.

Simon