{"action":"opened","issue":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/8700","repository_url":"https://api.github.com/repos/cakephp/cakephp","labels_url":"https://api.github.com/repos/cakephp/cakephp/issues/8700/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/cakephp/issues/8700/comments","events_url":"https://api.github.com/repos/cakephp/cakephp/issues/8700/events","html_url":"https://github.com/cakephp/cakephp/issues/8700","id":150786320,"number":8700,"title":"Cakephp 3 - 'Find where id' does not work","user":{"login":"lupuswwww","id":3995136,"avatar_url":"https://avatars.githubusercontent.com/u/3995136?v=3","gravatar_id":"","url":"https://api.github.com/users/lupuswwww","html_url":"https://github.com/lupuswwww","followers_url":"https://api.github.com/users/lupuswwww/followers","following_url":"https://api.github.com/users/lupuswwww/following{/other_user}","gists_url":"https://api.github.com/users/lupuswwww/gists{/gist_id}","starred_url":"https://api.github.com/users/lupuswwww/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lupuswwww/subscriptions","organizations_url":"https://api.github.com/users/lupuswwww/orgs","repos_url":"https://api.github.com/users/lupuswwww/repos","events_url":"https://api.github.com/users/lupuswwww/events{/privacy}","received_events_url":"https://api.github.com/users/lupuswwww/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-04-25T08:28:39Z","updated_at":"2016-04-25T08:28:39Z","closed_at":null,"body":"use Cake\\ORM\\TableRegistry;\r\n\r\n**This works**\r\n$shortInfos = TableRegistry::get('ShortInfos');\r\n$shortInfo = $shortInfos->get(1);\r\n\r\n**This does not work**\r\n$shortInfos = TableRegistry::get('ShortInfos');\r\n$shortInfo = $shortInfos\r\n    ->find()\r\n    ->where(['id' => 1])\r\n    ->first();\r\n\r\n**A text error**\r\nError: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous \r\nSELECT ShortInfos.id AS `ShortInfos__id`, ShortInfos.title AS `ShortInfos__title`, ShortInfos.text AS `ShortInfos__text`, ShortInfos.doc1 AS `ShortInfos__doc1`, ShortInfos.position AS `ShortInfos__position`, ShortInfos_title_translation.id AS `ShortInfos_title_translation__id`, ShortInfos_title_translation.locale AS `ShortInfos_title_translation__locale`, ShortInfos_title_translation.model AS `ShortInfos_title_translation__model`, ShortInfos_title_translation.foreign_key AS `ShortInfos_title_translation__foreign_key`, ShortInfos_title_translation.field AS `ShortInfos_title_translation__field`, ShortInfos_title_translation.content AS `ShortInfos_title_translation__content`, ShortInfos_text_translation.id AS `ShortInfos_text_translation__id`, ShortInfos_text_translation.locale AS `ShortInfos_text_translation__locale`, ShortInfos_text_translation.model AS `ShortInfos_text_translation__model`, ShortInfos_text_translation.foreign_key AS `ShortInfos_text_translation__foreign_key`, ShortInfos_text_translation.field AS `ShortInfos_text_translation__field`, ShortInfos_text_translation.content AS `ShortInfos_text_translation__content` FROM short_infos ShortInfos LEFT JOIN i18n ShortInfos_title_translation ON (ShortInfos_title_translation.model = :c0 AND ShortInfos_title_translation.field = :c1 AND ShortInfos_title_translation.locale = :c2 AND ShortInfos.id = (ShortInfos_title_translation.foreign_key)) LEFT JOIN i18n ShortInfos_text_translation ON (ShortInfos_text_translation.model = :c3 AND ShortInfos_text_translation.field = :c4 AND ShortInfos_text_translation.locale = :c5 AND ShortInfos.id = (ShortInfos_text_translation.foreign_key)) WHERE id = :c6 LIMIT 1\r\n\r\n\r\nWhy? Am I doing something wrong?\r\n\r\n\r\n\r\n\r\n\r\n\r\n"}}