{"action":"created","issue":{"url":"https://api.github.com/repos/symphonycms/symphony-2/issues/2594","repository_url":"https://api.github.com/repos/symphonycms/symphony-2","labels_url":"https://api.github.com/repos/symphonycms/symphony-2/issues/2594/labels{/name}","comments_url":"https://api.github.com/repos/symphonycms/symphony-2/issues/2594/comments","events_url":"https://api.github.com/repos/symphonycms/symphony-2/issues/2594/events","html_url":"https://github.com/symphonycms/symphony-2/issues/2594","id":156408726,"node_id":"MDU6SXNzdWUxNTY0MDg3MjY=","number":2594,"title":"Invalid default value for 'last_seen'","user":{"login":"pixelninja","id":274397,"node_id":"MDQ6VXNlcjI3NDM5Nw==","avatar_url":"https://avatars0.githubusercontent.com/u/274397?v=4","gravatar_id":"","url":"https://api.github.com/users/pixelninja","html_url":"https://github.com/pixelninja","followers_url":"https://api.github.com/users/pixelninja/followers","following_url":"https://api.github.com/users/pixelninja/following{/other_user}","gists_url":"https://api.github.com/users/pixelninja/gists{/gist_id}","starred_url":"https://api.github.com/users/pixelninja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pixelninja/subscriptions","organizations_url":"https://api.github.com/users/pixelninja/orgs","repos_url":"https://api.github.com/users/pixelninja/repos","events_url":"https://api.github.com/users/pixelninja/events{/privacy}","received_events_url":"https://api.github.com/users/pixelninja/received_events","type":"User","site_admin":false},"labels":[{"id":171251,"node_id":"MDU6TGFiZWwxNzEyNTE=","url":"https://api.github.com/repos/symphonycms/symphony-2/labels/1%20-%20Minor","name":"1 - Minor","color":"02e10c","default":false},{"id":328424644,"node_id":"MDU6TGFiZWwzMjg0MjQ2NDQ=","url":"https://api.github.com/repos/symphonycms/symphony-2/labels/Fixed%20in%202.7.x","name":"Fixed in 2.7.x","color":"009800","default":false},{"id":115195,"node_id":"MDU6TGFiZWwxMTUxOTU=","url":"https://api.github.com/repos/symphonycms/symphony-2/labels/Needs%20Testing","name":"Needs Testing","color":"c1f17e","default":false},{"id":317124231,"node_id":"MDU6TGFiZWwzMTcxMjQyMzE=","url":"https://api.github.com/repos/symphonycms/symphony-2/labels/PR%20Submitted","name":"PR Submitted","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":{"login":"nitriques","id":771169,"node_id":"MDQ6VXNlcjc3MTE2OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/771169?v=4","gravatar_id":"","url":"https://api.github.com/users/nitriques","html_url":"https://github.com/nitriques","followers_url":"https://api.github.com/users/nitriques/followers","following_url":"https://api.github.com/users/nitriques/following{/other_user}","gists_url":"https://api.github.com/users/nitriques/gists{/gist_id}","starred_url":"https://api.github.com/users/nitriques/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitriques/subscriptions","organizations_url":"https://api.github.com/users/nitriques/orgs","repos_url":"https://api.github.com/users/nitriques/repos","events_url":"https://api.github.com/users/nitriques/events{/privacy}","received_events_url":"https://api.github.com/users/nitriques/received_events","type":"User","site_admin":false},"assignees":[{"login":"nitriques","id":771169,"node_id":"MDQ6VXNlcjc3MTE2OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/771169?v=4","gravatar_id":"","url":"https://api.github.com/users/nitriques","html_url":"https://github.com/nitriques","followers_url":"https://api.github.com/users/nitriques/followers","following_url":"https://api.github.com/users/nitriques/following{/other_user}","gists_url":"https://api.github.com/users/nitriques/gists{/gist_id}","starred_url":"https://api.github.com/users/nitriques/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitriques/subscriptions","organizations_url":"https://api.github.com/users/nitriques/orgs","repos_url":"https://api.github.com/users/nitriques/repos","events_url":"https://api.github.com/users/nitriques/events{/privacy}","received_events_url":"https://api.github.com/users/nitriques/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/symphonycms/symphony-2/milestones/26","html_url":"https://github.com/symphonycms/symphony-2/milestone/26","labels_url":"https://api.github.com/repos/symphonycms/symphony-2/milestones/26/labels","id":1354510,"node_id":"MDk6TWlsZXN0b25lMTM1NDUxMA==","number":26,"title":"2.7.0","description":"","creator":{"login":"nitriques","id":771169,"node_id":"MDQ6VXNlcjc3MTE2OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/771169?v=4","gravatar_id":"","url":"https://api.github.com/users/nitriques","html_url":"https://github.com/nitriques","followers_url":"https://api.github.com/users/nitriques/followers","following_url":"https://api.github.com/users/nitriques/following{/other_user}","gists_url":"https://api.github.com/users/nitriques/gists{/gist_id}","starred_url":"https://api.github.com/users/nitriques/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitriques/subscriptions","organizations_url":"https://api.github.com/users/nitriques/orgs","repos_url":"https://api.github.com/users/nitriques/repos","events_url":"https://api.github.com/users/nitriques/events{/privacy}","received_events_url":"https://api.github.com/users/nitriques/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":131,"state":"closed","created_at":"2015-10-14T02:25:02Z","updated_at":"2018-09-14T01:55:28Z","due_on":null,"closed_at":"2017-07-11T21:01:18Z"},"comments":6,"created_at":"2016-05-24T02:46:29Z","updated_at":"2018-09-14T01:55:47Z","closed_at":null,"author_association":"NONE","body":"New installs fail with MySQL 5.7. It returns a fatal error: `Invalid default value for 'last_seen'`\n\nLog:\n\n`05/24/2016 2:30 am > Notice: MYSQL: Establishing Connection`\n`05/24/2016 2:30 am > Notice: MYSQL: Importing Table Schema`\n`05/24/2016 2:30 am > Fatal Error: There was an error while trying to import data to the database. MySQL returned: 1067: Invalid default value for 'last_seen'`\n\nFix was to adjust line 10 of `install.sql`, located `/install/includes/install.sql` from `'last_seen' datetime DEFAULT '0000-00-00 00:00:00'` to `'last_seen' datetime DEFAULT '1971-01-01 11:59:59'`.\n\nI was also getting an error using `storage_engine`, but that has been resolved here https://github.com/symphonycms/symphony-2/issues/2587\n"},"comment":{"url":"https://api.github.com/repos/symphonycms/symphony-2/issues/comments/421205996","html_url":"https://github.com/symphonycms/symphony-2/issues/2594#issuecomment-421205996","issue_url":"https://api.github.com/repos/symphonycms/symphony-2/issues/2594","id":421205996,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMTIwNTk5Ng==","user":{"login":"nitriques","id":771169,"node_id":"MDQ6VXNlcjc3MTE2OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/771169?v=4","gravatar_id":"","url":"https://api.github.com/users/nitriques","html_url":"https://github.com/nitriques","followers_url":"https://api.github.com/users/nitriques/followers","following_url":"https://api.github.com/users/nitriques/following{/other_user}","gists_url":"https://api.github.com/users/nitriques/gists{/gist_id}","starred_url":"https://api.github.com/users/nitriques/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitriques/subscriptions","organizations_url":"https://api.github.com/users/nitriques/orgs","repos_url":"https://api.github.com/users/nitriques/repos","events_url":"https://api.github.com/users/nitriques/events{/privacy}","received_events_url":"https://api.github.com/users/nitriques/received_events","type":"User","site_admin":false},"created_at":"2018-09-14T01:55:47Z","updated_at":"2018-09-14T01:55:47Z","author_association":"MEMBER","body":"@twiro thanks, I'll fix this"}}
{"actor":{"display_login":"nitriques"}}