{"action":"created","issue":{"url":"https://api.github.com/repos/seblucas/cops/issues/285","repository_url":"https://api.github.com/repos/seblucas/cops","labels_url":"https://api.github.com/repos/seblucas/cops/issues/285/labels{/name}","comments_url":"https://api.github.com/repos/seblucas/cops/issues/285/comments","events_url":"https://api.github.com/repos/seblucas/cops/issues/285/events","html_url":"https://github.com/seblucas/cops/pull/285","id":165992309,"number":285,"title":"Fixed CustomColumnTypeText showing id instead of text when created by getCustomByBook()","user":{"login":"Mikescher","id":175731,"avatar_url":"https://avatars.githubusercontent.com/u/175731?v=3","gravatar_id":"","url":"https://api.github.com/users/Mikescher","html_url":"https://github.com/Mikescher","followers_url":"https://api.github.com/users/Mikescher/followers","following_url":"https://api.github.com/users/Mikescher/following{/other_user}","gists_url":"https://api.github.com/users/Mikescher/gists{/gist_id}","starred_url":"https://api.github.com/users/Mikescher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mikescher/subscriptions","organizations_url":"https://api.github.com/users/Mikescher/orgs","repos_url":"https://api.github.com/users/Mikescher/repos","events_url":"https://api.github.com/users/Mikescher/events{/privacy}","received_events_url":"https://api.github.com/users/Mikescher/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-17T19:46:13Z","updated_at":"2016-07-17T20:04:13Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/seblucas/cops/pulls/285","html_url":"https://github.com/seblucas/cops/pull/285","diff_url":"https://github.com/seblucas/cops/pull/285.diff","patch_url":"https://github.com/seblucas/cops/pull/285.patch"},"body":"Custom text columns currently display only their internal ID in bookdetail.html and main.html.\r\n\r\nThe problem was the SQL query in `public function getCustomByBook($book)` queries the `column_x_link.value` instead of `column_x.value`.\r\n(and annoyingly the value-table and the link-table have the same column name `value`. So the query didn't even fail but just returned the wrong value -.-)\r\n\r\nSee also: http://www.mobileread.com/forums/showpost.php?p=3352831&postcount=1291\r\n\r\nGreets\r\n  ~ Mike"},"comment":{"url":"https://api.github.com/repos/seblucas/cops/issues/comments/233201000","html_url":"https://github.com/seblucas/cops/pull/285#issuecomment-233201000","issue_url":"https://api.github.com/repos/seblucas/cops/issues/285","id":233201000,"user":{"login":"Mikescher","id":175731,"avatar_url":"https://avatars.githubusercontent.com/u/175731?v=3","gravatar_id":"","url":"https://api.github.com/users/Mikescher","html_url":"https://github.com/Mikescher","followers_url":"https://api.github.com/users/Mikescher/followers","following_url":"https://api.github.com/users/Mikescher/following{/other_user}","gists_url":"https://api.github.com/users/Mikescher/gists{/gist_id}","starred_url":"https://api.github.com/users/Mikescher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mikescher/subscriptions","organizations_url":"https://api.github.com/users/Mikescher/orgs","repos_url":"https://api.github.com/users/Mikescher/repos","events_url":"https://api.github.com/users/Mikescher/events{/privacy}","received_events_url":"https://api.github.com/users/Mikescher/received_events","type":"User","site_admin":false},"created_at":"2016-07-17T20:04:13Z","updated_at":"2016-07-17T20:04:13Z","body":"@Horla:\r\n\r\nI think you were too fast, could it be you only got the changes from the first commit? :D"}}
{"actor":{"display_login":"Mikescher"}}