[Bug]: Cannot leave mod team

[kevinhikaruevans]

Requirements

• Is this a bug report? For questions or discussions use https://lemmy.ml/c/lemmy_support
• Did you check to see if this issue already exists?
• Is this only a single bug? Do not put multiple bugs in one issue.
• Is this a backend issue? Use the lemmy-ui repo for UI / frontend issues.

Summary

I press "leave mod team" and nothing happens: no feedback, the page just sits there. I assume this is a backend issue since the frontend behavior is mostly OK, it's just the endpoint failing.

Steps to Reproduce

1. Be mod in a community
2. Press "leave mod team", press "yes"
3. Observe nothing happens

Technical Details

The POST to https://lemmy.world/api/v3/community/mod returns a 400, with this FK error:

insert or update on table "mod_add_community" violates foreign key constraint "mod_add_community_other_person_id_fkey"

Version

BE: 0.18.2-1-g68276b2f9

Lemmy Instance URL

lemmy.world

[lionirdeadman]

I believe this bug should be fixed by LemmyNet/lemmy-ui#1929

Please feel free to re-open this issue once lemmy.world has updated to 0.18.3 if that hasn't fixed it.

[lionirdeadman]

@RocketDerp The code is in the pull request I made and linked to fix this problem. I tested it myself.