[kmail2] [Bug 314239] mail body not displayed but on disk

[Martin Koller]

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.