{"action":"created","issue":{"url":"https://api.github.com/repos/publiclab/plots2/issues/3120","repository_url":"https://api.github.com/repos/publiclab/plots2","labels_url":"https://api.github.com/repos/publiclab/plots2/issues/3120/labels{/name}","comments_url":"https://api.github.com/repos/publiclab/plots2/issues/3120/comments","events_url":"https://api.github.com/repos/publiclab/plots2/issues/3120/events","html_url":"https://github.com/publiclab/plots2/issues/3120","id":343338831,"node_id":"MDU6SXNzdWUzNDMzMzg4MzE=","number":3120,"title":"Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause (locally only)","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":42345818,"node_id":"MDU6TGFiZWw0MjM0NTgxOA==","url":"https://api.github.com/repos/publiclab/plots2/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-07-21T16:34:29Z","updated_at":"2018-07-21T16:41:24Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"My local instance is seeing the same error we saw on June 7 (https://github.com/publiclab/plots2/issues/2787#issuecomment-395601276) that I thought we fixed in https://github.com/publiclab/plots2/pull/2794\r\n\r\n`Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'plots.node_revisions.vid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT `node_revisions`.* FROM `node_revisions` INNER JOIN `node` ON `node`.`nid` = `node_revisions`.`nid` WHERE (type = ('page')) AND (node.status = 1) AND (node_revisions.status = 1) AND (timestamp - node.created > 300) GROUP BY node.title, node.nid ORDER BY timestamp DESC LIMIT 10`\r\n\r\nOn line 127 of `home_controller.rb`, but really to do with the preceding ActiveRecord call:\r\n\r\nhttps://github.com/publiclab/plots2/blob/6f353b2937af8b523708a9991813bbdbac21987d/app/controllers/home_controller.rb#L117-L124\r\n\r\nI'm going to try tweaking locally to get past it. "},"comment":{"url":"https://api.github.com/repos/publiclab/plots2/issues/comments/406808699","html_url":"https://github.com/publiclab/plots2/issues/3120#issuecomment-406808699","issue_url":"https://api.github.com/repos/publiclab/plots2/issues/3120","id":406808699,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNjgwODY5OQ==","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-07-21T16:41:24Z","updated_at":"2018-07-21T16:41:24Z","author_association":"CONTRIBUTOR","body":"Also noting that the default for the `ONLY_FULL_GROUP_BY` setting changed in MySQL 5.7, so we may have some version mismatch issues here, but i'll fix it on my local anyways. Which is:\r\n\r\n`mysql  Ver 14.14 Distrib 5.7.21, for Linux (armv7l) using  EditLine wrapper`"}}
{"actor":{"display_login":"jywarren"}}