[Bug 305543] New: "Paramter count mismatch" during akonadi start-up due to broken SQL query

[Matthias Nagel]

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

            Bug ID: 305543
          Severity: normal
           Version: 4.8
          Priority: NOR
          Assignee: kdepim-bugs at kde.org
           Summary: "Paramter count mismatch" during akonadi start-up due
                    to broken SQL query
    Classification: Unclassified
                OS: Linux
          Reporter: mh-nagel at web.de
          Hardware: Other
            Status: UNCONFIRMED
         Component: general
           Product: Akonadi

If I (re-)start akonadi from the shell with "akonadictl restart" I get the
following message a few times

Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE (
CollectionPimItemRelation.Collection_id = :1 AND (
CollectionPimItemRelation.PimItem_id = PimItemTable.id ) )" :  " Parameter
count mismatch"
Unable to update item access time 

The reason becomes obvious if one tries to execute this query in the db console
of the akonadi console.

A table "CollectionPimItemRelation" does not exist.

Unfortunately I have no glue which akonadi component (which agent) is
responsible for this malformed query.

"akonadictl --version" gives 1.8.0
"kontact --version" gives
Qt: 4.8.2
KDE: 4.8.3 (4.8.3)
Kontact: 4.8.3

Reproducible: Always

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