any idea where this SQL query comes from?

[Daniel Vrátil]

More of a kde-pim question than kdepim-users :) 

There could be multiple places in Akonadi triggering this query, it seems rather generic.

To find where exactly in Akonadi the query is being constructed you could attach gdb to the akonadiserver process and set breakpoint to querybuilder.cpp:400 and get a backtrace. The line 400 is where the error handling code for most query executions begins, so once the query fails gdb will hit that breakpoint and stop. The line number might be different in your version of Akonadi, but it's the first line inside "if (!ret) {" block in QueryBuilder::exec(), just check the file in tarball from which your Akonadi is built. 400 is the line in git master. 

Feel free to poke me off-list if you need help. 

Dan


(sorry for top-posting, I'm writing from my phone) 


  Original Message  
From: rjvbertin at gmail.com
Sent: October 20, 2016 15:14
To: kdepim-users at kde.org
Subject: any idea where this SQL query comes from?

Hi,

I'm seeing a new error pop up on my Akonadi terminal:

Error code: 1064
DB error:  "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= NULL )' at line 1"
Error text: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= NULL )' at line 1 QMYSQL: Unable to execute query"
Query: "SELECT DISTINCT CollectionTable.id, CollectionTable.parentId FROM CollectionTable LEFT JOIN CollectionMimeTypeRelation ON ( CollectionMimeTypeRelation.Collection_id = CollectionTable.id ) LEFT JOIN MimeTypeTable ON ( CollectionMimeTypeRelation.MimeType_id = MimeTypeTable.id ) WHERE (  = NULL )"
Failed to query search collections 


Any idea where that SELECT DISTINCT query comes from? I can only find one in Kontact's summary plugin, but I'm seeing this error when Kontact isn't even running ...

Thanks,
R.