{"action":"created","issue":{"url":"https://api.github.com/repos/fruux/Baikal/issues/537","repository_url":"https://api.github.com/repos/fruux/Baikal","labels_url":"https://api.github.com/repos/fruux/Baikal/issues/537/labels{/name}","comments_url":"https://api.github.com/repos/fruux/Baikal/issues/537/comments","events_url":"https://api.github.com/repos/fruux/Baikal/issues/537/events","html_url":"https://github.com/fruux/Baikal/pull/537","id":153555331,"number":537,"title":"MySQL date types can't save dates before Unix epoch","user":{"login":"omg1976","id":19141361,"avatar_url":"https://avatars.githubusercontent.com/u/19141361?v=3","gravatar_id":"","url":"https://api.github.com/users/omg1976","html_url":"https://github.com/omg1976","followers_url":"https://api.github.com/users/omg1976/followers","following_url":"https://api.github.com/users/omg1976/following{/other_user}","gists_url":"https://api.github.com/users/omg1976/gists{/gist_id}","starred_url":"https://api.github.com/users/omg1976/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/omg1976/subscriptions","organizations_url":"https://api.github.com/users/omg1976/orgs","repos_url":"https://api.github.com/users/omg1976/repos","events_url":"https://api.github.com/users/omg1976/events{/privacy}","received_events_url":"https://api.github.com/users/omg1976/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/fruux/Baikal/labels/wontfix","name":"wontfix","color":"ffffff"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-06T23:05:30Z","updated_at":"2016-05-13T17:06:22Z","closed_at":"2016-05-12T22:40:45Z","pull_request":{"url":"https://api.github.com/repos/fruux/Baikal/pulls/537","html_url":"https://github.com/fruux/Baikal/pull/537","diff_url":"https://github.com/fruux/Baikal/pull/537.diff","patch_url":"https://github.com/fruux/Baikal/pull/537.patch"},"body":"When a client wants to sync dates before 1-1-1970 (for example birthdays), the server response with:\r\n\r\n```\r\n<?xml` version=\"1.0\" encoding=\"utf-8\"?>\r\n<d:error xmlns:d=\"DAV:\" xmlns:s=\"http://sabredav.org/ns\">\r\n  <s:sabredav-version>3.1.2</s:sabredav-version>\r\n  <s:exception>PDOException</s:exception>\r\n  <s:message>SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'firstoccurence' at row 1</s:message>\r\n</d:error>\r\n```\r\n\r\nOriginal unsigned int (11) can't store dates before 1-1-1970 (Unix Epoch)"},"comment":{"url":"https://api.github.com/repos/fruux/Baikal/issues/comments/219102127","html_url":"https://github.com/fruux/Baikal/pull/537#issuecomment-219102127","issue_url":"https://api.github.com/repos/fruux/Baikal/issues/537","id":219102127,"user":{"login":"Dennis1993","id":1473674,"avatar_url":"https://avatars.githubusercontent.com/u/1473674?v=3","gravatar_id":"","url":"https://api.github.com/users/Dennis1993","html_url":"https://github.com/Dennis1993","followers_url":"https://api.github.com/users/Dennis1993/followers","following_url":"https://api.github.com/users/Dennis1993/following{/other_user}","gists_url":"https://api.github.com/users/Dennis1993/gists{/gist_id}","starred_url":"https://api.github.com/users/Dennis1993/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Dennis1993/subscriptions","organizations_url":"https://api.github.com/users/Dennis1993/orgs","repos_url":"https://api.github.com/users/Dennis1993/repos","events_url":"https://api.github.com/users/Dennis1993/events{/privacy}","received_events_url":"https://api.github.com/users/Dennis1993/received_events","type":"User","site_admin":false},"created_at":"2016-05-13T17:06:22Z","updated_at":"2016-05-13T17:06:22Z","body":"okay, thanks for your answer!"}}