New mails are not inserted into the database because of the following error: org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: 1292 org.kde.pim.akonadiserver: DB error: "Incorrect datetime value: '0000-00-00 00:00:00' for column 'datetime' at row 1" org.kde.pim.akonadiserver: Error text: "Incorrect datetime value: '0000-00-00 00:00:00' for column 'datetime' at row 1 QMYSQL3: Unable to execute statement" org.kde.pim.akonadiserver: Query: "INSERT INTO PimItemTable (rev, remoteId, remoteRevision, gid, collectionId, mimeTypeId, datetime, atime, dirty, size) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9)" org.kde.pim.akonadiserver: Error during insertion into table "PimItemTable" "Incorrect datetime value: '0000-00-00 00:00:00' for column 'datetime' at row 1 QMYSQL3: Unable to execute statement" org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Unknown error." org.kde.pim.akonadicore: "Unknown error." org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Failed to append item" org.kde.pim.akonadicore: Error during ItemSync: "Failed to append item"
I am not sure how to vote for the fix - so adding comment as it affects my kmail too.
Confirm the bug Can't retrieve any mail messages I'm using KDE Neon 5.8 KDE Plasma 5.8.4 KDE Frameworks 5.29.0 Qt 5.7.0 Kernel 4.4.0-53-generic x64 $mysql -V mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper
There is a workaround described in bug 373782. *** This bug has been marked as a duplicate of bug 373782 ***