chrisamoody

joined 2 years ago
sorted by: new top controversial old
Admin user email verification in c/lemmy_support@lemmy.ml
[–] chrisamoody@thediscussion.site 1 points 1 year ago

yes, I should have realized that. That worked! Thank you @prothy@lemmy.ml

1
Issues with emails not verified (thediscussion.site)
 

Having an issue with logging in on alternate browsers due to email isn't verified. Would it be okay to export the database, manually make the change and then re-import it? Or could I connect to the database from a program on my computer to make the changes?

Admin user email verification in c/lemmy_support@lemmy.ml
[–] chrisamoody@thediscussion.site 0 points 1 year ago (3 children)

Thanks for this breakdown, I seem to be having issues with the update statements: 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". 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_applicat... ^ HINT: Perhaps you meant to reference the column "local_user.id". lemmy=# UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 3; UPDATE 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". lemmy-#