I had same issue, but with collection “trash” and other resourceID (5), but I solved it without to delete a lot of files. I followed these steps (assisted by DuckDuckGo’s AI chat; GPT4o-mini):
- Open
akonadiconsole(it will probably be necessary to install it) - In the “DB Explorer” tab (the fifth tab…I don’t know its name/label in English because I have my GUI in Spanish), select the table
resourcetableand check for the resource with id reported in the error dialog (in my case, theresourceId“5”; in the case of @PedroSMS , it should be “14”). I did this to figure out what resource had the issue; it wereakonadi_maildir_resource_0, that is my “Local folders” resource. - Then, select the table
collectiontableand look up for records withresourceId= 5, just to verify that resource had a related collection named “trash” - Finally, in the tab Explorer or Collections (the second tab) look up for “trash” collection/folder of the affected resource (in my case “Local folders”) and delete it
- It’s done: try again to open Kmail. The deleted collection will be re-created
Deleting the collection:
