{"action":"created","issue":{"url":"https://api.github.com/repos/pkp/pkp-lib/issues/4097","repository_url":"https://api.github.com/repos/pkp/pkp-lib","labels_url":"https://api.github.com/repos/pkp/pkp-lib/issues/4097/labels{/name}","comments_url":"https://api.github.com/repos/pkp/pkp-lib/issues/4097/comments","events_url":"https://api.github.com/repos/pkp/pkp-lib/issues/4097/events","html_url":"https://github.com/pkp/pkp-lib/issues/4097","id":364167873,"node_id":"MDU6SXNzdWUzNjQxNjc4NzM=","number":4097,"title":"[OJS] Fix for #3705 breaks archives with PostgreSQL","user":{"login":"crism","id":1933900,"node_id":"MDQ6VXNlcjE5MzM5MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/1933900?v=4","gravatar_id":"","url":"https://api.github.com/users/crism","html_url":"https://github.com/crism","followers_url":"https://api.github.com/users/crism/followers","following_url":"https://api.github.com/users/crism/following{/other_user}","gists_url":"https://api.github.com/users/crism/gists{/gist_id}","starred_url":"https://api.github.com/users/crism/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crism/subscriptions","organizations_url":"https://api.github.com/users/crism/orgs","repos_url":"https://api.github.com/users/crism/repos","events_url":"https://api.github.com/users/crism/events{/privacy}","received_events_url":"https://api.github.com/users/crism/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-09-26T19:04:20Z","updated_at":"2018-09-27T20:55:09Z","closed_at":null,"author_association":"MEMBER","body":"The changes introduced to fix #3705 cause an error when PostgreSQL is the backing store: `DB Error: ERROR: column \"o.seq\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...published\" = $2 group by \"i\".\"issue_id\" order by \"o\".\"seq\" ... ^`"},"comment":{"url":"https://api.github.com/repos/pkp/pkp-lib/issues/comments/425239953","html_url":"https://github.com/pkp/pkp-lib/issues/4097#issuecomment-425239953","issue_url":"https://api.github.com/repos/pkp/pkp-lib/issues/4097","id":425239953,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNTIzOTk1Mw==","user":{"login":"asmecher","id":200411,"node_id":"MDQ6VXNlcjIwMDQxMQ==","avatar_url":"https://avatars0.githubusercontent.com/u/200411?v=4","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},"created_at":"2018-09-27T20:55:09Z","updated_at":"2018-09-27T20:55:09Z","author_association":"MEMBER","body":"@cpockett, it hasn't been merged yet, but the fix https://github.com/pkp/ojs/pull/2123 is simple enough. I'd suggest patching with that."}}
{"actor":{"display_login":"asmecher"}}