[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         | markus at mwagner.info <markus at mwagner.info>
  Summary            | IMAP Client issues / Wrong SQL statement?
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_5_1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


markus at mwagner.info (2014-02-18 12:33) wrote:

When moving a message with IMP on my IMAP-Server from INBOX to  
Folder.Subfolder I receive the following error (attachment) and also  
the following log entry is issued.

2014-02-18T13:16:23+01:00 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', 'Folder.Subfolder', '143',
           'user at domain.com') [pid 16977 on line 553 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"

There is a messageid field in the horde_imap_client_data table which  
is set to 0 already for "Folder". Other folders have other numbers.

Also, when looking at the folder (e.g. click to show content), I just  
see nothing/empty folder.
However, for other (older) IMAP-Folders everything works perfectely.

What could be the reason for this?! DB out of date/not properly updated?

Thanks for any pointers/fixes.





markus at mwagner.info (2014-02-18 12:33) uploaded: horde5-imp-sql-error.png

http://bugs.horde.org/h/services/download/?app=whups&actionID=download_file&file=horde5-imp-sql-error.png&ticket=12979&fn=%2Fhorde5-imp-sql-error.png