I’ve hit an issue with Lemmy. Initial startup was fine… I created my admin user and logged in. Then I created this account.
Third account I went to test with failed to login… then my other accounts also failed, so I rebooted.
Now when I try to log into my admin account, it just spins forever. Checking logs, I see this:
lemmy_server::api_routes_websocket: email_not_verified: email_not_verified
Can anyone tell me how I can manually flag my admin account as having been email verified already?

It seems that the query that Lodion shared has the wrong single quote character,
‘rather than'. Try using it with the latter, I had the same issue as you and this was what fixed it.yes, I should have realized that. That worked! Thank you @prothy@lemmy.ml
Now it worked, thanks!