Skip Navigation

Posts
3
Comments
11
Joined
3 yr. ago

Podcaster, Author, Owner of The Discussion Site

  • seems that still won't let me log in :(

  • thanks, any idea if properly configured if Lemmy knows how to send smtp based email?

  • how do you disable that?

  • so yeah, even on the same computer with a different browser I can't log in :( (using same password)

  • Lemmy Support @lemmy.ml

    Issues with emails not verified

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

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

  • no it doesn't work. "ERROR: relation "local_user.id" does not exist LINE 1: SELECT * from 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_applica... ^ HINT: Perhaps you meant to reference the column "local_user.id"." This was its response.

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

  • 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-#

  • Lemmy Support @lemmy.ml

    Verifying account

  • Lemmy Support @lemmy.ml

    mastodon to Lemmy message