Version: 1.2.80 (using KDE 4.3.4) Compiler: gcc version 4.4.2 (Gentoo 4.4.2 p1.0) OS: Linux Installed from: Gentoo Packages In server/src/storage/dbupdate.xml the line "UPDATE collectiontable SET parentId = NULL WHERE parentId = 0;" should be "UPDATE CollectionTable SET parentId = NULL WHERE parentId = 0;" (capitalized words), otherwise the server dies with : [akonadiserver] DbUpdater: update to version: 13 mandatory: true code: "UPDATE collectiontable SET parentId = NULL WHERE parentId = 0; [akonadiserver] ALTER TABLE CollectionTable CHANGE parentId parentId BIGINT DEFAULT NULL;" [akonadiserver] DBUpdater: query error: "Table 'akonadi.collectiontable' doesn't exist QMYSQL: Unable to execute query" " " [akonadiserver] Query was: "UPDATE collectiontable SET parentId = NULL WHERE parentId = 0; [akonadiserver] ALTER TABLE CollectionTable CHANGE parentId parentId BIGINT DEFAULT NULL;"
akonadi_control --version Akonadi 1.2.80 kde4-config --version Qt: 4.6.0 KDE: 4.3.90 (KDE 4.3.90 (KDE 4.4 RC1)) kde4-config: 1.0 (This versions are from Launchpad Kubuntu Updates beta https://launchpad.net/~kubuntu-ppa/+archive/beta) After manualy creating the table written in lower-case 'collectiontable', the update went through, and Akonadi is able to start. sudo akonadi_control [akonadiserver] QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DbInitializer::run() [akonadiserver] checking table "SchemaVersionTable" [akonadiserver] checking table "ResourceTable" [akonadiserver] checking table "CollectionTable" [akonadiserver] checking table "MimeTypeTable" [akonadiserver] checking table "PimItemTable" [akonadiserver] checking table "FlagTable" [akonadiserver] checking table "PartTable" [akonadiserver] checking table "CollectionAttributeTable" [akonadiserver] checking relation "PimItemFlagRelation" [akonadiserver] checking relation "CollectionMimeTypeRelation" [akonadiserver] checking relation "CollectionPimItemRelation" [akonadiserver] DbInitializer::run() done [akonadiserver] skipping update 2 [akonadiserver] skipping update 3 [akonadiserver] skipping update 4 [akonadiserver] skipping update 8 [akonadiserver] skipping update 10 [akonadiserver] skipping update 12 [akonadiserver] DbUpdater: update to version: 13 mandatory: true code: "UPDATE collectiontable SET parentId = NULL WHERE parentId = 0; [akonadiserver] ALTER TABLE CollectionTable CHANGE parentId parentId BIGINT DEFAULT NULL;" [akonadiserver] DBUpdater: query error: "Table 'akonadi.collectiontable' doesn't exist QMYSQL: Unable to execute query" " " [akonadiserver] Query was: "UPDATE collectiontable SET parentId = NULL WHERE parentId = 0; [akonadiserver] ALTER TABLE CollectionTable CHANGE parentId parentId BIGINT DEFAULT NULL;" [akonadiserver] Target version was: 13 [akonadiserver] Mandatory: true [akonadiserver] Failed to commit transaction for database update [akonadiserver] Unable to initialize database. [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b2a9] [akonadiserver] 1: akonadiserver [0x40b7f2] [akonadiserver] 2: /lib/libc.so.6 [0x7fb11e259530] [akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fb11e2594b5] [akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fb11e25cf50] [akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fb11f423754] [akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c8b8] [akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7fb11f4b2f28] [akonadiserver] 8: /usr/lib/libQtCore.so.4 [0x7fb11f4c4a19] [akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fb11f4c5b6b] [akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x406f1e] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5fa) [0x7fb11f89499a] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7fb11f89573a] [akonadiserver] 13: akonadiserver(main+0x3b8) [0x406548] [akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fb11e244abd] [akonadiserver] 15: akonadiserver [0x406099] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
Maybe of help also: mysql --version mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (x86_64) using EditLine wrapper
This is fixed as of https://bugs.kde.org/show_bug.cgi?id=220007 would someone close this bug report, please.
*** This bug has been marked as a duplicate of bug 220007 ***