[kmail2] [Bug 266666] KMail cannot see a folder it created
Johannes Zarl
isilmendil at isilme.lupus.uberspace.de
Thu Nov 14 22:21:38 GMT 2013
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.
More information about the Kdepim-bugs
mailing list