Bug 395408

Summary:	DATABASE ERROR: Error code: "1064"
Product:	[Frameworks and Libraries] Akonadi	Reporter:	John Apple II <jappleii>
Component:	IMAP resource	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal
Priority:	NOR
Version:	5.7.2
Target Milestone:	---
Platform:	Fedora RPMs
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description John Apple II 2018-06-15 04:44:24 UTC

I've obtained a similar error on Fedora 28 x86_64 to bug 342866, same issue - large IMAP folder.  It first started when I tried to select 7 e-mails and move into a folder.  Afterwards, KMail and Akonadi hung, and when I restarted akonadi via akonadictl, these errors began showing.

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 MariaDB 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 MariaDB 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 215
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 MariaDB 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 MariaDB 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 )"


versions are:

$ akonadictl --version      
akonadictl 5.7.3

$ kmail --version
kmail2 5.7.3

$ rpm -qa | grep mariadb-10
mariadb-10.2.14-1.fc28.x86_64

$ uname -a
Linux myhost 4.16.14-300.fc28.x86_64 #1 SMP Tue Jun 5 16:23:44 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

Comment 1 Justin Zobel 2022-11-26 00:13:46 UTC

Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!

Comment 2 John Apple II 2022-11-28 04:28:49 UTC

Hi, Justin,

  Since this occurred I had to stop using Akonadi and KMail as I could fulfill my role with the errors, and I had to switch to Evolution for email.  I'll see if I can try Kmail and Akonadi again and attempt to reproduce, but it's probably reasonable to close this ticket due to its age as there's not much we can do with the change we've had in KDE.

Comment 3 Bug Janitor Service 2022-12-13 05:09:36 UTC

Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!

Comment 4 Bug Janitor Service 2022-12-28 05:26:20 UTC

This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!