this post was submitted on 03 Jun 2023
4 points (100.0% liked)

Lemmy Support

157 readers
3 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
dessalines@lemmy.ml
4
Admin user email verification (lemmy.click)
submitted 1 year ago by Lodion@lemmy.click to c/lemmy_support@lemmy.ml
20 comments fedilink hide all child comments
 

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?

you are viewing a single comment's thread
view the rest of the comments
[–] Lodion@lemmy.click 1 points 1 year ago (1 children)

Sorry Chris, I was figuring that out as I went. It looks like a postgres syntax error but the command matches what I used.

If you run "SELECT * from local_user;" do you get output showing your list of registered users? Perhaps you're not attached to the lemmy database?

[–] chrisamoody@thediscussion.site 1 points 1 year ago (1 children)

Yes, the Select did work, it was just the updates that didn't work.

[–] Lodion@lemmy.click 1 points 1 year ago (1 children)

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;"

[–] chrisamoody@thediscussion.site 1 points 1 year ago (1 children)

"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.

[–] Lodion@lemmy.click 1 points 1 year ago* (last edited 1 year ago) (1 children)

I've just taken a look at your instance... you're running a slightly older version. I'm guessing the DB schema has changed.

Does "SELECT * from local_user.id;" get you a list of users? You may need to update the other references to match whatever the old DB schema is.

[–] chrisamoody@thediscussion.site 1 points 1 year ago (1 children)

no it doesn't work. "ERROR: relation "local_user.id" does not exist LINE 1: SELECT * from local_user.id;"

[–] chrisamoody@thediscussion.site 1 points 1 year ago (1 children)

My instance is only 4 days old, how do I update it?

[–] chrisamoody@thediscussion.site 1 points 1 year ago

updated my instance, no change however as far as the database is concerned.