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

[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;

assuming it's varchar(50)

Rick