Skip Navigation

Lodion 🇦🇺

@ Lodion @lemmy.click

Posts
3
Comments
34
Joined
3 yr. ago

Main account is here

  • Are comments supposed to backfill on posts?

    Jump

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

  • How to discover new communities within Lemmy?

    Jump

  • Browser works fine. But I'm not always at my PC. Seems like a missing feature in Jerboa?

  • How to discover new communities within Lemmy?

    Jump

  • Maybe I'm dumb, I can't find how to add a new community to my subscribed list in Jerboa.

  • Admin user email verification

    Jump

  • Sorry mate, I'm out of ideas.

  • Admin user email verification

    Jump

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

  • Admin user email verification

    Jump

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

  • Admin user email verification

    Jump

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

  • lemmy.ml is overloaded, use other instances instead

    Jump

  • Are there any published guidelines on the server requirements for an instance? I have my own instance running, seems to be working fine. But I'm reluctant to open it publically without an idea of if I'm setting myself up for failure or not.

    Related, is there a way to entirely disable image uploads to my instance? I'm ok with it being a "reader" instance, but don't want to be hosting content directly.

  • Deleted

    test post

    Jump

  • Test comment reply :)

  • Admin user email verification

    Jump

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

  • Admin user email verification

    Jump

  • Thats what I figured... I just have no idea how to do it. Can you point me to any info on how to do that? :)

  • Lemmy users be like

    Jump

  • The recommended ansible playbook, on a fresh Ubuntu 22.04 VM.

  • Lemmy users be like

    Jump

  • This is quite accurate. I've stood up my own lemmy instance... but hitting some pretty basic issues in the process. Not sure its ready for prime time.