{"action":"created","issue":{"url":"https://api.github.com/repos/strongloop/loopback/issues/1740","labels_url":"https://api.github.com/repos/strongloop/loopback/issues/1740/labels{/name}","comments_url":"https://api.github.com/repos/strongloop/loopback/issues/1740/comments","events_url":"https://api.github.com/repos/strongloop/loopback/issues/1740/events","html_url":"https://github.com/strongloop/loopback/issues/1740","id":112014789,"number":1740,"title":"automigrate and autoupdate doesn't work for AccssToken if utf8mb4 is used (MySQL / MariaDB)","user":{"login":"danieltrautmann","id":4022138,"avatar_url":"https://avatars.githubusercontent.com/u/4022138?v=3","gravatar_id":"","url":"https://api.github.com/users/danieltrautmann","html_url":"https://github.com/danieltrautmann","followers_url":"https://api.github.com/users/danieltrautmann/followers","following_url":"https://api.github.com/users/danieltrautmann/following{/other_user}","gists_url":"https://api.github.com/users/danieltrautmann/gists{/gist_id}","starred_url":"https://api.github.com/users/danieltrautmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danieltrautmann/subscriptions","organizations_url":"https://api.github.com/users/danieltrautmann/orgs","repos_url":"https://api.github.com/users/danieltrautmann/repos","events_url":"https://api.github.com/users/danieltrautmann/events{/privacy}","received_events_url":"https://api.github.com/users/danieltrautmann/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/strongloop/loopback/labels/triage","name":"triage","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"superkhau","id":1617364,"avatar_url":"https://avatars.githubusercontent.com/u/1617364?v=3","gravatar_id":"","url":"https://api.github.com/users/superkhau","html_url":"https://github.com/superkhau","followers_url":"https://api.github.com/users/superkhau/followers","following_url":"https://api.github.com/users/superkhau/following{/other_user}","gists_url":"https://api.github.com/users/superkhau/gists{/gist_id}","starred_url":"https://api.github.com/users/superkhau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/superkhau/subscriptions","organizations_url":"https://api.github.com/users/superkhau/orgs","repos_url":"https://api.github.com/users/superkhau/repos","events_url":"https://api.github.com/users/superkhau/events{/privacy}","received_events_url":"https://api.github.com/users/superkhau/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2015-10-18T11:30:25Z","updated_at":"2015-11-07T17:31:36Z","closed_at":null,"body":"Hi,\r\n\r\nI created a database with utf8mb4 encoding and tried the automigrate and autoupdate feature.\r\nAll tables were created successfully except the AccessToken table.\r\n\r\nAfter that I turned on the debug mode and saw the following error:\r\n`Specified key was too long; max key length is 767 bytes`\r\n\r\n- Database: MariaDB 10.0.21\r\n- Encoding: utf8mb4\r\n- Collation: utf8mb4_general_ci\r\n- Loopback Version: 2.22.2\r\n\r\nRegards,\r\nDaniel"},"comment":{"url":"https://api.github.com/repos/strongloop/loopback/issues/comments/154726846","html_url":"https://github.com/strongloop/loopback/issues/1740#issuecomment-154726846","issue_url":"https://api.github.com/repos/strongloop/loopback/issues/1740","id":154726846,"user":{"login":"danieltrautmann","id":4022138,"avatar_url":"https://avatars.githubusercontent.com/u/4022138?v=3","gravatar_id":"","url":"https://api.github.com/users/danieltrautmann","html_url":"https://github.com/danieltrautmann","followers_url":"https://api.github.com/users/danieltrautmann/followers","following_url":"https://api.github.com/users/danieltrautmann/following{/other_user}","gists_url":"https://api.github.com/users/danieltrautmann/gists{/gist_id}","starred_url":"https://api.github.com/users/danieltrautmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danieltrautmann/subscriptions","organizations_url":"https://api.github.com/users/danieltrautmann/orgs","repos_url":"https://api.github.com/users/danieltrautmann/repos","events_url":"https://api.github.com/users/danieltrautmann/events{/privacy}","received_events_url":"https://api.github.com/users/danieltrautmann/received_events","type":"User","site_admin":false},"created_at":"2015-11-07T17:31:36Z","updated_at":"2015-11-07T17:31:36Z","body":"@superkhau, @raymondfeng Any updates on this?"}}