Spyke

Replies

lemmy

Comment on

Removing accounts

This probably needs verification, so run at your own risk!

The SQL statement to delete would be: DELETE from person where name = '...'

person is the table of users.

name = '...' is the condition for the row that is to be deleted.

You can also modify the condition to, for example, delete a user using the id instead of their name (username).

Here's a link to the "schema" of the person table as generated by the backend code.

Comment on

How to subscribe to a community that isn't local?

Assuming you're viewing on mobile, at the top of the page, there should be a Sidebar button. Click that and it will expand the sidebar. There should now be a Subscribe button for you to subscribe to the community.

Note that the URL should look something like <local instance url>/c/<remote channel>@<remote instance hostname>. For example, my local instance is Beehaw too and I'm trying to view AskLemmy on lemmy.ml, so it should be something like beehaw.org/c/[email protected]

Comment on

Two issues I'm running into

In the search bar in the side drawer, you should be able to search for something like connect or lemmyconnect. Give it a few seconds to search and load up the search results. One this community shows up, you should be able to click it!

The screenshot you're sharing is the raw markup of Beehaw's custom error page. I think it's getting rendered because it's a different result from what other "typical" Lemmy instance would return in an error - either a status code or a specific error string. You can swipe it down to return to the previous view I'm pretty sure.

You reached the end