{"action":"created","issue":{"url":"https://api.github.com/repos/publiclab/plots2/issues/3224","repository_url":"https://api.github.com/repos/publiclab/plots2","labels_url":"https://api.github.com/repos/publiclab/plots2/issues/3224/labels{/name}","comments_url":"https://api.github.com/repos/publiclab/plots2/issues/3224/comments","events_url":"https://api.github.com/repos/publiclab/plots2/issues/3224/events","html_url":"https://github.com/publiclab/plots2/pull/3224","id":349278011,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA3NDMzODUx","number":3224,"title":"Profile api test PR","user":{"login":"jywarren","id":24359,"node_id":"MDQ6VXNlcjI0MzU5","avatar_url":"https://avatars1.githubusercontent.com/u/24359?v=4","gravatar_id":"","url":"https://api.github.com/users/jywarren","html_url":"https://github.com/jywarren","followers_url":"https://api.github.com/users/jywarren/followers","following_url":"https://api.github.com/users/jywarren/following{/other_user}","gists_url":"https://api.github.com/users/jywarren/gists{/gist_id}","starred_url":"https://api.github.com/users/jywarren/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jywarren/subscriptions","organizations_url":"https://api.github.com/users/jywarren/orgs","repos_url":"https://api.github.com/users/jywarren/repos","events_url":"https://api.github.com/users/jywarren/events{/privacy}","received_events_url":"https://api.github.com/users/jywarren/received_events","type":"User","site_admin":false},"labels":[{"id":828958340,"node_id":"MDU6TGFiZWw4Mjg5NTgzNDA=","url":"https://api.github.com/repos/publiclab/plots2/labels/in%20progress","name":"in progress","color":"ededed","default":false}],"state":"open","locked":false,"assignee":{"login":"jywarren","id":24359,"node_id":"MDQ6VXNlcjI0MzU5","avatar_url":"https://avatars1.githubusercontent.com/u/24359?v=4","gravatar_id":"","url":"https://api.github.com/users/jywarren","html_url":"https://github.com/jywarren","followers_url":"https://api.github.com/users/jywarren/followers","following_url":"https://api.github.com/users/jywarren/following{/other_user}","gists_url":"https://api.github.com/users/jywarren/gists{/gist_id}","starred_url":"https://api.github.com/users/jywarren/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jywarren/subscriptions","organizations_url":"https://api.github.com/users/jywarren/orgs","repos_url":"https://api.github.com/users/jywarren/repos","events_url":"https://api.github.com/users/jywarren/events{/privacy}","received_events_url":"https://api.github.com/users/jywarren/received_events","type":"User","site_admin":false},"assignees":[{"login":"jywarren","id":24359,"node_id":"MDQ6VXNlcjI0MzU5","avatar_url":"https://avatars1.githubusercontent.com/u/24359?v=4","gravatar_id":"","url":"https://api.github.com/users/jywarren","html_url":"https://github.com/jywarren","followers_url":"https://api.github.com/users/jywarren/followers","following_url":"https://api.github.com/users/jywarren/following{/other_user}","gists_url":"https://api.github.com/users/jywarren/gists{/gist_id}","starred_url":"https://api.github.com/users/jywarren/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jywarren/subscriptions","organizations_url":"https://api.github.com/users/jywarren/orgs","repos_url":"https://api.github.com/users/jywarren/repos","events_url":"https://api.github.com/users/jywarren/events{/privacy}","received_events_url":"https://api.github.com/users/jywarren/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-08-09T20:28:40Z","updated_at":"2018-08-09T20:30:28Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/publiclab/plots2/pulls/3224","html_url":"https://github.com/publiclab/plots2/pull/3224","diff_url":"https://github.com/publiclab/plots2/pull/3224.diff","patch_url":"https://github.com/publiclab/plots2/pull/3224.patch"},"body":"Just testing something for #3134!"},"comment":{"url":"https://api.github.com/repos/publiclab/plots2/issues/comments/411886967","html_url":"https://github.com/publiclab/plots2/pull/3224#issuecomment-411886967","issue_url":"https://api.github.com/repos/publiclab/plots2/issues/3224","id":411886967,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMTg4Njk2Nw==","user":{"login":"jywarren","id":24359,"node_id":"MDQ6VXNlcjI0MzU5","avatar_url":"https://avatars1.githubusercontent.com/u/24359?v=4","gravatar_id":"","url":"https://api.github.com/users/jywarren","html_url":"https://github.com/jywarren","followers_url":"https://api.github.com/users/jywarren/followers","following_url":"https://api.github.com/users/jywarren/following{/other_user}","gists_url":"https://api.github.com/users/jywarren/gists{/gist_id}","starred_url":"https://api.github.com/users/jywarren/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jywarren/subscriptions","organizations_url":"https://api.github.com/users/jywarren/orgs","repos_url":"https://api.github.com/users/jywarren/repos","events_url":"https://api.github.com/users/jywarren/events{/privacy}","received_events_url":"https://api.github.com/users/jywarren/received_events","type":"User","site_admin":false},"created_at":"2018-08-09T20:30:28Z","updated_at":"2018-08-09T20:30:28Z","author_association":"CONTRIBUTOR","body":"Locally, this gives me, on mysql:\r\n\r\n```sql\r\nActiveRecord::StatementInvalid:         ActiveRecord::StatementInvalid: Mysql2::Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'plots.node_revisions.timestamp' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT `node`.`nid` FROM `node` LEFT OUTER JOIN `node_revisions` ON `node_revisions`.`nid` = `node`.`nid` LEFT OUTER JOIN `community_tags` ON `community_tags`.`nid` = `node`.`nid` LEFT OUTER JOIN `term_data` ON `term_data`.`tid` = `community_tags`.`tid` WHERE (`node`.`nid`) IN (1, 8, 1, 2, 8, 9, 10, 15) AND ((created >= 1533839387 AND created <= 1533846587) OR (timestamp >= 1533839387  AND timestamp <= 1533846587)) ORDER BY node_revisions.timestamp DESC\r\n            test/unit/user_test.rb:97:in `block in <class:UserTest>'\r\n\r\n  23/23: [================================================] 100% Time: 00:00:07, Time: 00:00:07\r\n```"}}
{"actor":{"display_login":"jywarren"}}