Hi all

I'm on IMP 6.2.0 (this instance installed about two years ago, 
regularly updated since then) and had suddenly the same issues with 
the table horde_imap_client_data and duplicate entry '0' for key 
'PRIMARY' errors.

MariaDB [horde]> describe horde_imap_client_data;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| messageid | int(10) unsigned | NO   | PRI | 0       |       |
..


Read in some tickets/mails that messageid was renamed from uid and 
thereby - as it seems - the autoincrement got lost somehow. I removed 
the default '0' and replaced it with autoincrement = high enough 
value. It's working again. Hope I didn't break anything surfacing 
later on.

Cheers
    Martin

Update: after a few hours, the error changed to:
-------------------------------------------------------
ERR: HORDE [imp] SQL QUERY FAILED: SQLSTATE[23000]: Integrity 
constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
        INSERT INTO horde_imap_client_data (hostspec, mailbox, port, username)
          VALUES ('localhost', 'INBOX', '143', 'MY-USER') [pid 22691 on line 
204 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
-------------------------------------------------------
Following a post I found, I altered that table setting autoincrement 
on "messageid". Now it seems to be working...

I'm not sure if the file got attached, here it is anyway:
http://pastebin.com/amM2Witc

Forgive me, what do you mean by upgrade over an active session? I 
upgraded the php5-* packages, then restarted php5-fpm. I didn't know 
there were other steps involved.

Attached you can find a portion of the log. I set the logging level to 
DEBUG, cleared the log file then clicked on "Mail" on the top bar, and 
that's what I get.

Thanks for your help.

No.  Something is very wrong with your setup if you are getting that 
issue.  You didn't upgrade over an active session did you?

At a minimum you will need to provide the full backtrace of this error 
(set Horde error logging to DEBUG level).

I've just upgraded to PHP5.5. IMP says "Error when communicating with 
the server", and I get this in the log:
-------------------------------------------
EMERG: HORDE [imp] Call to a member function queryCapability() on a 
non-object [pid 15084 on line 231 of "/var/www/horde/imp/lib/Imap.php"]
-------------------------------------------
Do you have any ideas on how to fix that?
Thanks