Author Topic: Server Error (OK) during search  (Read 9597 times)

Offline VeraVault

  • Newbie
  • *
  • Posts: 6
Server Error (OK) during search
« on: December 30, 2009, 04:06:00 PM »
Hello,

I'm using the latest version that just got updated with my cpanel.

I get an error whenever "Entire Message" is checked for searching. There are about 600 messages in the inbox.

It would show "Searching.." then I get the "Server Error (OK)". I looked at the error log i get:

 DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_6999fb516629f8724afb7def0ec2b2db31b12938e USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '3-INBOX.msg-6935' for key 2]  in /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php on line 627 (GET /3rdparty/roundcube/index.php?_task=mail&_mbox=INBOX)

Unexpected condition from IMAP server, closed or corrupt connection to IMAP. Possible mailbox corruption.

PHP Warning:  fputs(): 40 is not a valid stream resource in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/imap.inc on line 205

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Server Error (OK) during search
« Reply #1 on: December 30, 2009, 04:49:09 PM »
Can you get a imap server log?

Offline VeraVault

  • Newbie
  • *
  • Posts: 6
Server Error (OK) during search
« Reply #2 on: December 30, 2009, 06:12:20 PM »
Quote from: skaero;24320
Can you get a imap server log?


where do i find that?

I looked at the var/log/maillog and there was no errors there.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363
Server Error (OK) during search
« Reply #3 on: December 31, 2009, 02:14:38 AM »
I don't know why you've got "Server error (ok)" message, but "Unexpected condition from IMAP server..." looks not good. Enable imap_debug option in Roundcube and check logs/imap file.

Offline VeraVault

  • Newbie
  • *
  • Posts: 6
Server Error (OK) during search
« Reply #4 on: December 31, 2009, 12:18:15 PM »
so I did enable the imap log. the log to me seems fine during the search.

[31-Dec-2009 12:09:41 -0500]: S: * SEARCH
[31-Dec-2009 12:09:41 -0500]: S: srch1 OK SEARCH done.
[31-Dec-2009 12:09:41 -0500]: C: sel1 SELECT "INBOX.Trash"
[31-Dec-2009 12:09:41 -0500]: S: * FLAGS (\Draft \Answered \Flagged \Deleted \Seen \Recent)
[31-Dec-2009 12:09:41 -0500]: S: * OK [PERMANENTFLAGS (\* \Draft \Answered \Flagged \Deleted \Seen)] Limited
[31-Dec-2009 12:09:41 -0500]: S: * 1 EXISTS
[31-Dec-2009 12:09:41 -0500]: S: * 0 RECENT
[31-Dec-2009 12:09:41 -0500]: S: * OK [UIDVALIDITY 1254770403] Ok
[31-Dec-2009 12:09:41 -0500]: S: * OK [MYRIGHTS "acdilrsw"] ACL
[31-Dec-2009 12:09:41 -0500]: S: sel1 OK [READ-WRITE] Ok
[31-Dec-2009 12:09:41 -0500]: C: srch1 SEARCH ALL UNSEEN
[31-Dec-2009 12:09:41 -0500]: S: * SEARCH
[31-Dec-2009 12:09:41 -0500]: S: srch1 OK SEARCH done.
[31-Dec-2009 12:09:41 -0500]: C: I LOGOUT

Offline VeraVault

  • Newbie
  • *
  • Posts: 6
Server Error (OK) during search
« Reply #5 on: December 31, 2009, 12:29:49 PM »
this problem only occurs when doing a search on a folder that has more than 5300 messages. If i do a filter, and only show the unread messages (about 400 of them) the search works.
« Last Edit: December 31, 2009, 12:32:09 PM by VeraVault »

Offline VeraVault

  • Newbie
  • *
  • Posts: 6
Server Error (OK) during search
« Reply #6 on: January 20, 2010, 04:23:10 PM »
Any one? this issue is driving me nutz.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363
Server Error (OK) during search
« Reply #7 on: January 21, 2010, 03:47:51 AM »
There could be "srch1 SEARCH CHARSET UTF-8 HEADER..." in the log. I don't see this nor what returns server for that command.