Re: database error with akonadictl fsck

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 | [email protected]
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEECr36VaTmvqmag+qXTWlVeuyxNoMFAlvNrygACgkQTWlVeuyx
NoNjTw/+PlSJuOV0O9uIo7szj7gV+x5Cu95celzoSP1i1uo6HJHoqfCZIzlL8t5L
rDERQroBFlbVi/DrK1j3S9zGytSYdKuZYa7Wbyae60WG7r8TbMl3ixgwqpKNx+hb
jysIJLslVEgp8l66417jx6Mq7x1H+8tg1xoPEtzbC6XWHVQ8IkbmwW2MxzUuKwZB
vQHIH24eIRlxpFe8ZJ6A/QpqT4FnIr4StxM6E8gQ3udNKvfu5JvNAOR/4F8btlD5
Me387yXbW6krnJHYthaSkPWS5AS7Z0G1N7RfA2pQoDMvvCkQG0A+Iy5lOqcRHp+l
3Hv3NVFQ0S3w+hefWqVnI8Wbfdjc2BnZMI/cI2/mfM2skWnzA9R8IU1RKDSQowN7
IOF5zQTsJwkGevG/guEJ1tE7qKbYcdvMOghE0uPT3ljnPaJYrg1jdlWE0idaAqQP
dyS9OWfy3ilF+3eFwkoPtFOatEcuQDR/tUcjvh5OiBgf7OTucDU6RZ1+wkqHhMZf
jWzIWwNk9kzHVr5OgH/4ksNYsbGpvxImXKq6l7XwUhxygGN2AXWp/PuruChh3ciC
vxE7I6tRA07d8NVmQNrRRlQVfL+stJP0HLZnosEuIQBj7sBB6lmt1fxxCdHB0gJh
gK6u7TQ6wjeCdqUkzdAP8w9B7Oj0S2Le86m/9d8NIQV3COPu+Sc=
=TB/R
-----END PGP SIGNATURE-----