[Kde-pim] getting more info out of "NO Multiple merge candidates, aborting"

[Christian Mollekopf]

... this error message during an ItemSync means that you have duplicate RID's 
in the synced collection.

You should be able to find duplicate rid's with the following query:

select id, count(remoteId) from pimitemtable where collectionId = 226911
	group by remoteId having ( count(remoteId) > 1 );

Just make sure to substitute the collectionId with the one where you get this 
error.

I suggest to use the commandline sql client:

mysql --auto-vertical-output 
	-S $XDG_DATA_HOME/akonadi/socket420s.chrigi/mysql.socket akonadi


Cheers,
Christian
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/