[Kde-pim] trying to understand akonadi
Martin Koller
kollix at aon.at
Wed Oct 16 18:47:00 BST 2013
Hi,
I have a problem with kmail (4.11.2) where my mbox resource (which is filled from an external program)
often shows a mail with subject/sender/date:Unknown.
Currently I have such a mail and I try to find out what's going on in akonadi.
This mbox file has a few other mails (e.g. grep ^Date: finds 4 lines), but only 1 is shown
(I assume the others are already marked/stored internally by the mbox resource as deleted, which is fine).
The one shown is the "unknown" problem.
In akonadi I find:
select * from pimitemtable where collectionId=413;
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| id | rev | remoteId | remoteRevision | collectionId | mimeTypeId | datetime | atime | dirty | size |
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| 128101 | 0 | 413::file:///home/koller/airsync.mbox::41642 | NULL | 413 | 2 | 2013-10-16 17:40:23 | 2013-10-16 17:40:23 | 0 | 13585 |
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
1 row in set (0.00 sec)
so yes, this is the mail I should see. (I checked the mentioned mbox file and starting at byte 41642 I find a new mail)
select * from parttable where pimItemId=128101;
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
| id | pimItemId | name | data | datasize | version | external |
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
| 293642 | 128101 | PLD:ENVELOPE | (NIL NIL NIL NIL NIL NIL NIL NIL NIL NIL NIL) | 45 | 1 | 0 |
| 293641 | 128101 | PLD:HEAD |
| 1 | 1 | 0 |
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
2 rows in set (0.00 sec)
I have no idea what this columns shall contain, but checking some other entries shows that the
PLD:ENVELOPE record should contain something useful in the data field (Date, subject, etc.).
So this situation would explain why I see "unknown" as the data holds "NIL ..."
Any idea why this can happen ?
Who fills that fiels and when ?
--
Best regards/Schöne Grüße
Martin
A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad?
() ascii ribbon campaign - against html e-mail
/\ www.asciiribbon.org - against proprietary attachments
Geschenkideen, Accessoires, Seifen, Kulinarisches: www.bibibest.at
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/
More information about the kde-pim
mailing list