{"action":"closed","issue":{"url":"https://api.github.com/repos/marxjohnson/moodle-block_messageteacher/issues/14","labels_url":"https://api.github.com/repos/marxjohnson/moodle-block_messageteacher/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/marxjohnson/moodle-block_messageteacher/issues/14/comments","events_url":"https://api.github.com/repos/marxjohnson/moodle-block_messageteacher/issues/14/events","html_url":"https://github.com/marxjohnson/moodle-block_messageteacher/issues/14","id":40567983,"number":14,"title":"Update fetch teacher sql for moodle 2.7","user":{"login":"bmbrands","id":491790,"avatar_url":"https://avatars.githubusercontent.com/u/491790?v=3","gravatar_id":"","url":"https://api.github.com/users/bmbrands","html_url":"https://github.com/bmbrands","followers_url":"https://api.github.com/users/bmbrands/followers","following_url":"https://api.github.com/users/bmbrands/following{/other_user}","gists_url":"https://api.github.com/users/bmbrands/gists{/gist_id}","starred_url":"https://api.github.com/users/bmbrands/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmbrands/subscriptions","organizations_url":"https://api.github.com/users/bmbrands/orgs","repos_url":"https://api.github.com/users/bmbrands/repos","events_url":"https://api.github.com/users/bmbrands/events{/privacy}","received_events_url":"https://api.github.com/users/bmbrands/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2014-08-19T08:22:02Z","updated_at":"2016-01-04T16:50:40Z","closed_at":"2016-01-04T16:50:40Z","body":"On Moodle 2.7.1 with full debugging on the user_picture throws a notice.\r\n\r\nYou need to update your sql to include additional name fields in the user object.\r\nchanging line 67 to \r\n\r\n       $select = 'SELECT DISTINCT u.id, u.firstname, u.lastname, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.picture, u.imagealt, u.email ';\r\n\r\nshould fix it.\r\n\r\n\r\n\r\n"}}