{"action":"created","issue":{"url":"https://api.github.com/repos/drud/ddev/issues/654","repository_url":"https://api.github.com/repos/drud/ddev","labels_url":"https://api.github.com/repos/drud/ddev/issues/654/labels{/name}","comments_url":"https://api.github.com/repos/drud/ddev/issues/654/comments","events_url":"https://api.github.com/repos/drud/ddev/issues/654/events","html_url":"https://github.com/drud/ddev/issues/654","id":297769763,"number":654,"title":"\"Index column size too large\" MySQL error when importing TYPO3 DB","user":{"login":"tmotyl","id":515397,"avatar_url":"https://avatars1.githubusercontent.com/u/515397?v=4","gravatar_id":"","url":"https://api.github.com/users/tmotyl","html_url":"https://github.com/tmotyl","followers_url":"https://api.github.com/users/tmotyl/followers","following_url":"https://api.github.com/users/tmotyl/following{/other_user}","gists_url":"https://api.github.com/users/tmotyl/gists{/gist_id}","starred_url":"https://api.github.com/users/tmotyl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmotyl/subscriptions","organizations_url":"https://api.github.com/users/tmotyl/orgs","repos_url":"https://api.github.com/users/tmotyl/repos","events_url":"https://api.github.com/users/tmotyl/events{/privacy}","received_events_url":"https://api.github.com/users/tmotyl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-02-16T12:29:12Z","updated_at":"2018-02-28T12:38:18Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"## What happened (or feature request):\r\nWhen importing db dump of the TYPO3 9 I've got mysql error:\r\n\r\n\"Index column size too large. The maximum column size is 767 bytes.\"\r\nAn example failing query is:\r\n```\r\nCREATE TABLE sys_file_processedfile (\r\nuid int(11) NOT NULL auto_increment,\r\ntstamp int(11) NOT NULL default '0',\r\ncrdate int(11) NOT NULL default '0',\r\nstorage int(11) NOT NULL default '0',\r\noriginal int(11) NOT NULL default '0',\r\nidentifier varchar(512) NOT NULL default '',\r\nname tinytext,\r\nconfiguration text,\r\nconfigurationsha1 char(40) NOT NULL default '',\r\noriginalfilesha1 char(40) NOT NULL default '',\r\ntask_type varchar(200) NOT NULL default '',\r\nchecksum char(10) NOT NULL default '',\r\nwidth int(11) default '0',\r\nheight int(11) default '0',\r\nPRIMARY KEY (uid),\r\nKEY combined_1 (original,task_type,configurationsha1),\r\nKEY identifier (storage,identifier(199))\r\n);\r\n```\r\nError:\r\nIndex column size too large. The maximum column size is 767 bytes.\r\n\r\nThe same error was reported by user trying to install fresh TYPO3 v7.6. However he reported that installation of the fresh 8.7 or 9 went through (probably because starting from 8.7 TYPO3 adds default charset when creating tables).\r\n\r\n## How to reproduce this:\r\nlog in to ddev mysql, and try to run query from above.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/drud/ddev/issues/comments/369226790","html_url":"https://github.com/drud/ddev/issues/654#issuecomment-369226790","issue_url":"https://api.github.com/repos/drud/ddev/issues/654","id":369226790,"user":{"login":"beathorst","id":212705,"avatar_url":"https://avatars2.githubusercontent.com/u/212705?v=4","gravatar_id":"","url":"https://api.github.com/users/beathorst","html_url":"https://github.com/beathorst","followers_url":"https://api.github.com/users/beathorst/followers","following_url":"https://api.github.com/users/beathorst/following{/other_user}","gists_url":"https://api.github.com/users/beathorst/gists{/gist_id}","starred_url":"https://api.github.com/users/beathorst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beathorst/subscriptions","organizations_url":"https://api.github.com/users/beathorst/orgs","repos_url":"https://api.github.com/users/beathorst/repos","events_url":"https://api.github.com/users/beathorst/events{/privacy}","received_events_url":"https://api.github.com/users/beathorst/received_events","type":"User","site_admin":false},"created_at":"2018-02-28T12:38:18Z","updated_at":"2018-02-28T12:38:18Z","author_association":"NONE","body":"I had the same problem, my dirty workaround is to change it to utf8general_ci with the phpmyadmin. but it would be nice to have a better solution within the config"}}
{"actor":{"display_login":"beathorst"}}