{"action":"opened","issue":{"url":"https://api.github.com/repos/Neconix/Yii2-Oci8/issues/1","repository_url":"https://api.github.com/repos/Neconix/Yii2-Oci8","labels_url":"https://api.github.com/repos/Neconix/Yii2-Oci8/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/Neconix/Yii2-Oci8/issues/1/comments","events_url":"https://api.github.com/repos/Neconix/Yii2-Oci8/issues/1/events","html_url":"https://github.com/Neconix/Yii2-Oci8/issues/1","id":185621918,"number":1,"title":"Oracle connection - Error Message : ORA-00904: invalid identifier","user":{"login":"IDLE-Max","id":18023698,"avatar_url":"https://avatars.githubusercontent.com/u/18023698?v=3","gravatar_id":"","url":"https://api.github.com/users/IDLE-Max","html_url":"https://github.com/IDLE-Max","followers_url":"https://api.github.com/users/IDLE-Max/followers","following_url":"https://api.github.com/users/IDLE-Max/following{/other_user}","gists_url":"https://api.github.com/users/IDLE-Max/gists{/gist_id}","starred_url":"https://api.github.com/users/IDLE-Max/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IDLE-Max/subscriptions","organizations_url":"https://api.github.com/users/IDLE-Max/orgs","repos_url":"https://api.github.com/users/IDLE-Max/repos","events_url":"https://api.github.com/users/IDLE-Max/events{/privacy}","received_events_url":"https://api.github.com/users/IDLE-Max/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-27T09:49:16Z","updated_at":"2016-10-27T09:49:16Z","closed_at":null,"body":"Hi,\r\n\r\nI have an issue with an oracle connection.\r\n\r\n> The SQL being executed was: SELECT COUNT(*) FROM \"VT_COUREUR\" \"cou\" LEFT JOIN \"VT_PAYS\" \"pay\" ON pay.CODE_TDF = cou.CODE_TDF\r\n↵\r\nCaused by: Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception\r\nError Code : 904\r\nError Message : ORA-00904: \"COU\".\"CODE_TDF\": invalid identifier\r\nPosition : 84\r\nStatement : SELECT COUNT(*) FROM \"VT_COUREUR\" \"cou\" LEFT JOIN \"VT_PAYS\" \"pay\" ON pay.CODE_TDF = cou.CODE_TDF\r\nBindings : []\r\n\r\nAnd here is my code :\r\n\r\n`$query = Coureur::find()->from('VT_COUREUR cou')\r\n                                ->join(\"left join\",'VT_PAYS pay','pay.CODE_TDF = cou.CODE_TDF');`"}}
{"actor":{"display_login":"IDLE-Max"}}