Interesting...just tried that with my wife's account she never used on my box: I've started _kontact_, which askes users account detail an so on. After finishing that I receive the same errors - but if I use the 2nd "fix" of the given URL then, and after restarting akonadi (akonadictl restart), everything is up and okay. In short: # mysql --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket -e 'create database mysql' # mysql_upgrade --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket # akonadictl restart And yes, this should by fixed by the kde devs, definitively. On Sunday, 30 June 2019, 10:51:36 CEST you wrote:
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.