{"action":"closed","issue":{"url":"https://api.github.com/repos/pkp/pkp-lib/issues/856","labels_url":"https://api.github.com/repos/pkp/pkp-lib/issues/856/labels{/name}","comments_url":"https://api.github.com/repos/pkp/pkp-lib/issues/856/comments","events_url":"https://api.github.com/repos/pkp/pkp-lib/issues/856/events","html_url":"https://github.com/pkp/pkp-lib/issues/856","id":114660907,"number":856,"title":"Journal Statistics DAO cross product is too large","user":{"login":"ctgraham","id":7001322,"avatar_url":"https://avatars.githubusercontent.com/u/7001322?v=3","gravatar_id":"","url":"https://api.github.com/users/ctgraham","html_url":"https://github.com/ctgraham","followers_url":"https://api.github.com/users/ctgraham/followers","following_url":"https://api.github.com/users/ctgraham/following{/other_user}","gists_url":"https://api.github.com/users/ctgraham/gists{/gist_id}","starred_url":"https://api.github.com/users/ctgraham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ctgraham/subscriptions","organizations_url":"https://api.github.com/users/ctgraham/orgs","repos_url":"https://api.github.com/users/ctgraham/repos","events_url":"https://api.github.com/users/ctgraham/events{/privacy}","received_events_url":"https://api.github.com/users/ctgraham/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pkp/pkp-lib/labels/Open%20Journal%20Systems","name":"Open Journal Systems","color":"aabbaa"}],"state":"closed","locked":false,"assignee":{"login":"beghelli","id":593977,"avatar_url":"https://avatars.githubusercontent.com/u/593977?v=3","gravatar_id":"","url":"https://api.github.com/users/beghelli","html_url":"https://github.com/beghelli","followers_url":"https://api.github.com/users/beghelli/followers","following_url":"https://api.github.com/users/beghelli/following{/other_user}","gists_url":"https://api.github.com/users/beghelli/gists{/gist_id}","starred_url":"https://api.github.com/users/beghelli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beghelli/subscriptions","organizations_url":"https://api.github.com/users/beghelli/orgs","repos_url":"https://api.github.com/users/beghelli/repos","events_url":"https://api.github.com/users/beghelli/events{/privacy}","received_events_url":"https://api.github.com/users/beghelli/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/pkp/pkp-lib/milestones/14","html_url":"https://github.com/pkp/pkp-lib/milestones/OJS%202.4.8","labels_url":"https://api.github.com/repos/pkp/pkp-lib/milestones/14/labels","id":1306736,"number":14,"title":"OJS 2.4.8","description":"","creator":{"login":"asmecher","id":200411,"avatar_url":"https://avatars.githubusercontent.com/u/200411?v=3","gravatar_id":"","url":"https://api.github.com/users/asmecher","html_url":"https://github.com/asmecher","followers_url":"https://api.github.com/users/asmecher/followers","following_url":"https://api.github.com/users/asmecher/following{/other_user}","gists_url":"https://api.github.com/users/asmecher/gists{/gist_id}","starred_url":"https://api.github.com/users/asmecher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asmecher/subscriptions","organizations_url":"https://api.github.com/users/asmecher/orgs","repos_url":"https://api.github.com/users/asmecher/repos","events_url":"https://api.github.com/users/asmecher/events{/privacy}","received_events_url":"https://api.github.com/users/asmecher/received_events","type":"User","site_admin":false},"open_issues":31,"closed_issues":6,"state":"open","created_at":"2015-09-15T16:22:34Z","updated_at":"2015-11-10T10:34:21Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2015-11-02T18:55:18Z","updated_at":"2015-11-10T10:34:21Z","closed_at":"2015-11-10T10:34:21Z","body":"The cross product of articles and users in the Journal Statistics DAO\r\nhttps://github.com/pkp/ojs/blob/a9459eb851921827e34402a321ff206422f34a34/classes/journal/JournalStatisticsDAO.inc.php#L31-L45\r\nis causing problems with very large selects.\r\n\r\nSee:\r\nhttp://forum.pkp.sfu.ca/t/error-in-stats-reports-page/4683/2\r\n\r\nThis would probably be cleaner and faster as two selects."}}