Hi

An IMAP Client tries to sync and throws some errors - there should be an message with the id 9095 inside the Draft folder.
Server side I get:

com.zimbra.cs.mailbox.MailServiceException$NoSuchI temException: no such item: 9095
ExceptionId:ImapSSLServer-3972:1370925407688:bc81f6c6df758df0
Code:mail.NO_SUCH_ITEM ArgitemId, IID, "9095")
at com.zimbra.cs.mailbox.MailServiceException.NO_SUCH _ITEM(MailServiceException.java:163)
at com.zimbra.cs.mailbox.MailItem.noSuchItem(MailItem .java:1659)
at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:2697
...
The corresponding mailbox is 45 - I've searched around in the DB for the corresponding entry:

mysql> use mboxgroup45;
Database changed
mysql> SELECT * FROM mail_item where id = 9095;
Empty set (0.01 sec)
mysql>
I also tried to find out which folder id the Draft folder has - I recognized that the type=1 indicates folders:

mysql> select id, name, flags, tags from mail_item where type=1;
+------+------------------+---------+------+
| id | name | flags | tags |
+------+------------------+---------+------+
| 1 | USER_ROOT | 0 | 0 |
| 2 | Inbox | 0 | 0 |
| 3 | Trash | 0 | 0 |
| 4 | Junk | 0 | 0 |
| 5 | Sent | 0 | 0 |
| 6 | Drafts | 0 | 0 |
| 7 | Contacts | 0 | 0 |
| 8 | Tags | 0 | 0 |
| 9 | Conversations | 0 | 0 |
| 10 | Calendar | 2097152 | 0 |
| 11 | ROOT | 0 | 0 |
| 12 | Notebook | 0 | 0 |
| 13 | Emailed Contacts | 0 | 0 |
| 14 | Chats | 0 | 0 |
| 15 | Tasks | 2097152 | 0 |
| 16 | Briefcase | 0 | 0 |
| 1714 | Notes | 524288 | 0 |
| 1749 | PW | 0 | 0 |
+------+------------------+---------+------+
18 rows in set (0.01 sec)
So id 6 should be the Drafts folder - I tried to find out if the DB shows me any message inside this folder. I was not sure if parent_id or folder_id is the foreign key so I tried both:

So id 6 should mysql> SELECT * from mail_item WHERE folder_id=6;
Empty set (0.01 sec)

mysql> SELECT * from mail_item WHERE parent_id=6;
Empty set (0.01 sec)

mysql>
I also did some queries in the tag tables but I was not able to find the corresponding item id 9095 anywhere.
Any hint on this?