{"action":"created","issue":{"url":"https://api.github.com/repos/sequelize/cli/issues/627","repository_url":"https://api.github.com/repos/sequelize/cli","labels_url":"https://api.github.com/repos/sequelize/cli/issues/627/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/cli/issues/627/comments","events_url":"https://api.github.com/repos/sequelize/cli/issues/627/events","html_url":"https://github.com/sequelize/cli/issues/627","id":304190864,"number":627,"title":"Adding timestamps error (key too long)","user":{"login":"MikeDabrowski","id":17836911,"avatar_url":"https://avatars0.githubusercontent.com/u/17836911?v=4","gravatar_id":"","url":"https://api.github.com/users/MikeDabrowski","html_url":"https://github.com/MikeDabrowski","followers_url":"https://api.github.com/users/MikeDabrowski/followers","following_url":"https://api.github.com/users/MikeDabrowski/following{/other_user}","gists_url":"https://api.github.com/users/MikeDabrowski/gists{/gist_id}","starred_url":"https://api.github.com/users/MikeDabrowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MikeDabrowski/subscriptions","organizations_url":"https://api.github.com/users/MikeDabrowski/orgs","repos_url":"https://api.github.com/users/MikeDabrowski/repos","events_url":"https://api.github.com/users/MikeDabrowski/events{/privacy}","received_events_url":"https://api.github.com/users/MikeDabrowski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-03-11T20:28:13Z","updated_at":"2018-03-17T09:35:43Z","closed_at":null,"author_association":"NONE","body":"<!--\r\n\r\nPlease note this is an issue tracker, not a support forum.\r\nFor general questions, please use StackOverflow or Slack.\r\n\r\nFor bugs, please fill out the template below.\r\n\r\n-->\r\n\r\n## What were you doing?\r\n<!-- Post a minimal, self-contained code sample that reproduces the issue, include config and migration file(s) -->\r\n\r\n```js\r\nnode_modules/.bin/sequelize db:migrate:schema:timestamps:add\r\n```\r\n\r\n## What do you expect to happen?\r\nI expected it to add timestamps to Meta table as instructions says\r\n\r\n## What is actually happening?\r\nBut the output was `ERROR: Specified key was too long; max key length is 767 bytes\r\n`\r\n\r\n\r\n\r\n__Dialect:__ mysql\r\n__Database version:__ 10.1.30-MariaDB-0ubuntu0.17.10.1\r\n__Sequelize CLI version:__ 4.0.0\r\n__Sequelize version:__ 4.35.2\r\n\r\nSequelize CLI [Node: 9.6.1, CLI: 4.0.0, ORM: 4.35.2]\r\n"},"comment":{"url":"https://api.github.com/repos/sequelize/cli/issues/comments/373907180","html_url":"https://github.com/sequelize/cli/issues/627#issuecomment-373907180","issue_url":"https://api.github.com/repos/sequelize/cli/issues/627","id":373907180,"user":{"login":"MikeDabrowski","id":17836911,"avatar_url":"https://avatars0.githubusercontent.com/u/17836911?v=4","gravatar_id":"","url":"https://api.github.com/users/MikeDabrowski","html_url":"https://github.com/MikeDabrowski","followers_url":"https://api.github.com/users/MikeDabrowski/followers","following_url":"https://api.github.com/users/MikeDabrowski/following{/other_user}","gists_url":"https://api.github.com/users/MikeDabrowski/gists{/gist_id}","starred_url":"https://api.github.com/users/MikeDabrowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MikeDabrowski/subscriptions","organizations_url":"https://api.github.com/users/MikeDabrowski/orgs","repos_url":"https://api.github.com/users/MikeDabrowski/repos","events_url":"https://api.github.com/users/MikeDabrowski/events{/privacy}","received_events_url":"https://api.github.com/users/MikeDabrowski/received_events","type":"User","site_admin":false},"created_at":"2018-03-17T09:35:43Z","updated_at":"2018-03-17T09:35:43Z","author_association":"NONE","body":"I finally fixed this by updating to latest mariadb. Unique on create\nvarchar(255) is making it over 767.\n\nOn Sat, Mar 17, 2018, 08:14 Kyle Klein <notifications@github.com> wrote:\n\n> This is happening for me too:\n>\n> *Dialect*: mysql\n> *Database version*: MySQL 5.6.34\n> *Sequelize CLI version*: 4.0.0\n> *Sequelize version*: 4.36.1\n>\n> ERROR: Specified key was too long; max key length is 767 bytes\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/sequelize/cli/issues/627#issuecomment-373900162>, or mute\n> the thread\n> <https://github.com/notifications/unsubscribe-auth/ARArbz4qxcmExnLNz7eOgTaWtubCaox3ks5tfLfPgaJpZM4Sl19c>\n> .\n>\n"}}
{"actor":{"display_login":"MikeDabrowski"}}