{"action":"created","issue":{"url":"https://api.github.com/repos/contao/core-bundle/issues/221","labels_url":"https://api.github.com/repos/contao/core-bundle/issues/221/labels{/name}","comments_url":"https://api.github.com/repos/contao/core-bundle/issues/221/comments","events_url":"https://api.github.com/repos/contao/core-bundle/issues/221/events","html_url":"https://github.com/contao/core-bundle/pull/221","id":69170495,"number":221,"title":"Database schema: Specified key was too long","user":{"login":"bytehead","id":754921,"avatar_url":"https://avatars.githubusercontent.com/u/754921?v=3","gravatar_id":"","url":"https://api.github.com/users/bytehead","html_url":"https://github.com/bytehead","followers_url":"https://api.github.com/users/bytehead/followers","following_url":"https://api.github.com/users/bytehead/following{/other_user}","gists_url":"https://api.github.com/users/bytehead/gists{/gist_id}","starred_url":"https://api.github.com/users/bytehead/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bytehead/subscriptions","organizations_url":"https://api.github.com/users/bytehead/orgs","repos_url":"https://api.github.com/users/bytehead/repos","events_url":"https://api.github.com/users/bytehead/events{/privacy}","received_events_url":"https://api.github.com/users/bytehead/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/contao/core-bundle/labels/defect","name":"defect","color":"bd2c00"},{"url":"https://api.github.com/repos/contao/core-bundle/labels/unconfirmed","name":"unconfirmed","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"leofeyer","id":1192057,"avatar_url":"https://avatars.githubusercontent.com/u/1192057?v=3","gravatar_id":"","url":"https://api.github.com/users/leofeyer","html_url":"https://github.com/leofeyer","followers_url":"https://api.github.com/users/leofeyer/followers","following_url":"https://api.github.com/users/leofeyer/following{/other_user}","gists_url":"https://api.github.com/users/leofeyer/gists{/gist_id}","starred_url":"https://api.github.com/users/leofeyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leofeyer/subscriptions","organizations_url":"https://api.github.com/users/leofeyer/orgs","repos_url":"https://api.github.com/users/leofeyer/repos","events_url":"https://api.github.com/users/leofeyer/events{/privacy}","received_events_url":"https://api.github.com/users/leofeyer/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/contao/core-bundle/milestones/1","html_url":"https://github.com/contao/core-bundle/milestones/4.0.0","labels_url":"https://api.github.com/repos/contao/core-bundle/milestones/1/labels","id":748885,"number":1,"title":"4.0.0","description":"Contao 4.0.0 (major release)","creator":{"login":"leofeyer","id":1192057,"avatar_url":"https://avatars.githubusercontent.com/u/1192057?v=3","gravatar_id":"","url":"https://api.github.com/users/leofeyer","html_url":"https://github.com/leofeyer","followers_url":"https://api.github.com/users/leofeyer/followers","following_url":"https://api.github.com/users/leofeyer/following{/other_user}","gists_url":"https://api.github.com/users/leofeyer/gists{/gist_id}","starred_url":"https://api.github.com/users/leofeyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leofeyer/subscriptions","organizations_url":"https://api.github.com/users/leofeyer/orgs","repos_url":"https://api.github.com/users/leofeyer/repos","events_url":"https://api.github.com/users/leofeyer/events{/privacy}","received_events_url":"https://api.github.com/users/leofeyer/received_events","type":"User","site_admin":false},"open_issues":15,"closed_issues":144,"state":"open","created_at":"2014-08-10T18:11:38Z","updated_at":"2015-04-20T08:17:51Z","due_on":"2015-05-25T07:00:00Z","closed_at":null},"comments":11,"created_at":"2015-04-17T16:21:55Z","updated_at":"2015-04-20T09:03:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/contao/core-bundle/pulls/221","html_url":"https://github.com/contao/core-bundle/pull/221","diff_url":"https://github.com/contao/core-bundle/pull/221.diff","patch_url":"https://github.com/contao/core-bundle/pull/221.patch"},"body":"During a fresh install on `contao/install` while creating the tables:\r\n\r\n```\r\nAn exception occurred while executing 'CREATE TABLE `tl_files` (\r\n`id` int(10) unsigned NOT NULL auto_increment,\r\n`pid` binary(16) NULL,\r\n`tstamp` int(10) unsigned NOT NULL default '0',\r\n`uuid` binary(16) NULL,\r\n`type` varchar(16) NOT NULL default '',\r\n`path` varchar(1022) NOT NULL default '',\r\n`extension` varchar(16) NOT NULL default '',\r\n`hash` varchar(32) NOT NULL default '',\r\n`found` char(1) NOT NULL default '1',\r\n`name` varchar(255) NOT NULL default '',\r\n`importantPartX` int(10) NOT NULL default '0',\r\n`importantPartY` int(10) NOT NULL default '0',\r\n`importantPartWidth` int(10) NOT NULL default '0',\r\n`importantPartHeight` int(10) NOT NULL default '0',\r\n`meta` blob NULL,\r\nPRIMARY KEY (`id`),\r\nKEY `pid` (`pid`),\r\nUNIQUE KEY `uuid` (`uuid`),\r\nKEY `path` (`path`),\r\nKEY `extension` (`extension`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;':\r\n\r\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes\r\n```\r\n\r\nIt would acutally work with `varchar(333)` - max key length = 1000 bytes, UTF-8 character uses 3 bytes, so max length of the `varchar` is 333 (see 5fbe4a9).\r\n\r\nWhat's the reason to use `varchar(1022)` for the field `path` ?"},"comment":{"url":"https://api.github.com/repos/contao/core-bundle/issues/comments/94399825","html_url":"https://github.com/contao/core-bundle/pull/221#issuecomment-94399825","issue_url":"https://api.github.com/repos/contao/core-bundle/issues/221","id":94399825,"user":{"login":"leofeyer","id":1192057,"avatar_url":"https://avatars.githubusercontent.com/u/1192057?v=3","gravatar_id":"","url":"https://api.github.com/users/leofeyer","html_url":"https://github.com/leofeyer","followers_url":"https://api.github.com/users/leofeyer/followers","following_url":"https://api.github.com/users/leofeyer/following{/other_user}","gists_url":"https://api.github.com/users/leofeyer/gists{/gist_id}","starred_url":"https://api.github.com/users/leofeyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leofeyer/subscriptions","organizations_url":"https://api.github.com/users/leofeyer/orgs","repos_url":"https://api.github.com/users/leofeyer/repos","events_url":"https://api.github.com/users/leofeyer/events{/privacy}","received_events_url":"https://api.github.com/users/leofeyer/received_events","type":"User","site_admin":false},"created_at":"2015-04-20T09:03:17Z","updated_at":"2015-04-20T09:03:17Z","body":"Yes, we are trying to maintain strict mode compatibility."}}