https://bugs.kde.org/show_bug.cgi?id=333736
--- Comment #8 from Hatl <h...@gmx.net> --- Sql error: Can't create table 'akonadi.tagremoteidresourcerelationtable' (errno: 150) QMYSQL: Unable to execute query Query: CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, resourceId BIGINT NOT NULL, remoteId VARBINARY(255) NOT NULL, FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" The query works when I remove FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE ResourceTable exists (show create table ResourceTable;) CREATE TABLE `resourcetable` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varbinary(255) DEFAULT NULL, `isVirtual` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `name_2` (`name`), UNIQUE KEY `name_3` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 myisamchk can't find any errors. -- 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
