https://bugs.kde.org/show_bug.cgi?id=338658
Chris <crgla...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |crgla...@gmail.com --- Comment #48 from Chris <crgla...@gmail.com> --- (In reply to Paul Eggleton from comment #22) > I have at least figured out how to fix the database in order to get > directories syncing again using the Akonadi Console. (Disclaimer: this > worked for me, may not work for you, you might lose data if you aren't > careful, etc.) > > First I searched to find the duplicate keys using the "DB Console" tab with > the following query: > > SELECT pimitemtable.*, collectiontable.name FROM pimitemtable > INNER JOIN pimitemtable dup ON pimitemtable.id != dup.id and > pimitemtable.remoteId = dup.remoteId and pimitemtable.collectionId = > dup.collectionId > INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id > ORDER by pimitemtable.remoteId > > Then I looked for the items specifically in the folders that I knew were > failing to sync with the "Multiple merge candidates, aborting" error, then > used the Id to track down one of the duplicate items in the "Browser" tab > and then deleted it there from the context menu. (There are still others > with duplicate ids, but I have not deleted those since they don't appear to > be causing any problems.) I then restarted the akonadi server, and then > reloaded the folder in KMail and voila, the folder now synchronises > successfully. This does work in Kmail5. Has anyone tried the remove duplicate email option in the folder? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs