{"action":"created","issue":{"url":"https://api.github.com/repos/gabordemooij/redbean/issues/460","labels_url":"https://api.github.com/repos/gabordemooij/redbean/issues/460/labels{/name}","comments_url":"https://api.github.com/repos/gabordemooij/redbean/issues/460/comments","events_url":"https://api.github.com/repos/gabordemooij/redbean/issues/460/events","html_url":"https://github.com/gabordemooij/redbean/issues/460","id":98497956,"number":460,"title":"possible edge case","user":{"login":"r3wt","id":4483325,"avatar_url":"https://avatars.githubusercontent.com/u/4483325?v=3","gravatar_id":"","url":"https://api.github.com/users/r3wt","html_url":"https://github.com/r3wt","followers_url":"https://api.github.com/users/r3wt/followers","following_url":"https://api.github.com/users/r3wt/following{/other_user}","gists_url":"https://api.github.com/users/r3wt/gists{/gist_id}","starred_url":"https://api.github.com/users/r3wt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r3wt/subscriptions","organizations_url":"https://api.github.com/users/r3wt/orgs","repos_url":"https://api.github.com/users/r3wt/repos","events_url":"https://api.github.com/users/r3wt/events{/privacy}","received_events_url":"https://api.github.com/users/r3wt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-01T01:50:18Z","updated_at":"2015-08-02T21:25:14Z","closed_at":null,"body":"```php\r\nR::getAll(\r\n\t'SELECT id,title,thumbnail_file \r\n\tFROM video \r\n\tWHERE title LIKE:title OR title LIKE\"% %\" AND id<>:id \r\n\tLIMIT 6',\r\n\t[':title'=>'\"%'.$title.'%\"',':id'=>$id]\r\n);\r\n```\r\n```\r\nThe application could not run because of the following error:\r\nDetails\r\nType: RedBeanPHP\\RedException\\SQL\r\nMessage: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\r\nFile: /usr/share/nginx/libs/vendor/gabordemooij/redbean/RedBeanPHP/Driver/RPDO.php\r\nLine: 176\r\n```"},"comment":{"url":"https://api.github.com/repos/gabordemooij/redbean/issues/comments/127073135","html_url":"https://github.com/gabordemooij/redbean/issues/460#issuecomment-127073135","issue_url":"https://api.github.com/repos/gabordemooij/redbean/issues/460","id":127073135,"user":{"login":"gabordemooij","id":89826,"avatar_url":"https://avatars.githubusercontent.com/u/89826?v=3","gravatar_id":"","url":"https://api.github.com/users/gabordemooij","html_url":"https://github.com/gabordemooij","followers_url":"https://api.github.com/users/gabordemooij/followers","following_url":"https://api.github.com/users/gabordemooij/following{/other_user}","gists_url":"https://api.github.com/users/gabordemooij/gists{/gist_id}","starred_url":"https://api.github.com/users/gabordemooij/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gabordemooij/subscriptions","organizations_url":"https://api.github.com/users/gabordemooij/orgs","repos_url":"https://api.github.com/users/gabordemooij/repos","events_url":"https://api.github.com/users/gabordemooij/events{/privacy}","received_events_url":"https://api.github.com/users/gabordemooij/received_events","type":"User","site_admin":false},"created_at":"2015-08-02T21:25:14Z","updated_at":"2015-08-02T21:25:14Z","body":"Try adding a space between LIKE and :title - the SQL parser doesn't seem to understand your Query, it thinks LIKE:title is a single token."}}