{"action":"closed","issue":{"url":"https://api.github.com/repos/JosephSilber/bouncer/issues/221","repository_url":"https://api.github.com/repos/JosephSilber/bouncer","labels_url":"https://api.github.com/repos/JosephSilber/bouncer/issues/221/labels{/name}","comments_url":"https://api.github.com/repos/JosephSilber/bouncer/issues/221/comments","events_url":"https://api.github.com/repos/JosephSilber/bouncer/issues/221/events","html_url":"https://github.com/JosephSilber/bouncer/issues/221","id":264209412,"number":221,"title":"Exception at running an \"allow check\", in Oracle database [\"level keyword\" ; \"ORA-01788\"]","user":{"login":"Gaven-ar","id":13264122,"avatar_url":"https://avatars0.githubusercontent.com/u/13264122?v=4","gravatar_id":"","url":"https://api.github.com/users/Gaven-ar","html_url":"https://github.com/Gaven-ar","followers_url":"https://api.github.com/users/Gaven-ar/followers","following_url":"https://api.github.com/users/Gaven-ar/following{/other_user}","gists_url":"https://api.github.com/users/Gaven-ar/gists{/gist_id}","starred_url":"https://api.github.com/users/Gaven-ar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gaven-ar/subscriptions","organizations_url":"https://api.github.com/users/Gaven-ar/orgs","repos_url":"https://api.github.com/users/Gaven-ar/repos","events_url":"https://api.github.com/users/Gaven-ar/events{/privacy}","received_events_url":"https://api.github.com/users/Gaven-ar/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2017-10-10T12:30:21Z","updated_at":"2017-10-11T15:24:14Z","closed_at":"2017-10-11T15:24:14Z","author_association":"NONE","body":"Hello, I have a question / problem / error to solve. When I try to run the `Bouncer::allow` check (over an ability) I get a database error. The Laravel project is connected to an Oracle database, and seems like there's a conflict with the \"_level_\" column name, at the \"_role_\" table (that I assigned with another name).\r\n\r\n**The exception I get running the Bouncer ckecking is:**\r\n\r\n> ORA-01788: CONNECT BY clause required in this query block\r\n\r\nThat don't say much to me, but in the statement field there's a big query with the next segment:\r\n\r\n> or \"level\" < (select max(level) from\r\n\r\nSeems like is missing quotes on the second ocurrence of the \"level\" word.\r\n\r\n**How should I run the Bouncer check to avoid this error?**\r\n\r\nThank you. And congrats for the good job with this Laravel package."}}
{"actor":{"display_login":"JosephSilber"}}