{"action":"closed","issue":{"url":"https://api.github.com/repos/calzoneman/sync/issues/543","labels_url":"https://api.github.com/repos/calzoneman/sync/issues/543/labels{/name}","comments_url":"https://api.github.com/repos/calzoneman/sync/issues/543/comments","events_url":"https://api.github.com/repos/calzoneman/sync/issues/543/events","html_url":"https://github.com/calzoneman/sync/issues/543","id":122326183,"number":543,"title":"Table creation query fails","user":{"login":"henke37","id":4971363,"avatar_url":"https://avatars.githubusercontent.com/u/4971363?v=3","gravatar_id":"","url":"https://api.github.com/users/henke37","html_url":"https://github.com/henke37","followers_url":"https://api.github.com/users/henke37/followers","following_url":"https://api.github.com/users/henke37/following{/other_user}","gists_url":"https://api.github.com/users/henke37/gists{/gist_id}","starred_url":"https://api.github.com/users/henke37/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/henke37/subscriptions","organizations_url":"https://api.github.com/users/henke37/orgs","repos_url":"https://api.github.com/users/henke37/repos","events_url":"https://api.github.com/users/henke37/events{/privacy}","received_events_url":"https://api.github.com/users/henke37/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-12-15T17:39:55Z","updated_at":"2015-12-22T01:38:54Z","closed_at":"2015-12-22T01:38:54Z","body":"```\r\n! DB query failed: CREATE TABLE IF NOT EXISTS `channel_libraries` (`id` VARCHAR(255) NOT NULL,`title` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL,`seconds` INT NOT NULL,`type` VARCHAR(2) NOT NULL,`meta` TEXT NOT NULL,`channel` VARCHAR(30) NOT NULL,PRIMARY KEY(`id`, `channel`), INDEX(`channel`, `title`)) CHARACTER SET utf8\r\n{ [Error: ER_TOO_LONG_KEY: Specified key was too long; max key length is 1000 bytes]\r\n  code: 'ER_TOO_LONG_KEY',\r\n  errno: 1071,\r\n  sqlState: '42000',\r\n  index: 0 }\r\nDatabase failure\r\n```\r\nI blame mysql for tying key lengths to the locale or something."}}