[sync] BlackBerry and Two-Way Sync [solved]

[Patrick Lahni]

Quoting Patrick Lahni <list at cykotix.com>:

> Quoting Jan Schneider <jan at horde.org>:
>
>> Zitat von Patrick Lahni <list at cykotix.com>:
>>
>>> Quoting Jan Schneider <jan at horde.org>:
>>>
>>>> Zitat von Patrick Lahni <list at cykotix.com>:
>>>>
>>>>> Quoting Jan Schneider <jan at horde.org>:
>>>>>
>>>>>>> Well, there have been changes, Turba just isn't reporting that.  I
>>>>>> Then something is badly broken. You should get a "Created"  
>>>>>> and/or  a   "Last >Modified" field in the last tab. If you  
>>>>>> don't, then  the  history  doesn't work, >which would also  
>>>>>> explain why you  don't get  any contacts  synchronized.
>>>>>
>>>>> I agree with this.  Attached is an image of the last tab of a    
>>>>> particular user (who's name has been blacked out).  It is the    
>>>>> "Other" tab which is what I believe you are referring to when  
>>>>> you   say last tab.  This is a repost of a message I sent  
>>>>> earlier with  an  attachment waiting for moderator approval to  
>>>>> go through.  Here  is  photobucket link to it:     
>>>>> http://i652.photobucket.com/albums/uu243/lahnipm/turba-other-tab.jpg
>>>>>
>>>>>>> can't seem to find any such timestamp in Turba or Kronolith of  
>>>>>>>   time  of last >>update.  I'm also running the latest  
>>>>>>> versions:   Horde  (3.3.4), Turba (H3 >>2.3.1), Kronolith (H3  
>>>>>>> 2.3.1).  Also,   not sure if  it matters or is linked to  
>>>>>>> >>anything relevant  here  but in  horde_syncml_map, the  
>>>>>>> syncml_timestamp field >>for  every  entry is 0.
>>>>>>
>>>>>> As long as the timestamps in horde_syncml_anchors aren't empty,  
>>>>>>   that's  not a >problem.
>>>>>> They are not empty, just all 0.
>>>>>>
>>>>>>> Any other suggestions on where to look to verify these    
>>>>>>> applications  are >>updating their timestamps correctly and if  
>>>>>>>   they aren't, how to  fix this?
>>>>>>
>>>>>> Did you create your own address book, or is this the default    
>>>>>> localsql source?
>>>>>
>>>>> Just the default localsql source that is created automatically  
>>>>> for   each individual user with an account.
>>>>
>>>> I'm out of ideas then. Any contact that is created/updated  
>>>> through   Turba should get the history entries in horde_history.
>>>
>>> Well, you never mentioned horde_history, but I just looked in  
>>> there  and I can only assume history_ts is the timestamp column  
>>> you're  interested in.  This is populated with a timestamp in each  
>>> collumn.   history_action shows "add", "modify", "delete".
>>>
>>> However, in Turba or Kronolith themselves, there is no field that   
>>> shows the Created/Modified date that is converted from the   
>>> timestamp.  I assume in that screenshot I linked/posted that is  
>>> the  area where you would expect to see it?
>>
>> Yes, exactly.
>
> So to add more information to the mix, I dumped my horde database.   
> Did a complete reinstall.  Reconfigured all my apps in the event  
> something wasn't updated properly.  With a fresh set of files and a  
> fresh db, I logged in.  I created a new contact and the Created  
> field appeared!  Awesome, I think it's fixed!  Not quite.
>
> I restored my database (just data insert into the sql schema  
> provided within the new tar.gz's I downloaded eaerlier), logged back  
> in.  Now the Created field is gone?!  It has to be some sort of  
> setting.
>
> To go a bit further, I created a new user, logged in, and created a  
> new contact.  The Created field is there as it should be.
>
> Log back out to mine, Created field isn't there.  Does that help at  
> all where I can begin searching a bit better?  Should I just nuke my  
> history and start over?
>
> Patrick

I appear to have fixed it!  I went back through and stripped any  
non-essential data from horde_cache, horde_histories,  
horde_histories_seq, horde_sessionhandler, horde_syncml_anchors,  
horde_syncml_map, horde_tokens, horde_vfs, horde_vfs_seq.  Low and  
behold it seems to be working.  New contacts get the Created field.   
Existing contacts though do not have the Created field.  However, once  
I go through and resave them, they get the Last Modified field.

Weird, eh?

Patrick

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.