[Akonadi] [Bug 395408] New: DATABASE ERROR: Error code: "1064"
John Apple II
bugzilla_noreply at kde.org
Fri Jun 15 05:44:24 BST 2018
https://bugs.kde.org/show_bug.cgi?id=395408
Bug ID: 395408
Summary: DATABASE ERROR: Error code: "1064"
Product: Akonadi
Version: 5.7.2
Platform: Fedora RPMs
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: IMAP resource
Assignee: kdepim-bugs at kde.org
Reporter: jappleii at redhat.com
Target Milestone: ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list