[horde] httpd slow start/restart

[Michael J Rubinsky]

Quoting Andreas Mauser <andreas at mauser.info>:

> ----- 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.

Don't know what to tell you. The 21 migration creates that column, so  
if you ran all the migrations and there were no errors, it should be  
there. You can try migrating down to 20 and then back up to 21 to see  
if that helps.

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20140622/c94ad164/attachment.bin>