{"action":"created","issue":{"url":"https://api.github.com/repos/RNGR/Directus/issues/395","labels_url":"https://api.github.com/repos/RNGR/Directus/issues/395/labels{/name}","comments_url":"https://api.github.com/repos/RNGR/Directus/issues/395/comments","events_url":"https://api.github.com/repos/RNGR/Directus/issues/395/events","html_url":"https://github.com/RNGR/Directus/issues/395","id":26195943,"number":395,"title":"STRICT_TRANS_TABLES and stricter typing","user":{"login":"coolov","id":2272019,"avatar_url":"https://avatars.githubusercontent.com/u/2272019?v=3","gravatar_id":"","url":"https://api.github.com/users/coolov","html_url":"https://github.com/coolov","followers_url":"https://api.github.com/users/coolov/followers","following_url":"https://api.github.com/users/coolov/following{/other_user}","gists_url":"https://api.github.com/users/coolov/gists{/gist_id}","starred_url":"https://api.github.com/users/coolov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coolov/subscriptions","organizations_url":"https://api.github.com/users/coolov/orgs","repos_url":"https://api.github.com/users/coolov/repos","events_url":"https://api.github.com/users/coolov/events{/privacy}","received_events_url":"https://api.github.com/users/coolov/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/RNGR/Directus/labels/minor","name":"minor","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"WellingGuzman","id":1531291,"avatar_url":"https://avatars.githubusercontent.com/u/1531291?v=3","gravatar_id":"","url":"https://api.github.com/users/WellingGuzman","html_url":"https://github.com/WellingGuzman","followers_url":"https://api.github.com/users/WellingGuzman/followers","following_url":"https://api.github.com/users/WellingGuzman/following{/other_user}","gists_url":"https://api.github.com/users/WellingGuzman/gists{/gist_id}","starred_url":"https://api.github.com/users/WellingGuzman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WellingGuzman/subscriptions","organizations_url":"https://api.github.com/users/WellingGuzman/orgs","repos_url":"https://api.github.com/users/WellingGuzman/repos","events_url":"https://api.github.com/users/WellingGuzman/events{/privacy}","received_events_url":"https://api.github.com/users/WellingGuzman/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/RNGR/Directus/milestones/1","html_url":"https://github.com/RNGR/Directus/milestones/Current%20Release","labels_url":"https://api.github.com/repos/RNGR/Directus/milestones/1/labels","id":228948,"number":1,"title":"Current Release","description":"Public release","creator":{"login":"RNGR","id":1563261,"avatar_url":"https://avatars.githubusercontent.com/u/1563261?v=3","gravatar_id":"","url":"https://api.github.com/users/RNGR","html_url":"https://github.com/RNGR","followers_url":"https://api.github.com/users/RNGR/followers","following_url":"https://api.github.com/users/RNGR/following{/other_user}","gists_url":"https://api.github.com/users/RNGR/gists{/gist_id}","starred_url":"https://api.github.com/users/RNGR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RNGR/subscriptions","organizations_url":"https://api.github.com/users/RNGR/orgs","repos_url":"https://api.github.com/users/RNGR/repos","events_url":"https://api.github.com/users/RNGR/events{/privacy}","received_events_url":"https://api.github.com/users/RNGR/received_events","type":"Organization","site_admin":false},"open_issues":28,"closed_issues":447,"state":"open","created_at":"2012-12-13T01:31:51Z","updated_at":"2015-07-20T02:16:37Z","due_on":"2015-09-01T04:00:00Z","closed_at":null},"comments":9,"created_at":"2014-01-23T20:32:01Z","updated_at":"2015-07-20T02:17:00Z","closed_at":null,"body":"I have enabled [STRICT_TRANS_TABLES](http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_strict_trans_tables) on my local machine and get all sorts of errors from directus. \r\n\r\nSTRICT_TRANS_TABLES enforces strict typing, if for example '9' is written to an int column an error is thrown. We need to make sure that every INSERT and UPDATE respects the datatypes of the columns."},"comment":{"url":"https://api.github.com/repos/RNGR/Directus/issues/comments/122730884","html_url":"https://github.com/RNGR/Directus/issues/395#issuecomment-122730884","issue_url":"https://api.github.com/repos/RNGR/Directus/issues/395","id":122730884,"user":{"login":"benhaynes","id":522079,"avatar_url":"https://avatars.githubusercontent.com/u/522079?v=3","gravatar_id":"","url":"https://api.github.com/users/benhaynes","html_url":"https://github.com/benhaynes","followers_url":"https://api.github.com/users/benhaynes/followers","following_url":"https://api.github.com/users/benhaynes/following{/other_user}","gists_url":"https://api.github.com/users/benhaynes/gists{/gist_id}","starred_url":"https://api.github.com/users/benhaynes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benhaynes/subscriptions","organizations_url":"https://api.github.com/users/benhaynes/orgs","repos_url":"https://api.github.com/users/benhaynes/repos","events_url":"https://api.github.com/users/benhaynes/events{/privacy}","received_events_url":"https://api.github.com/users/benhaynes/received_events","type":"User","site_admin":false},"created_at":"2015-07-20T02:17:00Z","updated_at":"2015-07-20T02:17:00Z","body":"Cool, thanks for the update!"}}