[horde] httpd slow start/restart

[Andreas Mauser]

----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
      Datum: Sun, 22 Jun 2014 12:22:51 -0400
        Von: Michael J Rubinsky <mrubinsk at horde.org>
Antwort an: mrubinsk at horde.org
    Betreff: Re: [horde] httpd slow start/restart
         An: horde at lists.horde.org


> Quoting Andreas Mauser <andreas at mauser.info>:
>
>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>  Datum: Sun, 22 Jun 2014 10:46:57 -0400
>>    Von: Michael J Rubinsky <mrubinsk at horde.org>
>> Betreff: Re: [horde] httpd slow start/restart
>>     An: horde at lists.horde.org
>>
>>
>>> Quoting Andreas Mauser <andreas at mauser.info>
>>>
>>>> Hi,
>>>>
>>>> can anyone please let me know how the following can be fixed? I  
>>>> got these lines with journalctl -b -u httpd
>>>>
>>>> Jun 18 17:08:38 web.inside.mauser.info HORDE[1569]: [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 = 'SEC12C8D94D06D1E' AND sync_user = 'franz' AND
>>>>                                                             
>>>> message_uid IN (3597) [pid 1569 on line 204 of  
>>>> "/usr/share/pear/Horde/Db/Adapter/Pdo/Base.php"]
>>>> Jun 18 17:08:38 web.inside.mauser.info HORDE[1569]: [horde]  
>>>> Returning HTTP 500 while handling Sync command. [pid 1569 on line  
>>>> 156 of "/var/www/html/mauser.info/mailoffice/rpc.php"]
>>>> Jun 18 17:08:38 web.inside.mauser.info HORDE[1569]: [horde] Error  
>>>> in communicating with ActiveSync server: SQLSTATE[42S22]: Column  
>>>> not found: 1054 Unknown column 'sync_changed' in 'field list'  
>>>> [pid 1569 on
>>>> Jun 18 17:08:38 web.inside.mauser.info HORDE[1569]: [horde] #0  
>>>> /usr/share/pear/Horde/ActiveSync/State/Base.php(456):  
>>>> Horde_ActiveSync_State_Sql->_getMailMapChanges(Array)
>>>>                                                  #1  
>>>> /usr/share/pear/Horde/ActiveSync/Collections.php(1223):  
>>>> Horde_ActiveSync_State_Base->getChanges(Array)
>>>>                                                  #2  
>>>> /usr/share/pear/Horde/ActiveSync/Collections.php(1259):  
>>>> Horde_ActiveSync_Collections->getCollectionChanges(false)
>>>>                                                  #3  
>>>> /usr/share/pear/Horde/ActiveSync/Request/Sync.php(400):  
>>>> Horde_ActiveSync_Collections->getCollectionChangeCount()
>>>>                                                  #4  
>>>> /usr/share/pear/Horde/ActiveSync/Request/Base.php(253):  
>>>> Horde_ActiveSync_Request_Sync->_handle()
>>>>                                                  #5  
>>>> /usr/share/pear/Horde/ActiveSync.php(880):  
>>>> Horde_ActiveSync_Request_Base->handle()
>>>>                                                  #6  
>>>> /usr/share/pear/Horde/Rpc/ActiveSync.php(143):  
>>>> Horde_ActiveSync->handleRequest('Sync', 'SEC12C8D94D06D1...')
>>>>                                                  #7  
>>>> /var/www/html/mauser.info/mailoffice/rpc.php(156):  
>>>> Horde_Rpc_ActiveSync->getResponse(NULL)
>>>>                                                  #8 {main} [pid  
>>>> 1569 on line 162 of "/usr/share/pear/Horde/Rpc/ActiveSync.php"]
>>>>
>>>> Thank you and have a best Sunday,
>>>> Andreas
>>>>
>>>> -- 
>>>> Horde mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/
>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>>
>>> Make sure that all the database migrations ate run. 
>>
>> In the configuration admin page it looks all up2date. no pear  
>> upgrade available, and no DB scheme to upgrade in the GUI. I did  
>> not upgrade to beta or RC.
>
> Well, the column is there. It was added in the "21" migration for  
> Horde_ActiveSync. Do you see the Horde_ActiveSync package listed in  
> the administration page?

ActiveSync is there and I get my mails on my phone.

Andreas