[kmail2] [Bug 353675] New: Search does not work, neither do search folders

[piedro]

https://bugs.kde.org/show_bug.cgi?id=353675

            Bug ID: 353675
           Summary: Search does not work, neither do search folders
           Product: kmail2
           Version: unspecified
          Platform: Archlinux Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: search
          Assignee: kdepim-bugs at kde.org
          Reporter: piedro.kulman at googlemail.com
                CC: me at vhanda.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. 

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...

-- 
You are receiving this mail because:
You are the assignee for the bug.