[kmail2] [Bug 266666] KMail cannot see a folder it created

[Johannes Zarl]

https://bugs.kde.org/show_bug.cgi?id=266666

Johannes Zarl <isilmendil at isilme.lupus.uberspace.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |isilmendil at isilme.lupus.ube
                   |                            |rspace.de

--- Comment #3 from Johannes Zarl <isilmendil at isilme.lupus.uberspace.de> ---
I am also affected by the issue.

The first time I was hit by this, I did the "workaround" of deleting the entire
akonadi database, which worked for me.

I just noticed today (after trying to add a folder again), that the problem
seems to be the insert statement in the akonadi database.

Akonadi prints the following message to the console:
> Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)" :  "Duplicate entry '390-DevLoL' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"

When I connected manually to the akonadi mysql database, I noticed a naming
problem:

mysql> select id, remoteId, name from collectiontable where resourceId = 26;
+------+----------------------------------------------+----------------------+
| id   | remoteId                                     | name                 |
+------+----------------------------------------------+----------------------+
|  407 | .INBOX                                       | INBOX                |
| 1441 | /DevLoL                                      | DevLoL               |
+------+----------------------------------------------+----------------------+
(most rows removed for privacy/brevity)

All the folders that work correctly have the remoteId field beginning with a
dot, whereas the non-working folders begin with a slash.

Manually fixing the remoteId causes kmail to display the folder correctly.

I guess that kmail uses the incorrect value when creating the folder?

-- 
You are receiving this mail because:
You are the assignee for the bug.