{"action":"created","issue":{"url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81","repository_url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql","labels_url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81/labels{/name}","comments_url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81/comments","events_url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81/events","html_url":"https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81","id":182316792,"number":81,"title":"Specified key was too long; max key length is 767 bytes","user":{"login":"farajfarook","id":6462664,"avatar_url":"https://avatars.githubusercontent.com/u/6462664?v=3","gravatar_id":"","url":"https://api.github.com/users/farajfarook","html_url":"https://github.com/farajfarook","followers_url":"https://api.github.com/users/farajfarook/followers","following_url":"https://api.github.com/users/farajfarook/following{/other_user}","gists_url":"https://api.github.com/users/farajfarook/gists{/gist_id}","starred_url":"https://api.github.com/users/farajfarook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/farajfarook/subscriptions","organizations_url":"https://api.github.com/users/farajfarook/orgs","repos_url":"https://api.github.com/users/farajfarook/repos","events_url":"https://api.github.com/users/farajfarook/events{/privacy}","received_events_url":"https://api.github.com/users/farajfarook/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":12,"created_at":"2016-10-11T16:51:14Z","updated_at":"2016-12-02T11:42:38Z","closed_at":"2016-10-11T18:52:42Z","body":"### Steps to reproduce\n1. Create a Visual Studio dotnet core project with single authentication\n2. Change the SQL Server settings to MySQL using Pomela\n3. Execute `dotnet ef database update`\n4. Error will occur **Specified key was too long; max key length is 767 bytes**\n### The issue\n\nUTF8 only accepts 767 chars.  Need `character set to latin1 collate latin1_general_ci`\n\n```\nException message:\nStack trace:\nMySql.Data.MySqlClient.MySqlException: Specified key was too long; max key length is 767 bytes\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\n   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult()\n   at MySql.Data.MySqlClient.MySqlDataReader.<ReadResultSetHeaderAsync>d__56.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at MySql.Data.MySqlClient.MySqlDataReader.<CreateAsync>d__50.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at MySql.Data.MySqlClient.MySqlCommand.<ExecuteReaderAsync>d__50.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at MySql.Data.MySqlClient.MySqlCommand.<ExecuteNonQueryAsync>d__46.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\n   at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlRelationalCommand.<ExecuteAsync>d__3.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlRelationalCommand.Execute(IRelationalConnection connection, String executeMethod, IReadOnlyDictionary`2 parameterValues, Boolean openConnection, Boolean closeConnection)\n   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues, Boolean manageConnection)\n   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)\n   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)\n   at Microsoft.EntityFrameworkCore.Design.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)\n   at Microsoft.EntityFrameworkCore.Tools.Cli.DatabaseUpdateCommand.<>c__DisplayClass0_0.<Configure>b__0()\n   at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args)\n   at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String[] args)\nSpecified key was too long; max key length is 767 bytes\n```\n"},"comment":{"url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/comments/264436423","html_url":"https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81#issuecomment-264436423","issue_url":"https://api.github.com/repos/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/81","id":264436423,"user":{"login":"Mats391","id":868580,"avatar_url":"https://avatars.githubusercontent.com/u/868580?v=3","gravatar_id":"","url":"https://api.github.com/users/Mats391","html_url":"https://github.com/Mats391","followers_url":"https://api.github.com/users/Mats391/followers","following_url":"https://api.github.com/users/Mats391/following{/other_user}","gists_url":"https://api.github.com/users/Mats391/gists{/gist_id}","starred_url":"https://api.github.com/users/Mats391/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mats391/subscriptions","organizations_url":"https://api.github.com/users/Mats391/orgs","repos_url":"https://api.github.com/users/Mats391/repos","events_url":"https://api.github.com/users/Mats391/events{/privacy}","received_events_url":"https://api.github.com/users/Mats391/received_events","type":"User","site_admin":false},"created_at":"2016-12-02T11:42:38Z","updated_at":"2016-12-02T11:42:38Z","body":"Did EnsureCreated() and it created the schema w/o printing any errors. The context works fine, but it works with migrations as well. The only issue I have is that I cannot apply any migrations after the first as the history is empty. \r\nEnsureCreated() just skips the history completely, so I guess that is why it does not print any errors."}}
{"actor":{"display_login":"Mats391"}}