Skip Navigation
Lemmy Support @lemmy.ml Lodion 🇦🇺 @lemmy.click

Admin user email verification

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?

18

You're viewing part of a thread.

Show Context
18 comments
  • Not sure what to suggest, sorry I'm not a DBA :(

    To make it clear, here is the command I ran enclosed with "

    "UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 1;"

    • "lemmy=# UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 1; ERROR: column "‘t’" does not exist LINE 1: UPDATE local_user SET email_verified = ‘t’, accepted_applica... ^ HINT: Perhaps you meant to reference the column "local_user.id"." This was its response.

18 comments