Lodion 🇦🇺

Main account is here

  • 2 Posts
  • 16 Comments
Joined 1 year ago
cake
Cake day: June 3rd, 2023

help-circle










  • Thanks for digging that up. Had been one of my outstanding questions. I agree with the initial requestor of that issue; it will be a major source of friction for users migrating to Lemmy from Reddit.

    I’d like to be able to at least manually trigger the retrieval of a set of posts/comments as a user. Otherwise as the requestor noted, its going to make interacting with “new” communities difficult and unintuitive if you can’t see comments from before when it was synced to your local instance.




  • Ok, figured it out myself. For anyone else that needs it…

    Run a shell within the postgres docker container:

    docker exec -it <sitename>_postgres_1 sh

    Connect to the postgres service:

    psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy

    Connect to the lemmy database:

    \c lemmy

    Then the user table: \d local_user

    Find the user ID of the account you want to manually toggle, probably #1:

    SELECT * from local_user;

    Then update the email_verified and _accepted_application flag on the first account:

    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 = 3; UPDATE 1 lemmy=# UPDATE local_user SET email_verified = ‘t’, email_verified= ‘t’ WHERE id = 3; UPDATE 1 lemmy=#