[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist

[Chao Feng]

https://bugs.kde.org/show_bug.cgi?id=314514

--- Comment #7 from Chao Feng <rainofchaos at gmail.com> ---
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.