[Bug 246257] deletion of mails doesn't work, deleted mails reappear
Christophe Giboudeaux
cgiboudeaux at gmail.com
Wed Aug 25 16:25:34 BST 2010
https://bugs.kde.org/show_bug.cgi?id=246257
--- Comment #3 from Christophe Giboudeaux <cgiboudeaux gmail com> 2010-08-25 17:25:18 ---
Some tests result with a fresh akonadi setup and a DIMAP account.
I've checked the database state before deleting the message, just after and
finally after manually checking the messages in KMail.
The Query I used is:
SELECT pimitemtable.id, pimitemtable.rev, pimitemtable.remoteId,flagtable.name,
pimitemtable.remoteRevision, collectiontable.name, mimetypetable.name,
pimitemtable.dirty, pimitemtable.size FROM pimitemtable LEFT JOIN
collectiontable ON collectiontable.id = pimitemtable.collectionId LEFT JOIN
mimetypetable ON pimitemtable.mimeTypeId = mimetypetable.id LEFT JOIN
pimitemflagrelation ON pimitemtable.id=pimitemflagrelation.PimItem_id LEFT JOIN
flagtable ON pimitemflagrelation.Flag_id= flagtable.id ORDER BY pimitemtable.id
The full output is in the attached file, here's the result for the message I
played with.
1/ The messages were downloaded:
| 20 | 0 | 43360 | \Seen | NULL | INBOX | message/rfc822 |
0 | 7891 |
2/ In KMail, the corresponding message is deleted:
| 20 | 1 | {963bdc29-9b5f-463e-ae30-995c9b76bb85} | \Seen | NULL
| trash | message/rfc822 | 0 | 7891 |
3/ After a manual check:
| 20 | 1 | {963bdc29-9b5f-463e-ae30-995c9b76bb85} | \Seen | NULL
| trash | message/rfc822 | 0 | 7891 |
| 47 | 1 | 43360 | \DELETED | NULL
| INBOX | message/rfc822 | 0 | 7891 |
| 47 | 1 | 43360 | \SEEN | NULL
| INBOX | message/rfc822 | 0 | 7891 |
At this point, I have a copy in the trash folder for the local maildir resource
*AND* the message is also in the INBOX folder but greyed.
If I manually remove the \DELETED flag from the database, I can click this
message again.
--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list