DELETE /#account_id/groups/#member_group_id/members returning error with SQL query

  • 1
  • Problem
  • Updated 2 years ago
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: answered via email

Running a delete (removing group members) is returning a server error with the SQL query. 

emma: err removing group members: emma: api error:
    "error": "(ProgrammingError) column \"values\" does not exist\nLINE 2: ...LETE FROM member_group_member WHERE member_id = ANY(VALUES )\n                                                               ^\n '\\n                WITH deleted AS (DELETE FROM member_group_member WHERE member_id = ANY(VALUES )\\n                AND member_group_id = %(member_group_id)s\\n                RETURNING member_id)\\n                SELECT deleted.member_id, member.member_status_id FROM deleted\\n                JOIN member ON member.member_id = deleted.member_id WHERE member.deleted_at IS NULL;\\n            ' {'member_group_id': #######}"
Photo of Umbel


  • 1 Post
  • 0 Reply Likes

Posted 2 years ago

  • 1

There are no replies.