Bug 353675

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. 

Reproducible: Always

Steps to Reproduce:
1. search for "gmail" in all mail folders
2. if results come up, close search, search again for a different search pattern
3. 

Actual Results:  
either there are no search results at all or there are the same results no matter which search pattern everytime ... 

Expected Results:  
search should work

I consider a mail client without working search completely useless, why not use a web browser for checking mail? - cause you want to manage mail, search it, filter it, archive it.... nothing of these works without working search... 

working virtual folders based on searches are standard now, do not work without search, obviously...