{"action":"closed","issue":{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/692","repository_url":"https://api.github.com/repos/Geeklog-Core/geeklog","labels_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/692/labels{/name}","comments_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/692/comments","events_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/692/events","html_url":"https://github.com/Geeklog-Core/geeklog/issues/692","id":176883122,"number":692,"title":"Errors since moving to MySQL 5.7.15","user":{"login":"jrmain","id":1110694,"avatar_url":"https://avatars.githubusercontent.com/u/1110694?v=3","gravatar_id":"","url":"https://api.github.com/users/jrmain","html_url":"https://github.com/jrmain","followers_url":"https://api.github.com/users/jrmain/followers","following_url":"https://api.github.com/users/jrmain/following{/other_user}","gists_url":"https://api.github.com/users/jrmain/gists{/gist_id}","starred_url":"https://api.github.com/users/jrmain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrmain/subscriptions","organizations_url":"https://api.github.com/users/jrmain/orgs","repos_url":"https://api.github.com/users/jrmain/repos","events_url":"https://api.github.com/users/jrmain/events{/privacy}","received_events_url":"https://api.github.com/users/jrmain/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false},"assignees":[{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/milestones/42","html_url":"https://github.com/Geeklog-Core/geeklog/milestones/2.1.2","labels_url":"https://api.github.com/repos/Geeklog-Core/geeklog/milestones/42/labels","id":1484694,"number":42,"title":"2.1.2","description":null,"creator":{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":33,"state":"open","created_at":"2016-01-05T12:13:33Z","updated_at":"2016-10-15T13:52:17Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-09-14T11:30:59Z","updated_at":"2016-10-15T13:52:17Z","closed_at":"2016-10-15T13:52:17Z","body":"I'm moving my Geeklog site to a new server that runs MySQL 5.7.15. I started getting these in the Geeklog error log:\r\n`1055: Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gklg1.ta.tid' which is not functionally dependent on columns in GROUP BY clause; \r\nthis is incompatible with sql_mode=only_full_group_by in xxx/geeklog/index.php:319. \r\nSQL in question: SELECT s.*, ta.tid, UNIX_TIMESTAMP(s.date) AS unixdate, UNIX_TIMESTAMP(s.expire) as expireunix, u.uid, u.username, u.fullname, u.photo, u.email, t.topic, t.imageurl FROM gl_stories AS s, gl_topic_assignments AS ta,gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (ta.tid = t.tid) AND ta.type = 'article' AND ta.id = s.sid AND  (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 AND ta.tdefault = 1 AND (s.perm_anon >= 2) AND (ta.tid IN ('gamingblog','jdrgaming','tpu','Reviews','xbox360','miscellaneous','tpubf2','minecraft','xboxone')) GROUP BY s.sid ORDER BY featured DESC, date DESC LIMIT 0, 10` \r\n\r\n`E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details.  @ xxx/gl-private/system/databases/mysqli.class.php line 279`\r\n\r\nIn order to get past this error, I had to change the global MySQL setting for sql-mode, from its MySQL 5.7.15 default of `ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION` to `STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION`\r\n\r\nThe site now works, but I would prefer to find another way around this issue, or at least find a way to change the sql-mode for the Geeklog site only (not globally).\r\n\r\nAnyone else seeing this?\r\n"}}
{"actor":{"display_login":"eSilverStrike"}}