[Akonadi] [Bug 333736] Akonadi server doesn't start (internal Mysql backend)

[Hatl]

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

--- Comment #8 from Hatl <hatl at 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.