You are not logged in.
Hello!
On Arch fully updated I get some problems with akonadi:
(akonadi 15.08.1-1, kmail 15.08.1-1)
The akonadi errors I always get (database driver Mysql):
DATABASE ERROR:
Error code: 1452
DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Der Befehl konnte nicht ausgef\u00FChrt werden"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id) VALUES (:0, :1)"
This error also came up after completely rebuilding all mail accounts in akonadi.
Also the "search mail" function to create virtual search folders seems not to work at all.
It sometimes works one time but then always uses the same search pattern everytime no matter what search criteria I enter in subsequent searches. For some really obvious patterns like "somewhere in the mail header" "contains" "gmail.com" I do not get any search results at all though searching "all folders"...
BTW this behaviour is the same when I switch to an external Mariadb server.
Now I do not know if these two issues are related but I assume so.
Also the akonadi control module shows only one (!) single gmail resource though akonadi console shows about 10 mail resources, also calendar and contact resources and so forth.
On a fresh user account I run into the same problems....
Is there a way to clean up this situation without reconfiguring the complete akonadi setup (including all mail accounts)?
In the past I had about a dozen virtual virtual search folders running well within kmail.
Now I am lost here.
Any ideas someone?
thx, p.
Last edited by piedro (2015-10-07 16:08:38)
Offline
I'd love to hear any success story: Is there anyone searching mail in Kmail with success?
thx, p.
Offline