[Tickets #12979] Re: IMAP Client issues / Wrong SQL statement?

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12979
------------------------------------------------------------------------------
  Ticket             | 12979
  Updated By         | wojnas at gmail.com
  Summary            | IMAP Client issues / Wrong SQL statement?
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | No Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


wojnas at gmail.com (2014-04-28 07:46) wrote:

> Always via official debian repository (though sid/experimental).
> (I used to have a PEAR installation way before...)
>
>> So, did you install the original horde_imap_client version through
>> apt/dpkg and then upgraded via PEAR?
>> Do you remember the versions of that library before and after the upgrade?
>> It starts to sound like a botched upgrade rather than a design issue
>> of the migration scripts.
>
Hello,
i got the same problem, after upgrade horde 2 weeks ago by pear.
Here is my database structure (there is no autoincremet option i  
messageid column):

mysql> DESCRIBE horde_imap_client_data;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| messageid | int(10) unsigned | NO   | PRI | 0       |       |
| hostspec  | varchar(255)     | NO   | MUL | NULL    |       |
| mailbox   | varchar(255)     | NO   |     | NULL    |       |
| modified  | bigint(20)       | YES  |     | NULL    |       |
| port      | int(11)          | NO   |     | NULL    |       |
| username  | varchar(255)     | NO   |     | NULL    |       |
+-----------+------------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

New users can't log to webmail.
He is error from my log file

Apr 28 09:26:18 hostname HORDE: [imp] SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry  
'0' for key 'PRIMARY'  #012#011INSERT INTO horde_imap_client_data  
(hostspec, mailbox, port, username)#012#011  VALUES ('host', 'INBOX',  
'143', 'username at domain') [pid 9236 on line 204 of  
"/usr/share/pear/Horde/Db/Adapter/Pdo/Base.php"]

How can i fix the problem?