https://bugs.kde.org/show_bug.cgi?id=339214
--- Comment #50 from Fabian Vogt <fab...@ritter-vogt.de> --- (In reply to Knut Hildebrandt from comment #49) > (In reply to Fabian Vogt from comment #48) > > Resetting state to REPORTED, this clearly was not fixed. > > > > (In reply to Knut Hildebrandt from comment #47) > > > (In reply to Fabian Vogt from comment #44) > > > > Here's how to manually fix the weirdness in the database without folder > > > > remaining: > > > > > > > > 1. Start akonadiconsole > > > > 2. In the browser tab, right click on "Local Folders" -> "Trash" > > > > 3. Open the Folder properties window > > > > 4. In the "Attributes" tab, make sure it has > > > > "SpecialCollectionAttribute" > > > > set to "trash". If necessary, change or create it. > > > > 5. Start kmail again > > > > > > > > This also applies if the error message is about drafts or other special > > > > folder, just set the attribute on the matching folder instead. > > > > > > Today I ran into that problem again, but can't solve it by either deleting > > > the trash folder or following what these instructions. Thus I'm not sure, > > > if > > > it is caused by the same bug. > > > > > > Two things I did today. In an IMAP-Account I had set deleting trash after > > > two weeks. I had done this before a while, but it was unset. And I > > > upgraded > > > the system and thus Kmail from 24.05.2 to 24.08.1 today. > > > > > > BTW, when I set SpecialCollectionAttribute it is not persistent. After > > > closing and reopening Akonadoconsole the had disappeared. > > > > That's probably the issue, it needs to be properly saved. Any warnings or > > errors in the journal? > > Well, after starting Kmail - actually Kontact - I found this in > Akonadi.error: > > [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR: > [CRITICAL] org.kde.pim.akonadiserver: Error code: "1062" > [CRITICAL] org.kde.pim.akonadiserver: DB error: "Duplicate entry > '6-trash' for key 'CollectionTable_parentAndNameIndex'" > [CRITICAL] org.kde.pim.akonadiserver: Error text: "Duplicate entry > '6-trash' for key 'CollectionTable_parentAndNameIndex' QMYSQL: Der Befehl > konnte nicht ausgeführt werden" > > That suggested that something with the database was wrong, thus I stopped > Akonadi and renamed it. After restarting Akonadi the database was rebuild > and I could start Kmail - actually Kontact - with the drawback, that all my > settings were lost ;-( Since this is unaccaptable I got back to the old > database looking for another solution. Any idea? A suggestion how to fix the > database? Using the DB browser in akonadiconsole you'll have to delete the entry with "name" trash and "parentId" 6 that has the higher id. Then follow the instructions to assign the specialcollectionattribute to the correct trash again. -- You are receiving this mail because: You are watching all bug changes.
