[Akonadi] [Bug 323844] Adding foldert to imap-account gives "Duplicate entry" sql error

[Dennis Schridde]

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

--- Comment #13 from Dennis Schridde <devurandom at gmx.net> ---
I have the same issue with a trash folder.

I get a popup dialogue saying:
```
The Email program encountered a fatal error and will terminate now.
The error was:
Could not create collection trash resourceId: 5
```

On the console Akonadi logs:
```
DATABASE ERROR:
Error code: 1062
DB error:  "Duplicate entry '6-trash' for key
'CollectionTable_parentAndNameIndex'"
Error text: "Duplicate entry '6-trash' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId,
resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit,
isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10)"
Error during insertion into table "CollectionTable" "Duplicate entry '6-trash'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement" 
```

Looking at the collectiontable in akonadiconsole shows me that the collection
with id 6 has resourceId 5, and that a collection with remoteId "trash" exists
with parentId 6.

-- 
You are receiving this mail because:
You are on the CC list for the bug.