[Akonadi] [Bug 395408] New: DATABASE ERROR: Error code: "1064"

[John Apple II]

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.