{"action":"created","issue":{"url":"https://api.github.com/repos/project-hatohol/hatohol/issues/1130","labels_url":"https://api.github.com/repos/project-hatohol/hatohol/issues/1130/labels{/name}","comments_url":"https://api.github.com/repos/project-hatohol/hatohol/issues/1130/comments","events_url":"https://api.github.com/repos/project-hatohol/hatohol/issues/1130/events","html_url":"https://github.com/project-hatohol/hatohol/issues/1130","id":62553278,"number":1130,"title":"イベント画面をホスト名でフィルタするとエラー発生＠15.03リリース確認 ","user":{"login":"o-wakabayashi","id":8002282,"avatar_url":"https://avatars.githubusercontent.com/u/8002282?v=3","gravatar_id":"","url":"https://api.github.com/users/o-wakabayashi","html_url":"https://github.com/o-wakabayashi","followers_url":"https://api.github.com/users/o-wakabayashi/followers","following_url":"https://api.github.com/users/o-wakabayashi/following{/other_user}","gists_url":"https://api.github.com/users/o-wakabayashi/gists{/gist_id}","starred_url":"https://api.github.com/users/o-wakabayashi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/o-wakabayashi/subscriptions","organizations_url":"https://api.github.com/users/o-wakabayashi/orgs","repos_url":"https://api.github.com/users/o-wakabayashi/repos","events_url":"https://api.github.com/users/o-wakabayashi/events{/privacy}","received_events_url":"https://api.github.com/users/o-wakabayashi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-18T00:53:43Z","updated_at":"2015-03-18T03:23:00Z","closed_at":null,"body":"ファイル：15.03向けpre1パッケージ（多分3/18時点のMaseterでも発生）\r\n発生事象：”エラー　例外が発生しました”のダイアログが表示される\r\n実施内容：\r\n１．WebUIで”イベント\"画面を選択\r\n２．監視サーバーを選択（これは何でもいい）\r\n３．グループを選択　<-　してもしなくてもいい\r\n４．ホストを選択\r\n　→ここでダメ\r\n\r\n【ログ】\r\n[INFO] FaceRest.cc:881 reply error: 4, HTERR_GOT_EXCEPTION: DBAgentMySQL.cc:625 Failed to query: SELECT events.unified_id,events.server_id,events.id,events.time_sec,events.time_ns,events.event_value,events.trigger_id,events.status,events.severity,events.global_host_id,events.host_id_in_server,events.hostname,events.brief,events.extended_info FROM events WHERE events.server_id IN (3,5,7) AND events.server_id=7 AND triggers.host_id_in_server='59' ORDER BY time_sec DESC, time_ns DESC, unified_id DESC LIMIT 50 : (1054) Unknown column 'triggers.host_id_in_server' in 'where clause'#12#012\r\n\r\nWHEREの後で渡してるパラメータで”triggers.host_id_in_server”がおかしい？？"},"comment":{"url":"https://api.github.com/repos/project-hatohol/hatohol/issues/comments/82718745","html_url":"https://github.com/project-hatohol/hatohol/issues/1130#issuecomment-82718745","issue_url":"https://api.github.com/repos/project-hatohol/hatohol/issues/1130","id":82718745,"user":{"login":"cosmo0920","id":700876,"avatar_url":"https://avatars.githubusercontent.com/u/700876?v=3","gravatar_id":"","url":"https://api.github.com/users/cosmo0920","html_url":"https://github.com/cosmo0920","followers_url":"https://api.github.com/users/cosmo0920/followers","following_url":"https://api.github.com/users/cosmo0920/following{/other_user}","gists_url":"https://api.github.com/users/cosmo0920/gists{/gist_id}","starred_url":"https://api.github.com/users/cosmo0920/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cosmo0920/subscriptions","organizations_url":"https://api.github.com/users/cosmo0920/orgs","repos_url":"https://api.github.com/users/cosmo0920/repos","events_url":"https://api.github.com/users/cosmo0920/events{/privacy}","received_events_url":"https://api.github.com/users/cosmo0920/received_events","type":"User","site_admin":false},"created_at":"2015-03-18T03:23:00Z","updated_at":"2015-03-18T03:23:00Z","body":"（バグ修正は一瞬でしたが、自動テストどうしよう。）"}}