{"action":"created","issue":{"url":"https://api.github.com/repos/ckan/ckan/issues/2291","labels_url":"https://api.github.com/repos/ckan/ckan/issues/2291/labels{/name}","comments_url":"https://api.github.com/repos/ckan/ckan/issues/2291/comments","events_url":"https://api.github.com/repos/ckan/ckan/issues/2291/events","html_url":"https://github.com/ckan/ckan/issues/2291","id":57917387,"number":2291,"title":"sql syntax error when I create dataset via RestApi","user":{"login":"Jan-Marcek","id":5822680,"avatar_url":"https://avatars.githubusercontent.com/u/5822680?v=3","gravatar_id":"","url":"https://api.github.com/users/Jan-Marcek","html_url":"https://github.com/Jan-Marcek","followers_url":"https://api.github.com/users/Jan-Marcek/followers","following_url":"https://api.github.com/users/Jan-Marcek/following{/other_user}","gists_url":"https://api.github.com/users/Jan-Marcek/gists{/gist_id}","starred_url":"https://api.github.com/users/Jan-Marcek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jan-Marcek/subscriptions","organizations_url":"https://api.github.com/users/Jan-Marcek/orgs","repos_url":"https://api.github.com/users/Jan-Marcek/repos","events_url":"https://api.github.com/users/Jan-Marcek/events{/privacy}","received_events_url":"https://api.github.com/users/Jan-Marcek/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"joetsoi","id":241130,"avatar_url":"https://avatars.githubusercontent.com/u/241130?v=3","gravatar_id":"","url":"https://api.github.com/users/joetsoi","html_url":"https://github.com/joetsoi","followers_url":"https://api.github.com/users/joetsoi/followers","following_url":"https://api.github.com/users/joetsoi/following{/other_user}","gists_url":"https://api.github.com/users/joetsoi/gists{/gist_id}","starred_url":"https://api.github.com/users/joetsoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joetsoi/subscriptions","organizations_url":"https://api.github.com/users/joetsoi/orgs","repos_url":"https://api.github.com/users/joetsoi/repos","events_url":"https://api.github.com/users/joetsoi/events{/privacy}","received_events_url":"https://api.github.com/users/joetsoi/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-02-17T12:18:00Z","updated_at":"2015-02-17T12:52:23Z","closed_at":null,"body":"Hi, \r\n\r\nPrerequisites:\r\nckan 2.2.1 with no record. \r\nsteps via RestApi:\r\n1. create organization\r\n2. create dataset owned by organization created in 1\r\n\r\nI get this:\r\n\r\n```\r\n[Tue Feb 17 13:12:42 2015] [error] [client ::1] Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) operator does not exist: text = text[]\r\n[Tue Feb 17 13:12:42 2015] [error] [client ::1] LINE 3: WHERE \"group\".id = ARRAY['14ea4a7d-0380-45a5-9226-afe3272bed...\r\n[Tue Feb 17 13:12:42 2015] [error] [client ::1]                          ^\r\n[Tue Feb 17 13:12:42 2015] [error] [client ::1] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\r\n[Tue Feb 17 13:12:42 2015] [error] [client ::1]  'SELECT \"group\".id AS group_id, \"group\".name AS group_name, \"group\".title AS group_title, \"group\".type AS group_type, \"group\".description AS group_description, \"group\".image_url AS group_image_url, \"group\".created AS group_created, \"group\".is_organization AS group_is_organization, \"group\".approval_status AS group_approval_status, \"group\".state AS group_state, \"group\".revision_id AS group_revision_id \\\\nFROM \"group\" \\\\nWHERE \"group\".id = %(id_1)s \\\\n LIMIT %(param_1)s' {'id_1': [u'14ea4a7d-0380-45a5-9226-afe3272bed3c'], 'param_1': 1}\r\n\r\n``` \r\n\r\nBu when I run it second time then it works with no problem.\r\n\r\nThanks for your help\r\n"},"comment":{"url":"https://api.github.com/repos/ckan/ckan/issues/comments/74663027","html_url":"https://github.com/ckan/ckan/issues/2291#issuecomment-74663027","issue_url":"https://api.github.com/repos/ckan/ckan/issues/2291","id":74663027,"user":{"login":"Jan-Marcek","id":5822680,"avatar_url":"https://avatars.githubusercontent.com/u/5822680?v=3","gravatar_id":"","url":"https://api.github.com/users/Jan-Marcek","html_url":"https://github.com/Jan-Marcek","followers_url":"https://api.github.com/users/Jan-Marcek/followers","following_url":"https://api.github.com/users/Jan-Marcek/following{/other_user}","gists_url":"https://api.github.com/users/Jan-Marcek/gists{/gist_id}","starred_url":"https://api.github.com/users/Jan-Marcek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jan-Marcek/subscriptions","organizations_url":"https://api.github.com/users/Jan-Marcek/orgs","repos_url":"https://api.github.com/users/Jan-Marcek/repos","events_url":"https://api.github.com/users/Jan-Marcek/events{/privacy}","received_events_url":"https://api.github.com/users/Jan-Marcek/received_events","type":"User","site_admin":false},"created_at":"2015-02-17T12:52:23Z","updated_at":"2015-02-17T12:52:23Z","body":"BUT the stacktrace is from a ckan log. It is NOT from the extension log."}}