{"action":"closed","issue":{"url":"https://api.github.com/repos/Coral-erm/Coral/issues/50","repository_url":"https://api.github.com/repos/Coral-erm/Coral","labels_url":"https://api.github.com/repos/Coral-erm/Coral/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/Coral-erm/Coral/issues/50/comments","events_url":"https://api.github.com/repos/Coral-erm/Coral/issues/50/events","html_url":"https://github.com/Coral-erm/Coral/issues/50","id":161075592,"number":50,"title":"Invalid default date value","user":{"login":"jamesrf","id":160497,"avatar_url":"https://avatars.githubusercontent.com/u/160497?v=3","gravatar_id":"","url":"https://api.github.com/users/jamesrf","html_url":"https://github.com/jamesrf","followers_url":"https://api.github.com/users/jamesrf/followers","following_url":"https://api.github.com/users/jamesrf/following{/other_user}","gists_url":"https://api.github.com/users/jamesrf/gists{/gist_id}","starred_url":"https://api.github.com/users/jamesrf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamesrf/subscriptions","organizations_url":"https://api.github.com/users/jamesrf/orgs","repos_url":"https://api.github.com/users/jamesrf/repos","events_url":"https://api.github.com/users/jamesrf/events{/privacy}","received_events_url":"https://api.github.com/users/jamesrf/received_events","type":"User","site_admin":false},"labels":[{"id":338834592,"url":"https://api.github.com/repos/Coral-erm/Coral/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-06-19T14:31:11Z","updated_at":"2016-12-01T22:41:56Z","closed_at":"2016-12-01T22:41:56Z","body":"When trying to install the latest version of Coral resources, I get this error:\n\n> Invalid default value for 'updateDate'\n> \n> For statement: CREATE TABLE `ResourceNote` ( `resourceNoteID` int(11) NOT NULL auto_increment, `resourceID` int(11) default NULL, `noteTypeID` int(11) default NULL, `tabName` varchar(45) default NULL, `updateDate` timestamp NOT NULL default '0000-00-00 00:00:00', `updateLoginID` varchar(45) default NULL, `noteText` text, PRIMARY KEY (`resourceNoteID`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8`\n\nI am using PHP 5.6 and MySQL 5.7\n\nFor newer verisons of MySQL, strict mode has been changed and you cannot use '0000-00-00' as a default date without changing some settings in MySQL.\n\nMy suggestion instead would be to instead set the default value to be \"NOW()\", or to enable NULL values.\n\nhttp://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes\nhttp://stackoverflow.com/questions/25349126/how-can-i-set-the-default-value-of-a-field-as-0000-00-00-000000\n\nHappy to make a PR for this if it sounds like a reasonable solution, however I'm not entirely sure yet how that field is used or what makes most sense for existing installs, or how this would be handled in an upgrade.\n"}}
{"actor":{"display_login":"jeffnm"}}