{"action":"created","issue":{"url":"https://api.github.com/repos/jekkos/opensourcepos/issues/149","labels_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/149/labels{/name}","comments_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/149/comments","events_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/149/events","html_url":"https://github.com/jekkos/opensourcepos/issues/149","id":106603116,"number":149,"title":"Items view: if searched text contains a ' the search will not work","user":{"login":"daN4cat","id":636048,"avatar_url":"https://avatars.githubusercontent.com/u/636048?v=3","gravatar_id":"","url":"https://api.github.com/users/daN4cat","html_url":"https://github.com/daN4cat","followers_url":"https://api.github.com/users/daN4cat/followers","following_url":"https://api.github.com/users/daN4cat/following{/other_user}","gists_url":"https://api.github.com/users/daN4cat/gists{/gist_id}","starred_url":"https://api.github.com/users/daN4cat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daN4cat/subscriptions","organizations_url":"https://api.github.com/users/daN4cat/orgs","repos_url":"https://api.github.com/users/daN4cat/repos","events_url":"https://api.github.com/users/daN4cat/events{/privacy}","received_events_url":"https://api.github.com/users/daN4cat/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jekkos/opensourcepos/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/jekkos/opensourcepos/milestones/1","html_url":"https://github.com/jekkos/opensourcepos/milestones/2.3.3","labels_url":"https://api.github.com/repos/jekkos/opensourcepos/milestones/1/labels","id":1208969,"number":1,"title":"2.3.3","description":null,"creator":{"login":"jekkos","id":576234,"avatar_url":"https://avatars.githubusercontent.com/u/576234?v=3","gravatar_id":"","url":"https://api.github.com/users/jekkos","html_url":"https://github.com/jekkos","followers_url":"https://api.github.com/users/jekkos/followers","following_url":"https://api.github.com/users/jekkos/following{/other_user}","gists_url":"https://api.github.com/users/jekkos/gists{/gist_id}","starred_url":"https://api.github.com/users/jekkos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jekkos/subscriptions","organizations_url":"https://api.github.com/users/jekkos/orgs","repos_url":"https://api.github.com/users/jekkos/repos","events_url":"https://api.github.com/users/jekkos/events{/privacy}","received_events_url":"https://api.github.com/users/jekkos/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":13,"state":"open","created_at":"2015-07-15T10:35:35Z","updated_at":"2015-09-16T12:38:41Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2015-09-15T17:14:31Z","updated_at":"2015-09-16T16:45:18Z","closed_at":null,"body":"1. Go to Items view\r\n2. Create an item with name containing a '  (e.g. doesn't work)\r\n3. Search for the item, suggestion prompts the item but selecting it doesn't list the item\r\n\r\nSame applies if a Supplier has a ' .\r\n\r\nIt's quite common in certain languages like French, Italian and at times in English to have ' ."},"comment":{"url":"https://api.github.com/repos/jekkos/opensourcepos/issues/comments/140798775","html_url":"https://github.com/jekkos/opensourcepos/issues/149#issuecomment-140798775","issue_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/149","id":140798775,"user":{"login":"daN4cat","id":636048,"avatar_url":"https://avatars.githubusercontent.com/u/636048?v=3","gravatar_id":"","url":"https://api.github.com/users/daN4cat","html_url":"https://github.com/daN4cat","followers_url":"https://api.github.com/users/daN4cat/followers","following_url":"https://api.github.com/users/daN4cat/following{/other_user}","gists_url":"https://api.github.com/users/daN4cat/gists{/gist_id}","starred_url":"https://api.github.com/users/daN4cat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daN4cat/subscriptions","organizations_url":"https://api.github.com/users/daN4cat/orgs","repos_url":"https://api.github.com/users/daN4cat/repos","events_url":"https://api.github.com/users/daN4cat/events{/privacy}","received_events_url":"https://api.github.com/users/daN4cat/received_events","type":"User","site_admin":false},"created_at":"2015-09-16T16:45:18Z","updated_at":"2015-09-16T16:45:18Z","body":"Therefore I guess I should add something $this->db->escape_like_str($search) or check if like / or_like are doing that already. This is probably connected with #39 issue. Am I right?"}}