SQL errors running akonadi fsck/vacuum
"Joshua J. Kugler" <[email protected]>
| Newsgroups | gmane.comp.kde.users.pim |
|---|---|
| Message-ID | <2177743.JiEr9cVFvy@hosanna> |
I'm trying to run akonadi fsck and vacuum, and am seeing a lot of these in the output: Found duplicates 1429184580.R736.hosanna org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1064" org.kde.pim.akonadiserver: DB error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1" org.kde.pim.akonadiserver: Error text: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: Query: "SELECT PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN ( ) AND PartTable.storage = :0 )" akonadi-backend-mysql 4:17.12.3-0ubuntu3 akonadi-server 4:17.12.3-0ubuntu3 mysql-server-core-5.7 5.7.25-0ubuntu0.18.04.2 What is the best way to go about debugging this? Thanks! j -- Joshua J. Kugler -- Fairbanks, AK Blogs: http://jjncj.com/blog/ (Family) -- http://joshuakugler.com (Geek) Philippians 2:9-11