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

[Michael J Rubinsky]

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: 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)?

No.

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org