{"action":"created","issue":{"url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/173","labels_url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/173/labels{/name}","comments_url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/173/comments","events_url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/173/events","html_url":"https://github.com/bllim/laravel4-datatables-package/issues/173","id":48264429,"number":173,"title":"Search not working","user":{"login":"rajeev-tx","id":7393884,"avatar_url":"https://avatars.githubusercontent.com/u/7393884?v=3","gravatar_id":"","url":"https://api.github.com/users/rajeev-tx","html_url":"https://github.com/rajeev-tx","followers_url":"https://api.github.com/users/rajeev-tx/followers","following_url":"https://api.github.com/users/rajeev-tx/following{/other_user}","gists_url":"https://api.github.com/users/rajeev-tx/gists{/gist_id}","starred_url":"https://api.github.com/users/rajeev-tx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rajeev-tx/subscriptions","organizations_url":"https://api.github.com/users/rajeev-tx/orgs","repos_url":"https://api.github.com/users/rajeev-tx/repos","events_url":"https://api.github.com/users/rajeev-tx/events{/privacy}","received_events_url":"https://api.github.com/users/rajeev-tx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2014-11-10T13:31:28Z","updated_at":"2015-02-22T16:35:19Z","closed_at":null,"body":"Laravel 4.1\r\nbllim/datatables 1.4.1\r\nPHP version is : 5.3.10\r\n\r\nThis is exception i am getting,\r\n\r\n{\"error\":{\"type\":\"Symfony\\\\Component\\\\Debug\\\\Exception\\\\FatalErrorException\",\"message\":\"Cannot access protected property Bllim\\\\Datatables\\\\Datatables::$input\",\"file\":\"\\\\vendor\\\\bllim\\\\datatables\\\\src\\\\Bllim\\\\Datatables\\\\Datatables.php\",\"line\":565}}\r\n\r\nThis is js code,\r\nvar table = jQuery('#announcements').dataTable({\r\n\t\t\t\t \"processing\": true,\r\n\t\t         \"serverSide\": true,\r\n\t\t         \"columnDefs\":[\r\n\t\t                        {\"orderable\":false,\"targets\":7}\r\n\t\t                      ],\r\n\t\t\t     \"ajax\": \"{{ route('list/announcements','active') }}\"\r\n\t\t\t});\r\n\r\nThis is php code,\r\n\r\n$announcements = Announcements::select(array('id','title'))->whereRaw(\"'\".date('Y-m-d').\"' between active_at and expires_at\");\t\t\r\n\t\treturn Datatables::of($announcements)->make();"},"comment":{"url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/comments/75443787","html_url":"https://github.com/bllim/laravel4-datatables-package/issues/173#issuecomment-75443787","issue_url":"https://api.github.com/repos/bllim/laravel4-datatables-package/issues/173","id":75443787,"user":{"login":"mehrdd","id":1578360,"avatar_url":"https://avatars.githubusercontent.com/u/1578360?v=3","gravatar_id":"","url":"https://api.github.com/users/mehrdd","html_url":"https://github.com/mehrdd","followers_url":"https://api.github.com/users/mehrdd/followers","following_url":"https://api.github.com/users/mehrdd/following{/other_user}","gists_url":"https://api.github.com/users/mehrdd/gists{/gist_id}","starred_url":"https://api.github.com/users/mehrdd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mehrdd/subscriptions","organizations_url":"https://api.github.com/users/mehrdd/orgs","repos_url":"https://api.github.com/users/mehrdd/repos","events_url":"https://api.github.com/users/mehrdd/events{/privacy}","received_events_url":"https://api.github.com/users/mehrdd/received_events","type":"User","site_admin":false},"created_at":"2015-02-22T16:35:19Z","updated_at":"2015-02-22T16:35:19Z","body":"I have a similar problem only in search (Laravel 5)\r\nMy Error:\r\n```\r\nQueryException in Connection.php line 614:\r\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key) LIKE ? or LOWER(value) LIKE ? or LOWER(type) LIKE ?)) AS count_row_table' at line 1 (SQL: select count(*) as aggregate from (select '1' as row from `settings` where (LOWER(key) LIKE %b% or LOWER(value) LIKE %b% or LOWER(type) LIKE %b%)) AS count_row_table)\r\n```"}}