[horde] Horde suddenly started half-working

[Michael J Rubinsky]

Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:

> On Mon, Oct 6, 2014 at 12:51 PM, Jan Schneider <jan at horde.org> wrote:
>
>>
>> Zitat von Louis-Philippe Allard <lp.allard.1 at gmail.com>:
>>
>>  Hi
>>>
>>> Ive been using my current horde setup for about  3 months and all was fine
>>> until tonight where I tried to send an email and it never finished.  This
>>> is the behavior and symptoms Ive observed:
>>>
>>> -Compose a test email to myself (send it to myself), press send, the
>>> window
>>> becomes gray and the spinning wheel spins forever
>>>
>>> -The spinner beside "Refresh" in the main email window keeps spinning
>>> forever
>>>
>>> -While this happens, the test email do not arrive in inbox (so as anything
>>> else)
>>>
>>> -Pressing F5 on browser (refresh) causes 10 to 20 red error alerts "Error
>>> communicating with server" to appear
>>>
>>> -Closing browser and reopening, the test email arrive in inbox and
>>> confirms
>>> that even if the compose window never finished and closed, the email was
>>> indeed sent.
>>>
>>> I tried restarting httpd,  flushing temp files on the server, looking at
>>> httpd logs, flushing firefox cache manually (although set to auto clean at
>>> shutdown) nothing helps.
>>>
>>> I swear yesterday all was fine but today this is broken. How to
>>> troubleshoot??
>>>
>>> Thanks!
>>>
>>
>> HTTP logs are useless. Check JS, IMAP, Horde logs.
>>
>> --
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>> https://www.facebook.com/hordeproject
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
> I have tried to send this email with my Horde install and it failed, so if
> it was somehow sent already I apologize for repeating...
>
> Hello Jan,  I have tried to find error entries in various logs, except than
> Snort blocking Google servers therefore screwing things up, I have not
> found anything else except hundreds of error messages in /var/log/messages
> all related to database:
>
> Oct 14 07:28:29 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 07:28:29 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 07:28:39 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011  'imp:lp*allard*1 at gmail*com'
> [pid 26944 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 07:28:39 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 26944 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 07:29:42 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 18:43:43 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 26937 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> Oct 14 21:36:22 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
> horde_histories WHERE object_uid =#012#011
> 'imp:lp*allard*1 at gmail*com:<###################>'
> [pid 31146 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
>
> I did upgrade the DB schemas when I installed horde.  Apparently the errors
> are dating back a while....
>
> I remember when I installed Horde I saw similar errors in the GUI in a red
> tooltip popping up at the bottom...
>
> What next?

Obviously something failed in the creation of the horde_histories  
table. What does that table look like? What happens if you try to  
recreate the table using horde-db-migrate?


-- 
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/20141015/202dec2d/attachment.bin>