{"action":"created","issue":{"url":"https://api.github.com/repos/numenta/nupic/issues/2983","repository_url":"https://api.github.com/repos/numenta/nupic","labels_url":"https://api.github.com/repos/numenta/nupic/issues/2983/labels{/name}","comments_url":"https://api.github.com/repos/numenta/nupic/issues/2983/comments","events_url":"https://api.github.com/repos/numenta/nupic/issues/2983/events","html_url":"https://github.com/numenta/nupic/issues/2983","id":128823303,"number":2983,"title":"MySQL version 5.7 issue with ClientJobsDAO.py DATETIME DEFAULT 0","user":{"login":"ww36","id":11664778,"avatar_url":"https://avatars.githubusercontent.com/u/11664778?v=3","gravatar_id":"","url":"https://api.github.com/users/ww36","html_url":"https://github.com/ww36","followers_url":"https://api.github.com/users/ww36/followers","following_url":"https://api.github.com/users/ww36/following{/other_user}","gists_url":"https://api.github.com/users/ww36/gists{/gist_id}","starred_url":"https://api.github.com/users/ww36/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ww36/subscriptions","organizations_url":"https://api.github.com/users/ww36/orgs","repos_url":"https://api.github.com/users/ww36/repos","events_url":"https://api.github.com/users/ww36/events{/privacy}","received_events_url":"https://api.github.com/users/ww36/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/numenta/nupic/labels/priority:3","name":"priority:3","color":"009800"},{"url":"https://api.github.com/repos/numenta/nupic/labels/type:bug","name":"type:bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"rhyolight","id":15566,"avatar_url":"https://avatars.githubusercontent.com/u/15566?v=3","gravatar_id":"","url":"https://api.github.com/users/rhyolight","html_url":"https://github.com/rhyolight","followers_url":"https://api.github.com/users/rhyolight/followers","following_url":"https://api.github.com/users/rhyolight/following{/other_user}","gists_url":"https://api.github.com/users/rhyolight/gists{/gist_id}","starred_url":"https://api.github.com/users/rhyolight/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rhyolight/subscriptions","organizations_url":"https://api.github.com/users/rhyolight/orgs","repos_url":"https://api.github.com/users/rhyolight/repos","events_url":"https://api.github.com/users/rhyolight/events{/privacy}","received_events_url":"https://api.github.com/users/rhyolight/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2016-01-26T13:43:40Z","updated_at":"2016-05-10T22:38:23Z","closed_at":null,"body":"Just installed nupic on OSX 10.9. \r\nFound MySQL version 5.7 (latest) didn't like like the DATETIME DEFAULT 0 usage in \r\npython/site-packages/nupic/database/ClientJobsDAO.py\r\nSolution used: changed all instances of\r\nDATETIME DEFAULT 0\r\nto\r\nDATETIME DEFAULT CURRENT_TIMESTAMP\r\n... and MySQL was happy again.\r\nHope this is useful.\r\nAndy\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/numenta/nupic/issues/comments/218312861","html_url":"https://github.com/numenta/nupic/issues/2983#issuecomment-218312861","issue_url":"https://api.github.com/repos/numenta/nupic/issues/2983","id":218312861,"user":{"login":"vitaly-krugl","id":1441066,"avatar_url":"https://avatars.githubusercontent.com/u/1441066?v=3","gravatar_id":"","url":"https://api.github.com/users/vitaly-krugl","html_url":"https://github.com/vitaly-krugl","followers_url":"https://api.github.com/users/vitaly-krugl/followers","following_url":"https://api.github.com/users/vitaly-krugl/following{/other_user}","gists_url":"https://api.github.com/users/vitaly-krugl/gists{/gist_id}","starred_url":"https://api.github.com/users/vitaly-krugl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitaly-krugl/subscriptions","organizations_url":"https://api.github.com/users/vitaly-krugl/orgs","repos_url":"https://api.github.com/users/vitaly-krugl/repos","events_url":"https://api.github.com/users/vitaly-krugl/events{/privacy}","received_events_url":"https://api.github.com/users/vitaly-krugl/received_events","type":"User","site_admin":false},"created_at":"2016-05-10T22:38:23Z","updated_at":"2016-05-10T22:38:23Z","body":"Note that `datetime default current_timestamp` was not supported prior to mysql 5.6.5; reference: http://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html"}}