[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 Daniel Vrátil dvra...@redhat.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||dvra...@redhat.com Resolution|--- |INVALID --- Comment #13 from Daniel Vrátil dvra...@redhat.com --- The CollectionTable has been indeed updated in 1.9.0, the updater should have taken care of it on first start, but it had probably failed, corrupting the table (for a reason we will never find out). Please follow the in the wiki link in comment #12 to reset your Akonadi database. If you run into the corruption again, please reopen this bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #12 from Chao Feng rainofch...@gmail.com --- Could you check if https://wiki.archlinux.org/index.php/KDE#Clean_akonadi_configuration_to_fix_kmail fix your problem. Your local database is corrupted during upgrading. Yes, it is indeed a bug. But if clean old configuration fix your problem, at least you could use it again. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 karaluh kara...@karaluh.pl changed: What|Removed |Added Severity|normal |grave --- Comment #11 from karaluh kara...@karaluh.pl --- Still not fixed in 4.11 -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #10 from karaluh kara...@karaluh.pl --- (In reply to comment #9) Did you check the result of a newly created user? Yes, it works, however I cannot recreate the table obviously. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #8 from karaluh kara...@karaluh.pl --- (In reply to comment #7) Run akonadiconsole, Failed to connect to database: Can't connect to local MySQL server through socket '/home/kjedrzejczyk/.local/share/akonadi/socket-ubuntu/mysql.socket' (2) QMYSQL: Unable to connect The socket file I have is akonadiserver.socket. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #9 from Chao Feng rainofch...@gmail.com --- Did you check the result of a newly created user? -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #6 from karaluh kara...@karaluh.pl --- (In reply to comment #5) Which mysql did you use, internal or external? Internal. Did you set case sensitivity manually? Have a look at bug 220007. No, i did not. Also, the bug was fixed in 2009. And can you check the mysql table manually, if the table not exist or has different case? How can I do that? -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #7 from Chao Feng rainofch...@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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 Chao Feng rainofch...@gmail.com changed: What|Removed |Added CC||rainofch...@gmail.com --- Comment #5 from Chao Feng rainofch...@gmail.com --- Which mysql did you use, internal or external? Did you set case sensitivity manually? Have a look at bug 220007. And can you check the mysql table manually, if the table not exist or has different case? -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #4 from karaluh kara...@karaluh.pl --- Still not fixed in 4.10.2 -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #3 from karaluh kara...@karaluh.pl --- Created attachment 77938 -- https://bugs.kde.org/attachment.cgi?id=77938action=edit akonadictl start karol@ubuntu:~$ akonadictl --version Akonadi 1.9.0 -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #2 from Christophe Giboudeaux cgiboude...@gmx.com --- please attach the output of 'akonadictl start' and 'akonadictl --version' -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 314514] akonadi.collectiontable doesn't exist
https://bugs.kde.org/show_bug.cgi?id=314514 --- Comment #1 from karaluh kara...@karaluh.pl --- Not fixed in 4.10.1 -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs