[kmail2] [Bug 314239] mail body not displayed but on disk
Martin Koller
kollix at aon.at
Sun May 12 15:04:31 BST 2013
https://bugs.kde.org/show_bug.cgi?id=314239
--- Comment #3 from Martin Koller <kollix at aon.at> ---
Analyzing further a mail from kde-core-devel mailing list:
The file on disk is named 1366115976.R739.linux-d4d3.site
Looking into the akonadi database:
select * from pimitemtable where remoteid="1366115976.R739.linux-d4d3.site";
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| id | rev | remoteId | remoteRevision |
collectionId | mimeTypeId | datetime | atime | dirty |
size |
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| 137931 | 1 | 1366115976.R739.linux-d4d3.site | NULL |
226 | 2 | 2013-04-16 12:39:37 | 2013-05-12 15:26:04 | 0 | 20527 |
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
1 row in set (0.07 sec)
mysql> select * from pimitemtable where
remoteid="1366115976.R739.linux-d4d3.site";
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| id | rev | remoteId | remoteRevision |
collectionId | mimeTypeId | datetime | atime | dirty |
size |
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| 137931 | 1 | 1366115976.R739.linux-d4d3.site | NULL |
226 | 2 | 2013-04-16 12:39:37 | 2013-05-12 15:26:04 | 0 | 20527 |
+--------+-----+---------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
1 row in set (0.06 sec)
mysql> select * from parttable where pimItemId=137931;
+--------+-----------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+----------+
| id | pimItemId | name | data
| datasize | version | external
|
+--------+-----------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+----------+
| 325129 | 137931 | PLD:ENVELOPE | ("Tue, 16 Apr 2013 14:06:19 +0200"
"Results of the freedesktop summit" (("David Faure" NIL "faure" "kde.org"))
((NIL NIL "kde-core-devel-bounces" "kde.org")) NIL ((NIL NIL "kde-core-devel"
"kde.org")) NIL NIL NIL "<1394549.VkPtykuPsj at asterix>" NIL) | 248 |
1 | 0 |
| 325128 | 137931 | PLD:HEAD | NULL
| 0 | 1 | 0
|
| 325130 | 137931 | PLD:RFC822 | NULL
| 0 | 1 | 0
|
+--------+-----------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+----------+
3 rows in set (0.00 sec)
So what I see is that "PLD:HEAD" and "PLD:RFC822" is NULL in akonadi but not on
disk ...
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list