{"action":"closed","issue":{"url":"https://api.github.com/repos/privacyidea/privacyidea/issues/518","repository_url":"https://api.github.com/repos/privacyidea/privacyidea","labels_url":"https://api.github.com/repos/privacyidea/privacyidea/issues/518/labels{/name}","comments_url":"https://api.github.com/repos/privacyidea/privacyidea/issues/518/comments","events_url":"https://api.github.com/repos/privacyidea/privacyidea/issues/518/events","html_url":"https://github.com/privacyidea/privacyidea/issues/518","id":182050744,"number":518,"title":"ProgrammingError while filtering audit log by success","user":{"login":"berndnicklas","id":4263918,"avatar_url":"https://avatars.githubusercontent.com/u/4263918?v=3","gravatar_id":"","url":"https://api.github.com/users/berndnicklas","html_url":"https://github.com/berndnicklas","followers_url":"https://api.github.com/users/berndnicklas/followers","following_url":"https://api.github.com/users/berndnicklas/following{/other_user}","gists_url":"https://api.github.com/users/berndnicklas/gists{/gist_id}","starred_url":"https://api.github.com/users/berndnicklas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/berndnicklas/subscriptions","organizations_url":"https://api.github.com/users/berndnicklas/orgs","repos_url":"https://api.github.com/users/berndnicklas/repos","events_url":"https://api.github.com/users/berndnicklas/events{/privacy}","received_events_url":"https://api.github.com/users/berndnicklas/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/privacyidea/privacyidea/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/privacyidea/privacyidea/milestones/28","html_url":"https://github.com/privacyidea/privacyidea/milestones/2.16%20Subscription%20Files","labels_url":"https://api.github.com/repos/privacyidea/privacyidea/milestones/28/labels","id":2054086,"number":28,"title":"2.16 Subscription Files","description":"Allow upload of subscription files for e.g. ownCloud Plugin or privacyIDEA Credential Provider.\r\nWill be viewed in Client Overview","creator":{"login":"cornelinux","id":1908620,"avatar_url":"https://avatars.githubusercontent.com/u/1908620?v=3","gravatar_id":"","url":"https://api.github.com/users/cornelinux","html_url":"https://github.com/cornelinux","followers_url":"https://api.github.com/users/cornelinux/followers","following_url":"https://api.github.com/users/cornelinux/following{/other_user}","gists_url":"https://api.github.com/users/cornelinux/gists{/gist_id}","starred_url":"https://api.github.com/users/cornelinux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cornelinux/subscriptions","organizations_url":"https://api.github.com/users/cornelinux/orgs","repos_url":"https://api.github.com/users/cornelinux/repos","events_url":"https://api.github.com/users/cornelinux/events{/privacy}","received_events_url":"https://api.github.com/users/cornelinux/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":3,"state":"open","created_at":"2016-10-07T07:42:46Z","updated_at":"2016-10-11T13:51:07Z","due_on":"2016-11-10T00:00:00Z","closed_at":null},"comments":3,"created_at":"2016-10-10T15:54:34Z","updated_at":"2016-10-11T13:51:07Z","closed_at":"2016-10-11T13:51:07Z","body":"# Versions\r\n\r\nprivacyIDEA installation method:\r\n- [x] from source / github (version from august, 8)\r\n- [ ] in virtualenv\r\n- [x] Debian --> Jessie\r\n- [ ] Ubuntu\r\n\r\nDatabase:\r\n- [x] PostgreSQL\r\n\r\n# What did you try to do?\r\nFilter audit log by success, e.g. by \"1\" (=success).\r\n\r\n# What outcome did you expect?\r\nOnly show successful actions.\r\n\r\n# What outcome did you experience?\r\nProgrammingError\r\n\r\n# Log file\r\n(ProgrammingError) operator does not exist: integer ~~ unknown LINE 4: WHERE pidea_audit.success LIKE '%1%' AND pidea_audit.action ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. 'SELECT count(*) AS count_1 \\nFROM (SELECT pidea_audit.id AS pidea_audit_id \\nFROM pidea_audit \\nWHERE pidea_audit.success LIKE %(success_1)s AND pidea_audit.action LIKE %(action_1)s) AS anon_1' {'success_1': u'%1%', 'action_1': u'%/validate%'}\r\n\r\nCan anybody reproduce this? Could this be related with the PostgreSQL database we are using?\r\n\r\nBest regards,\r\n\r\nBernd"}}
{"actor":{"display_login":"cornelinux"}}