{"action":"created","issue":{"url":"https://api.github.com/repos/cachethq/Cachet/issues/473","labels_url":"https://api.github.com/repos/cachethq/Cachet/issues/473/labels{/name}","comments_url":"https://api.github.com/repos/cachethq/Cachet/issues/473/comments","events_url":"https://api.github.com/repos/cachethq/Cachet/issues/473/events","html_url":"https://github.com/cachethq/Cachet/issues/473","id":58557004,"number":473,"title":"Metrics don't work on Heroku","user":{"login":"jbrooksuk","id":246103,"avatar_url":"https://avatars.githubusercontent.com/u/246103?v=3","gravatar_id":"","url":"https://api.github.com/users/jbrooksuk","html_url":"https://github.com/jbrooksuk","followers_url":"https://api.github.com/users/jbrooksuk/followers","following_url":"https://api.github.com/users/jbrooksuk/following{/other_user}","gists_url":"https://api.github.com/users/jbrooksuk/gists{/gist_id}","starred_url":"https://api.github.com/users/jbrooksuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbrooksuk/subscriptions","organizations_url":"https://api.github.com/users/jbrooksuk/orgs","repos_url":"https://api.github.com/users/jbrooksuk/repos","events_url":"https://api.github.com/users/jbrooksuk/events{/privacy}","received_events_url":"https://api.github.com/users/jbrooksuk/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cachethq/Cachet/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/cachethq/Cachet/labels/db:%20pgsql","name":"db: pgsql","color":"f7c6c7"},{"url":"https://api.github.com/repos/cachethq/Cachet/labels/db:%20sqlite","name":"db: sqlite","color":"f7c6c7"},{"url":"https://api.github.com/repos/cachethq/Cachet/labels/help%20wanted","name":"help wanted","color":"26A65B"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/cachethq/Cachet/milestones/1","html_url":"https://github.com/cachethq/Cachet/milestones/First%20Release%20(v1.0.0)","labels_url":"https://api.github.com/repos/cachethq/Cachet/milestones/1/labels","id":878070,"number":1,"title":"First Release (v1.0.0)","description":"Cachet should be open for a proper release, which contains at least:\r\n\r\n- Full Setup Page\r\n- Management Panel\r\n- API\r\n- Web Hooks","creator":{"login":"jbrooksuk","id":246103,"avatar_url":"https://avatars.githubusercontent.com/u/246103?v=3","gravatar_id":"","url":"https://api.github.com/users/jbrooksuk","html_url":"https://github.com/jbrooksuk","followers_url":"https://api.github.com/users/jbrooksuk/followers","following_url":"https://api.github.com/users/jbrooksuk/following{/other_user}","gists_url":"https://api.github.com/users/jbrooksuk/gists{/gist_id}","starred_url":"https://api.github.com/users/jbrooksuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbrooksuk/subscriptions","organizations_url":"https://api.github.com/users/jbrooksuk/orgs","repos_url":"https://api.github.com/users/jbrooksuk/repos","events_url":"https://api.github.com/users/jbrooksuk/events{/privacy}","received_events_url":"https://api.github.com/users/jbrooksuk/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":45,"state":"open","created_at":"2014-11-24T10:32:34Z","updated_at":"2015-03-11T14:53:39Z","due_on":null,"closed_at":null},"comments":21,"created_at":"2015-02-23T08:35:02Z","updated_at":"2015-03-13T07:22:44Z","closed_at":"2015-02-25T15:00:14Z","body":"```\r\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"0\" LINE 1: ...%Y%c%e%H\") = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 0 HOUR), \"... ^ (SQL: select sum(\"value\") as aggregate from \"metric_points\" where \"metric_points\".\"metric_id\" = 1 and DATE_FORMAT(created_at, \"%Y%c%e%H\") = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 0 HOUR), \"%Y%c%e%H\") and HOUR(created_at) = HOUR(DATE_SUB(NOW(), INTERVAL 0 HOUR)) group by HOUR(created_at)) (View: /app/app/views/partials/graphs.blade.php) (View: /app/app/views/partials/graphs.blade.php)\r\n```\r\n\r\nWell that's a massive pain."},"comment":{"url":"https://api.github.com/repos/cachethq/Cachet/issues/comments/78845949","html_url":"https://github.com/cachethq/Cachet/issues/473#issuecomment-78845949","issue_url":"https://api.github.com/repos/cachethq/Cachet/issues/473","id":78845949,"user":{"login":"jbrooksuk","id":246103,"avatar_url":"https://avatars.githubusercontent.com/u/246103?v=3","gravatar_id":"","url":"https://api.github.com/users/jbrooksuk","html_url":"https://github.com/jbrooksuk","followers_url":"https://api.github.com/users/jbrooksuk/followers","following_url":"https://api.github.com/users/jbrooksuk/following{/other_user}","gists_url":"https://api.github.com/users/jbrooksuk/gists{/gist_id}","starred_url":"https://api.github.com/users/jbrooksuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbrooksuk/subscriptions","organizations_url":"https://api.github.com/users/jbrooksuk/orgs","repos_url":"https://api.github.com/users/jbrooksuk/repos","events_url":"https://api.github.com/users/jbrooksuk/events{/privacy}","received_events_url":"https://api.github.com/users/jbrooksuk/received_events","type":"User","site_admin":false},"created_at":"2015-03-13T07:22:44Z","updated_at":"2015-03-13T07:22:44Z","body":"Are you able to see the tables?"}}