{"action":"created","issue":{"url":"https://api.github.com/repos/modxcms/revolution/issues/12990","repository_url":"https://api.github.com/repos/modxcms/revolution","labels_url":"https://api.github.com/repos/modxcms/revolution/issues/12990/labels{/name}","comments_url":"https://api.github.com/repos/modxcms/revolution/issues/12990/comments","events_url":"https://api.github.com/repos/modxcms/revolution/issues/12990/events","html_url":"https://github.com/modxcms/revolution/pull/12990","id":151560750,"number":12990,"title":"fixed #12987","user":{"login":"sottwell","id":1073780,"avatar_url":"https://avatars.githubusercontent.com/u/1073780?v=3","gravatar_id":"","url":"https://api.github.com/users/sottwell","html_url":"https://github.com/sottwell","followers_url":"https://api.github.com/users/sottwell/followers","following_url":"https://api.github.com/users/sottwell/following{/other_user}","gists_url":"https://api.github.com/users/sottwell/gists{/gist_id}","starred_url":"https://api.github.com/users/sottwell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sottwell/subscriptions","organizations_url":"https://api.github.com/users/sottwell/orgs","repos_url":"https://api.github.com/users/sottwell/repos","events_url":"https://api.github.com/users/sottwell/events{/privacy}","received_events_url":"https://api.github.com/users/sottwell/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/modxcms/revolution/labels/area-core","name":"area-core","color":"ededed"},{"url":"https://api.github.com/repos/modxcms/revolution/labels/bug","name":"bug","color":"fbca04"},{"url":"https://api.github.com/repos/modxcms/revolution/labels/priority-1-urgent","name":"priority-1-urgent","color":"e11d21"},{"url":"https://api.github.com/repos/modxcms/revolution/labels/state/in-progress","name":"state/in-progress","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":23,"created_at":"2016-04-28T06:37:24Z","updated_at":"2016-05-04T06:53:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/modxcms/revolution/pulls/12990","html_url":"https://github.com/modxcms/revolution/pull/12990","diff_url":"https://github.com/modxcms/revolution/pull/12990.diff","patch_url":"https://github.com/modxcms/revolution/pull/12990.patch"},"body":"### What does it do?\r\nModifed schemas in modx.mysql.schema.xml to have default values for NOT NULL date and date/time fields. Some datetime fields had a default string value that was rejected, changed them to an empty string.\r\n\r\n### Why is it needed?\r\nInstallation fails when STRICT_TRANS_TABLES is configured\r\n\r\n### Related issue(s)/PR(s)\r\nFixes #12987 \r\n\r\nAdded default values to various date fields set to be NOT NULL, changed some datetime fields to default to an empty string.\r\nNeeds to be tested by someone with STRICT_TRANS_TABLES configured."},"comment":{"url":"https://api.github.com/repos/modxcms/revolution/issues/comments/216760581","html_url":"https://github.com/modxcms/revolution/pull/12990#issuecomment-216760581","issue_url":"https://api.github.com/repos/modxcms/revolution/issues/12990","id":216760581,"user":{"login":"thewhiterabbit","id":5334222,"avatar_url":"https://avatars.githubusercontent.com/u/5334222?v=3","gravatar_id":"","url":"https://api.github.com/users/thewhiterabbit","html_url":"https://github.com/thewhiterabbit","followers_url":"https://api.github.com/users/thewhiterabbit/followers","following_url":"https://api.github.com/users/thewhiterabbit/following{/other_user}","gists_url":"https://api.github.com/users/thewhiterabbit/gists{/gist_id}","starred_url":"https://api.github.com/users/thewhiterabbit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thewhiterabbit/subscriptions","organizations_url":"https://api.github.com/users/thewhiterabbit/orgs","repos_url":"https://api.github.com/users/thewhiterabbit/repos","events_url":"https://api.github.com/users/thewhiterabbit/events{/privacy}","received_events_url":"https://api.github.com/users/thewhiterabbit/received_events","type":"User","site_admin":false},"created_at":"2016-05-04T06:53:17Z","updated_at":"2016-05-04T06:53:17Z","body":"No, wait according to the documentation @sottwell is correct. Setting a default value should fix the problem. I would use '0000-00-00 00:00:00' or NULL as the default and then set the table to ON UPDATE CURRENT_TIMESTAMP where applicable. That should work."}}