database error with akonadictl fsck

[Daniel Vrátil]

On Monday, 15 October 2018 11:41:45 CEST Dominique Dumont wrote:
> Hi
> 
> akonadictl fsck shows quite a lot of the following error message:
> 
> 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 )" Found duplicates 9048
> 
> How can I fix this error ?

I fixed the bad SQL code for next bugfix release (5.9.3).


Cheers,
Daniel

> 
> Kontact is version 5.9.1 on Debian unstable.
> 
> All the best
> 
> Dod


-- 
Daniel Vrátil
www.dvratil.cz | dvratil at kde.org
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20181022/3caa8edf/attachment.sig>