Le vendredi 28 juin 2019 12:10:43 CEST Oliver Jaksch via arch-general a écrit : > The solution found at https://bbs.archlinux.org/viewtopic.php?id=184192 > fixed 'em all. Just a sidenote. New users just can't use akonadi with this new mysql. Create a new user with an empty home directory, login and start akonadi in a console, there are tons of errors like : ... org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1452" org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelatio n`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDAT E CASCADE)" org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelati on`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDA TE CASCADE) QMYSQL3: Unable to execute statement" org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 2))(":1", QVariant(qlonglong, 2))) org.kde.pim.akonadiserver: Query: "INSERT INTO CollectionMimeTypeRelation (Collection_id, MimeType_id) VALUES (:0, :1)" org.kde.pim.akonadiserver: Error during adding a record to table "CollectionMimeTypeRelation" org.kde.pim.akonadiserver: Failed to append mimetype "application/x- vnd.akonadi.calendar.event" to Collection 2 org.kde.pim.akonadiserver: Failed to append mimetypes ("application/x- vnd.akonadi.calendar.event") to new collection "Birthdays & Anniversaries " (ID 2 ) in resource "akonadi_birthdays_resource" org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_birthdays_resource (0x56188ad4b440) org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1452" ... Until KDE devs consider this newer version of mysql. Regards.
