{"action":"created","issue":{"url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/49","labels_url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/49/labels{/name}","comments_url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/49/comments","events_url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/49/events","html_url":"https://github.com/arnovr/ocusagecharts/issues/49","id":46715965,"number":49,"title":"Database Error with OC 7.0.2","user":{"login":"tadeomarti","id":8223446,"avatar_url":"https://avatars.githubusercontent.com/u/8223446?v=3","gravatar_id":"","url":"https://api.github.com/users/tadeomarti","html_url":"https://github.com/tadeomarti","followers_url":"https://api.github.com/users/tadeomarti/followers","following_url":"https://api.github.com/users/tadeomarti/following{/other_user}","gists_url":"https://api.github.com/users/tadeomarti/gists{/gist_id}","starred_url":"https://api.github.com/users/tadeomarti/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tadeomarti/subscriptions","organizations_url":"https://api.github.com/users/tadeomarti/orgs","repos_url":"https://api.github.com/users/tadeomarti/repos","events_url":"https://api.github.com/users/tadeomarti/events{/privacy}","received_events_url":"https://api.github.com/users/tadeomarti/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/arnovr/ocusagecharts/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"arnovr","id":6443841,"avatar_url":"https://avatars.githubusercontent.com/u/6443841?v=3","gravatar_id":"","url":"https://api.github.com/users/arnovr","html_url":"https://github.com/arnovr","followers_url":"https://api.github.com/users/arnovr/followers","following_url":"https://api.github.com/users/arnovr/following{/other_user}","gists_url":"https://api.github.com/users/arnovr/gists{/gist_id}","starred_url":"https://api.github.com/users/arnovr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arnovr/subscriptions","organizations_url":"https://api.github.com/users/arnovr/orgs","repos_url":"https://api.github.com/users/arnovr/repos","events_url":"https://api.github.com/users/arnovr/events{/privacy}","received_events_url":"https://api.github.com/users/arnovr/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/arnovr/ocusagecharts/milestones/2","html_url":"https://github.com/arnovr/ocusagecharts/milestones/v0.4","labels_url":"https://api.github.com/repos/arnovr/ocusagecharts/milestones/2/labels","id":780588,"number":2,"title":"v0.4","description":"","creator":{"login":"arnovr","id":6443841,"avatar_url":"https://avatars.githubusercontent.com/u/6443841?v=3","gravatar_id":"","url":"https://api.github.com/users/arnovr","html_url":"https://github.com/arnovr","followers_url":"https://api.github.com/users/arnovr/followers","following_url":"https://api.github.com/users/arnovr/following{/other_user}","gists_url":"https://api.github.com/users/arnovr/gists{/gist_id}","starred_url":"https://api.github.com/users/arnovr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arnovr/subscriptions","organizations_url":"https://api.github.com/users/arnovr/orgs","repos_url":"https://api.github.com/users/arnovr/repos","events_url":"https://api.github.com/users/arnovr/events{/privacy}","received_events_url":"https://api.github.com/users/arnovr/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":3,"state":"open","created_at":"2014-09-06T09:01:34Z","updated_at":"2015-03-20T10:59:25Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2014-10-24T08:41:11Z","updated_at":"2015-03-20T10:59:25Z","closed_at":"2015-03-20T10:59:25Z","body":"I recently installed ocUsageCharts v3.2 on my ownCloud v7.0.2.1. At charts menu the stats from my users are not shown.\r\n\r\n![captura](https://cloud.githubusercontent.com/assets/8223446/4766891/674bf186-5b57-11e4-8a6f-8931cbd1dc1c.PNG)\r\n\r\nLog show this error:\r\nFatal \tindex \tDoctrine\\DBAL\\DBALException: An exception occurred while executing 'SELECT DISTINCT CONCAT(MONTH(\"created\"), ' ', YEAR(\"created\")) as month, avg(\"usage\") as average, username FROM oc_uc_storageusage WHERE \"usage\" > 0 AND created > ? GROUP BY username, month': SQLSTATE[42883]: Undefined function: 7 ERROR: function month(timestamp without time zone) does not exist LINE 1: SELECT DISTINCT CONCAT(MONTH(\"created\"), ' ', YEAR(\"created\"... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts\r\n\r\nMy ownCloud is running under:\r\nUbuntu 14.04.1 LTS\r\nApache/2.4.7 (Ubuntu)\r\nPHP 5.5.9-1ubuntu4.4\r\nExternal Database: PostgreSQL 9.1.14\r\nLDAP\r\n\r\nRegards"},"comment":{"url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/comments/83985992","html_url":"https://github.com/arnovr/ocusagecharts/issues/49#issuecomment-83985992","issue_url":"https://api.github.com/repos/arnovr/ocusagecharts/issues/49","id":83985992,"user":{"login":"arnovr","id":6443841,"avatar_url":"https://avatars.githubusercontent.com/u/6443841?v=3","gravatar_id":"","url":"https://api.github.com/users/arnovr","html_url":"https://github.com/arnovr","followers_url":"https://api.github.com/users/arnovr/followers","following_url":"https://api.github.com/users/arnovr/following{/other_user}","gists_url":"https://api.github.com/users/arnovr/gists{/gist_id}","starred_url":"https://api.github.com/users/arnovr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arnovr/subscriptions","organizations_url":"https://api.github.com/users/arnovr/orgs","repos_url":"https://api.github.com/users/arnovr/repos","events_url":"https://api.github.com/users/arnovr/events{/privacy}","received_events_url":"https://api.github.com/users/arnovr/received_events","type":"User","site_admin":false},"created_at":"2015-03-20T10:59:25Z","updated_at":"2015-03-20T10:59:25Z","body":"Sorry about the massive delay, my laptop died on me and needed a new one. Which i have right now.\r\nSo it should be fixed"}}