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.
