Hi, I'm having this same issue. I moved over from the Lemmy instance using the generated code and got a generic error message when I tried to create my account, but the account was still created. However, I am being asked to verify my email like OP, and I am receiving the following error whenever I try to log in through any third-party Android app:
Client Error. Code: 400. Message: No row was found when one was required.