{"action":"created","issue":{"url":"https://api.github.com/repos/orocrm/crm/issues/81","labels_url":"https://api.github.com/repos/orocrm/crm/issues/81/labels{/name}","comments_url":"https://api.github.com/repos/orocrm/crm/issues/81/comments","events_url":"https://api.github.com/repos/orocrm/crm/issues/81/events","html_url":"https://github.com/orocrm/crm/issues/81","id":48420666,"number":81,"title":" can't view channel page on fresh installation without sample data ","user":{"login":"tawfekov","id":94997,"avatar_url":"https://avatars.githubusercontent.com/u/94997?v=3","gravatar_id":"","url":"https://api.github.com/users/tawfekov","html_url":"https://github.com/tawfekov","followers_url":"https://api.github.com/users/tawfekov/followers","following_url":"https://api.github.com/users/tawfekov/following{/other_user}","gists_url":"https://api.github.com/users/tawfekov/gists{/gist_id}","starred_url":"https://api.github.com/users/tawfekov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tawfekov/subscriptions","organizations_url":"https://api.github.com/users/tawfekov/orgs","repos_url":"https://api.github.com/users/tawfekov/repos","events_url":"https://api.github.com/users/tawfekov/events{/privacy}","received_events_url":"https://api.github.com/users/tawfekov/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2014-11-11T19:06:23Z","updated_at":"2015-02-19T18:03:57Z","closed_at":"2015-02-19T18:03:17Z","body":"I was trying to work on fresh installation but I got this error when I tried to view the channel page  on this url : http://oro.local/app_dev.php/channel\r\n\r\nerror message was : \r\n**An exception has been thrown during the rendering of a template (\"An exception occurred while executing 'SELECT o0_.id AS id0, o0_.name AS name1, o0_.channel_type AS channel_type2, CASE WHEN o0_.status = 1 THEN 'enabled' ELSE 'disabled' END AS sclr3 FROM orocrm_channel o0_ WHERE o0_.organization_owner_id IN (1) AND o0_.organization_owner_id = 1 GROUP BY o0_.id ORDER BY o0_.name ASC':**\r\n\r\n\r\n![500 internal server error](https://cloud.githubusercontent.com/assets/94997/4998971/2e73d660-69e6-11e4-9033-c8be6819fc58.png)"},"comment":{"url":"https://api.github.com/repos/orocrm/crm/issues/comments/75103302","html_url":"https://github.com/orocrm/crm/issues/81#issuecomment-75103302","issue_url":"https://api.github.com/repos/orocrm/crm/issues/81","id":75103302,"user":{"login":"yurio","id":1615700,"avatar_url":"https://avatars.githubusercontent.com/u/1615700?v=3","gravatar_id":"","url":"https://api.github.com/users/yurio","html_url":"https://github.com/yurio","followers_url":"https://api.github.com/users/yurio/followers","following_url":"https://api.github.com/users/yurio/following{/other_user}","gists_url":"https://api.github.com/users/yurio/gists{/gist_id}","starred_url":"https://api.github.com/users/yurio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yurio/subscriptions","organizations_url":"https://api.github.com/users/yurio/orgs","repos_url":"https://api.github.com/users/yurio/repos","events_url":"https://api.github.com/users/yurio/events{/privacy}","received_events_url":"https://api.github.com/users/yurio/received_events","type":"User","site_admin":false},"created_at":"2015-02-19T18:03:57Z","updated_at":"2015-02-19T18:03:57Z","body":"Closed because it cannot reproduse."}}