Bug 320859

Summary:	Can't delete emails
Product:	[Frameworks and Libraries] Akonadi	Reporter:	Mike Williams <mawilliams>
Component:	general	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED UNMAINTAINED
Severity:	normal
Priority:	NOR
Version:	4.10
Target Milestone:	---
Platform:	Gentoo Packages
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Mike Williams 2013-06-07 12:07:09 UTC

Seemingly at random after using Kontact for a few minutes to a few hours I can no longer delete emails.
Also the status bar will start to say that email expiry failed.

Closing and opening Kontact always fixes the problem.

The following is printed to .xsession-errors for every deletion attempt.

Error during executing query "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.subscribed, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts, CollectionTable.queryString, CollectionTable.queryLanguage, CollectionTable.isVirtual FROM CollectionTable WHERE ( ( CollectionTable.id = :0 ) )" :  "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 ':0 ) )' at line 1 QMYSQL: Unable to execute query"
kontact(5365) showJobError: There is no GUI delegate set for a kjob, and it failed with error: "Unable to execute query" 


Reproducible: Always

Comment 1 Denis Kurz 2016-09-24 20:36:23 UTC

This bug has only been reported for versions older than KDEPIM 4.14 (at most akonadi-1.3). Can anyone tell if this bug still present?

If noone confirms this bug for a recent version of akonadi (part of KDE Applications 15.08 or later), it gets closed in about three months.

Comment 2 Denis Kurz 2017-01-07 21:39:34 UTC

Just as announced in my last comment, I close this bug. If you encounter it again in a recent version (at least 5.0 aka 15.08), please open a new one unless it already exists. Thank you for all your input.