[Akonadi] [Bug 318224] Tries to insert existing entries into database

[Chris Samuel]

https://bugs.kde.org/show_bug.cgi?id=318224

Chris Samuel <kde at csamuel.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kde at csamuel.org

--- Comment #5 from Chris Samuel <kde at csamuel.org> ---
I am getting:

ARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323043'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323207'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323405'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323483'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323484'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323485'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-323486'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-324801'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-324939'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"
Error during executing query "INSERT INTO CollectionPimItemRelation
(Collection_id, PimItem_id) VALUES (:0, :1)" :  "Duplicate entry '1116-325025'
for key 'PRIMARY' QMYSQL3: Unable to execute statement"

If in Akonadi Console DB Console I execute:

SELECT collectionTable.name, resourceTable.name FROM collectionTable INNER JOIN
resourceTable ON collectionTable.resourceId = resourceTable.id  WHERE
collectionTable.id = 1116;

I see:

1 Last Search akonadi_search_resource

This is with KDE 4.12 from the Kubuntu KDE backports PPA.

Akonadi Console
Version 0.99
Using KDE Development Platform 4.12.0

-- 
You are receiving this mail because:
You are the assignee for the bug.