[Tickets #11743] Re: ActiveSync Horde5 php serialize on PostgreSQL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11743
------------------------------------------------------------------------------
  Ticket             | 11743
  Updated By         | horde at albasoft.com
  Summary            | ActiveSync Horde5 php serialize on PostgreSQL
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


horde at albasoft.com (2012-11-22 12:30) wrote:

I think it works, but I have to test more cases.

I have updates database schema through admin UI.
On pgsql now 'horde_activesync_state.sync_data' column has changed its  
type to 'bytea'.

Device log shows no error an proper coding:
---------------------------
2012-11-22T13:12:14+01:00 DEBUG: O     <FolderId/>
2012-11-22T13:12:14+01:00 DEBUG: O     <Status>
2012-11-22T13:12:14+01:00 DEBUG: O      1
2012-11-22T13:12:14+01:00 DEBUG: O     <Status/>
2012-11-22T13:12:14+01:00 DEBUG: [25426] Saving state: Array
(
     [0] => {50ab11b8-f2a8-4b28-88cc-182ec0a80102}61
     [1] => Horde_Db_Value_Binary Object
         (
             [_value:protected] =>  
O:34:"Horde_ActiveSync_Folder_Collection":3:{s:10:"*_status";a:0:{}s:12:"*_serverid";s:10:"@Contacts@";s:9:"*_class";s:8:"Contacts";}
         )

     [2] => androidcxxxxxxxxxx
     [3] => 1353586334
     [4] => @Contacts@
     [5] => user
     [6] => 0
)

2012-11-22T13:12:14+01:00 DEBUG: O    <Folder/>
2012-11-22T13:12:14+01:00 DEBUG: O   <Folders/>
2012-11-22T13:12:14+01:00 DEBUG: O  <Synchronize/>
---------------------------

And that log leads to this insert in pgsql sync_data field:

O:34:"Horde_ActiveSync_Folder_Collection":3:{s:10:"\000*\000_status";a:0:{}s:12:"\000*\000_serverid";s:10:"@Contacts@";s:9:"\000*\000_class";s:8:"Contacts";}

Thanks