{"action":"created","issue":{"url":"https://api.github.com/repos/phanan/koel/issues/552","repository_url":"https://api.github.com/repos/phanan/koel","labels_url":"https://api.github.com/repos/phanan/koel/issues/552/labels{/name}","comments_url":"https://api.github.com/repos/phanan/koel/issues/552/comments","events_url":"https://api.github.com/repos/phanan/koel/issues/552/events","html_url":"https://github.com/phanan/koel/issues/552","id":212545645,"number":552,"title":"Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes","user":{"login":"cllorca","id":571671,"avatar_url":"https://avatars1.githubusercontent.com/u/571671?v=3","gravatar_id":"","url":"https://api.github.com/users/cllorca","html_url":"https://github.com/cllorca","followers_url":"https://api.github.com/users/cllorca/followers","following_url":"https://api.github.com/users/cllorca/following{/other_user}","gists_url":"https://api.github.com/users/cllorca/gists{/gist_id}","starred_url":"https://api.github.com/users/cllorca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cllorca/subscriptions","organizations_url":"https://api.github.com/users/cllorca/orgs","repos_url":"https://api.github.com/users/cllorca/repos","events_url":"https://api.github.com/users/cllorca/events{/privacy}","received_events_url":"https://api.github.com/users/cllorca/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-03-07T20:14:28Z","updated_at":"2017-03-24T13:29:56Z","closed_at":null,"body":"I couldn't find this issue in the troubleshooting section of the documentation, nor could I find it here in the git issue tracker. I followed the steps for installation according to installation guide: https://koel.phanan.net/docs/#/?id=installation \r\n\r\ncomposer.phar executed fine. Then I added my db credentials to .env. Finally when I ran php artisan koel:init' I got the following error which halts the installation as the database seeding fails:\r\n\r\nphp artisan koel:init\r\nAttempting to install or upgrade Koel.\r\nRemember, you can always install/upgrade manually following the guide here:\r\n📙  https://koel.phanan.net/docs\r\n\r\nApp key exists -- skipping\r\nJWT secret exists -- skipping\r\nMigrating database\r\n\r\n                                                                                                                                                                                \r\n  [Illuminate\\Database\\QueryException]                                                                                                                                          \r\n  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`e  \r\n  mail`))                                                                                                                                                                       \r\n                                                                                                                                                                                \r\nphp: php --version\r\nPHP 7.0.15 (cli) (built: Jan 19 2017 21:35:05) ( NTS )\r\nCopyright (c) 1997-2017 The PHP Group\r\nZend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies\r\n    with Zend OPcache v7.0.15, Copyright (c) 1999-2017, by Zend Technologies\r\n[edit: this is on an Ubuntu Linode VPS machine]\r\n\r\n                                                                                                                   \r\n  [PDOException]                                                                                                   \r\n  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes  \r\n                                                                                                                   \r\nAny help would be greatly appreciated. A quick web search said this is likely caused by the database type being InnoDB and not MyISAM? I couldn't find anywhere in the configs to change the db type. "},"comment":{"url":"https://api.github.com/repos/phanan/koel/issues/comments/289022629","html_url":"https://github.com/phanan/koel/issues/552#issuecomment-289022629","issue_url":"https://api.github.com/repos/phanan/koel/issues/552","id":289022629,"user":{"login":"cllorca","id":571671,"avatar_url":"https://avatars1.githubusercontent.com/u/571671?v=3","gravatar_id":"","url":"https://api.github.com/users/cllorca","html_url":"https://github.com/cllorca","followers_url":"https://api.github.com/users/cllorca/followers","following_url":"https://api.github.com/users/cllorca/following{/other_user}","gists_url":"https://api.github.com/users/cllorca/gists{/gist_id}","starred_url":"https://api.github.com/users/cllorca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cllorca/subscriptions","organizations_url":"https://api.github.com/users/cllorca/orgs","repos_url":"https://api.github.com/users/cllorca/repos","events_url":"https://api.github.com/users/cllorca/events{/privacy}","received_events_url":"https://api.github.com/users/cllorca/received_events","type":"User","site_admin":false},"created_at":"2017-03-24T13:29:55Z","updated_at":"2017-03-24T13:29:55Z","body":"Thanks for the tips.  I've been offline a few weeks but I'll try and get a fresh vps online and try deploying Koel again. Will report back any success or failure. Thanks \n\n> On Mar 23, 2017, at 2:36 PM, Andy Nguyen <notifications@github.com> wrote:\n> \n> A workaround is to php artisan koel:init\n> v3.5.5 first, then switch to master and then use php artisan koel:init\n> \n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly, view it on GitHub, or mute the thread.\n> \n"}}
{"actor":{"display_login":"cllorca"}}