https://bugs.kde.org/show_bug.cgi?id=314514
--- Comment #7 from Chao Feng <[email protected]> --- Run akonadiconsole, in tab "DB console" bottom edit box, Enter "show tables". Check if collectiontable table exist. It seems your database is corrupted. Could you check if it works if you create a new KDE user? If it works. You can in DB console, run "show create table collectiontable;" command. It will generate a database creation command. Run the command to create the table. My table here is as below. But My akondi version is 1.9.2. So it maybe different with yours. "CREATE TABLE `collectiontable` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `remoteId` varbinary(255) DEFAULT NULL, `remoteRevision` varbinary(255) DEFAULT NULL, `name` varbinary(255) NOT NULL, `parentId` bigint(20) DEFAULT NULL, `resourceId` bigint(20) NOT NULL, `subscribed` tinyint(1) NOT NULL DEFAULT '1', `cachePolicyInherit` tinyint(1) NOT NULL DEFAULT '1', `cachePolicyCheckInterval` int(11) NOT NULL DEFAULT '-1', `cachePolicyCacheTimeout` int(11) NOT NULL DEFAULT '-1', `cachePolicySyncOnDemand` tinyint(1) NOT NULL DEFAULT '0', `cachePolicyLocalParts` varbinary(255) DEFAULT NULL, `queryString` varbinary(32768) DEFAULT NULL, `queryLanguage` varbinary(255) DEFAULT NULL, `isVirtual` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `CollectionTable_parentAndNameIndex` (`parentId`,`name`), KEY `resourceId` (`resourceId`), CONSTRAINT `collectiontable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `collectiontable_ibfk_2` FOREIGN KEY (`resourceId`) REFERENCES `resourcetable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list [email protected] https://mail.kde.org/mailman/listinfo/kdepim-bugs
