[sync] ActiveSync error after 5.2 upgrade
Michael J Rubinsky
mrubinsk at horde.org
Wed Jul 16 15:49:44 UTC 2014
Quoting Ivan Kouvykov <ivan at kouvykov.com>
>
>
> On 2014-07-16 17:54, Arjen de Korte wrote:
>
>> Citeren Ivan Kouvykov <ivan at kouvykov.com>:
>>
>>> Hello, After upgrade to 5.2 all devices stopped syncing via
>>> ActiveSync, wit the follwing error: 2014-07-16T16:09:01+04:00 ERR:
>>> HORDE SQL QUERY FAILED: SQLSTATE[42S22]: Column not found: 1054
>>> Unknown column 'sync_changed' in 'field list' SELECT message_uid,
>>> sync_read, sync_flagged, sync_deleted,sync_changed FROM
>>> horde_activesync_mailmap WHERE sync_folderid = 'INBOX' AND
>>> sync_devid = 'SEC1EAAE5574652F' AND sync_user = 'mikhail' AND
>>> message_uid IN
>>> (526,527,528,529,530,531,525,486,487,488,489,490,491) [pid 28746
>>> on line 204 of
>>> "/volume1/@appstore/horde/share/pear/php/Horde/Db/Adapter/Pdo/Base.php"]
>>> 2014-07-16T16:09:01+04:00 ERR: HORDE Returning HTTP 500 while
>>> handling Sync command. [pid 28746 on line 159 of
>>> "/volume1/web/horde/rpc.php"] 2014-07-16T16:09:01+04:00 ERR: HORDE
>>> Error in communicating with ActiveSync server: SQLSTATE[42S22]:
>>> Column not found: 1054 Unknown column 'sync_changed' in 'field
>>> list' [pid 28746 on line 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> 2014-07-16T16:09:01+04:00 ERR: HORDE #0
> /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/State/Base.php(456): Horde_ActiveSync_State_Sql->_getMailMapChanges(Array) #1 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Collections.php(1223): Horde_ActiveSync_State_Base->getChanges(Array) #2 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Collections.php(1259): Horde_ActiveSync_Collections->getCollectionChanges(false) #3 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Request/Sync.php(400): Horde_ActiveSync_Collections->getCollectionChangeCount() #4 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Request/Base.php(253): Horde_ActiveSync_Request_Sync->_handle() #5 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync.php(880): Horde_ActiveSync_Request_Base->handle() #6 /volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php(143):
> Horde_ActiveSync->handleRequest('Sync',
> 'SEC1EAAE5574652...') #7 /volume1/web/horde/rpc.php(159):
> Horde_Rpc_ActiveSync->getResponse(NULL) #8 {main} [pid 28746 on line
> 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> 2014-07-16T16:09:01+04:00 ERR: HORDE Buffer contents: jEN1 [pid
> 28746 on line 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> 2014-07-16T16:09:02+04:00 ERR: HORDE SQL QUERY FAILED:
> SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'sync_changed' in 'field list' SELECT message_uid, sync_read,
> sync_flagged, sync_deleted,sync_changed FROM
> horde_activesync_mailmap WHERE sync_folderid = 'INBOX' AND
> sync_devid = 'E254E6E555E36ABE04BBDCCB20C2B62D' AND sync_user =
> 'ivan' AND message_uid IN
> (2394,2395,2396,2397,2398,2399,2400,2393,2260,2386,2387,2388,2389)
> [pid 25447 on line 204 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2014-07-16T16:09:02+04:00 ERR: HORDE Returning HTTP 500 while
> handling Sync command. [pid 25447 on line 159 of
> "/volume1/web/horde/rpc.php"] 2014-07-16T16:09:02+04:00 ERR: HORDE
> Error in communicating with ActiveSync server: SQLSTATE[42S22]:
> Column not found: 1054 Unknown column 'sync_changed' in 'field list'
> [pid 25447 on line 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> 2014-07-16T16:09:02+04:00 ERR: HORDE #0
> /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/State/Base.php(456): Horde_ActiveSync_State_Sql->_getMailMapChanges(Array) #1 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Collections.php(1223): Horde_ActiveSync_State_Base->getChanges(Array) #2 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Collections.php(1259): Horde_ActiveSync_Collections->getCollectionChanges(false) #3 /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Request/Sync.php(400): Horde_ActiveSync_Collections->getCollectionChangeCount() #4
> /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync/Request/Base.php(253):
> Horde_ActiveSync_Request_Sync->_handle() #5
> /volume1/@appstore/horde/share/pear/php/Horde/ActiveSync.php(880):
> Horde_ActiveSync_Request_Base->handle() #6
> /volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php(143):
> Horde_ActiveSync->handleRequest('Sync', 'e254e6e555e36ab...') #7
> /volume1/web/horde/rpc.php(159):
> Horde_Rpc_ActiveSync->getResponse(NULL) #8 {main} [pid 25447 on line
> 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> 2014-07-16T16:09:02+04:00 ERR: HORDE Buffer contents:
> jEN1OK{5297200f-81ec-4e06-8edd-43820afa0afa}70R at Contacts@N1 [pid
> 25447 on line 162 of
> "/volume1/@appstore/horde/share/pear/php/Horde/Rpc/ActiveSync.php"]
> Seems that db schema migration was unsuccessful, but Configuration
> menu states that all schemas are up to date (but "ActiveSync" not
> present in application list, only main Horde applications are listed)
>>
>> See http://www.horde.org/apps/horde/docs/UPGRADING [1] (you must fill in
>> the blanks in the ActiveSync configuration page).
>
> I have update ActiveSync configuration after upgrade. These errors apear
> after that.
>
> ---
> С уважением, / Kindest regards,
> Иван Кувыков / Ivan Kouvykov
>
> ivan at kouvykov.com
>
>
>
> Links:
> ------
> [1] http://www.horde.org/apps/horde/docs/UPGRADING
> --
> sync mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: sync-unsubscribe at lists.horde.org
Your migration(s) didn't run. You can run them using the
horde-db-migrate utility.
mike
Sent from mobile
-------- Original message --------
From: Ivan Kouvykov <ivan at kouvykov.com>
Date:07/16/2014 10:00 AM (GMT-05:00)
To: sync at lists.horde.org
Subject: Re: [sync] ActiveSync error after 5.2 upgrade
More information about the sync
mailing list