{"action":"created","issue":{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865","labels_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/labels{/name}","comments_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/comments","events_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/events","html_url":"https://github.com/Cockatrice/Cockatrice/issues/865","id":63420291,"number":865,"title":"Server db schema is broken in mysql strict mode","user":{"login":"Daenyth","id":14644,"avatar_url":"https://avatars.githubusercontent.com/u/14644?v=3","gravatar_id":"","url":"https://api.github.com/users/Daenyth","html_url":"https://github.com/Daenyth","followers_url":"https://api.github.com/users/Daenyth/followers","following_url":"https://api.github.com/users/Daenyth/following{/other_user}","gists_url":"https://api.github.com/users/Daenyth/gists{/gist_id}","starred_url":"https://api.github.com/users/Daenyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Daenyth/subscriptions","organizations_url":"https://api.github.com/users/Daenyth/orgs","repos_url":"https://api.github.com/users/Daenyth/repos","events_url":"https://api.github.com/users/Daenyth/events{/privacy}","received_events_url":"https://api.github.com/users/Daenyth/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/labels/Servatrice","name":"Servatrice","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-21T15:51:29Z","updated_at":"2015-07-04T00:37:04Z","closed_at":null,"body":"http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_strict_trans_tables\r\n\r\nLots of non-null columns treated as if they have a default value. We'll have to add a default or make them non-null and make sure the server handles it appropriately"},"comment":{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/comments/118446129","html_url":"https://github.com/Cockatrice/Cockatrice/issues/865#issuecomment-118446129","issue_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865","id":118446129,"user":{"login":"woogerboy21","id":1361287,"avatar_url":"https://avatars.githubusercontent.com/u/1361287?v=3","gravatar_id":"","url":"https://api.github.com/users/woogerboy21","html_url":"https://github.com/woogerboy21","followers_url":"https://api.github.com/users/woogerboy21/followers","following_url":"https://api.github.com/users/woogerboy21/following{/other_user}","gists_url":"https://api.github.com/users/woogerboy21/gists{/gist_id}","starred_url":"https://api.github.com/users/woogerboy21/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woogerboy21/subscriptions","organizations_url":"https://api.github.com/users/woogerboy21/orgs","repos_url":"https://api.github.com/users/woogerboy21/repos","events_url":"https://api.github.com/users/woogerboy21/events{/privacy}","received_events_url":"https://api.github.com/users/woogerboy21/received_events","type":"User","site_admin":false},"created_at":"2015-07-04T00:37:04Z","updated_at":"2015-07-04T00:37:04Z","body":"Currently the work around is to edit your my.ini file and change the sql-mode line removing the \"STRICT_TRANS_TABLES\" portion of the line and restarting the MySQL service.\r\n\r\nIn Linux you can find the my.ini / my.cnf file under:  /etc/\r\nIn Windows you can find the my.ini file under: %PROGRAMDATA%\\MySQL\\MySQL Server 5.6\\"}}