coffeeisnotlatte

joined 1 year ago
[–] coffeeisnotlatte@latte.isnot.coffee 2 points 1 year ago (1 children)

Not super easily. It can be done by querying the postgresql dabase, but there is no built-in method to do it using the browser interface at the moment. When anyone from any instance does report them, you will see the report.

Do you have an example of a query I could use? I'm a bit rusty with databases :) with an example I can get chatgpt to build me something better

[–] coffeeisnotlatte@latte.isnot.coffee 2 points 1 year ago* (last edited 1 year ago)

I see, occasionally I get reports from local users about something elsewhere from a 'foreign' user... which I can then delete. I assume that's not deleting from their server?

For example I get a report from a local user about a lemmy.ml user with a post in lemmy.world

 

After the bot attacks I've cleaned up and implemented some additional measures thanks to some helpful users, but I'd also like to monitor the situation in case someone from my server decides to go on a spam rampage...

Is there a way to:

  1. Easily get a list of comments from all my users locally and across the 'verse?
  2. If I purge/ban these users, is there a protocol for letting other Lemmy admins know? I assume I have no power to delete things from their instances (just my copy of their instance?)
3
We seem to be memleaking (latte.isnot.coffee)
submitted 1 year ago* (last edited 1 year ago) by coffeeisnotlatte@latte.isnot.coffee to c/lemmy_support@lemmy.ml
 

On 0.17.4, has anyone else noticed this? The last few days the server chewed through 2GB of RAM... then yesterday it chewed through 4GB after an upgrade in about 2 days and now seems to be chewing through about 100MB/hour with no sign of stopping.

I put in a bug report but thought I'd ask if anyone else is having the issue too: https://github.com/LemmyNet/lemmy/issues/3183

 

I'm not on either the instance reported from or the instance reported to, I have my own instance. Why am I getting these reports/would care about them?

[–] coffeeisnotlatte@latte.isnot.coffee 3 points 1 year ago (1 children)

It's like everyone saw what Twitter did, and thought they could get away with doing the same

I could live without youtube for sure, I have more of a Reddit problem than a YouTube problem... but it seems they fixed that for me.

Fair enough you have me beat :')

[–] coffeeisnotlatte@latte.isnot.coffee 5 points 1 year ago (2 children)

latte.isnot.coffee is mine, I think it's the best end for your name you can hope for ;)

[–] coffeeisnotlatte@latte.isnot.coffee 4 points 1 year ago (1 children)

Are you guys seeing the trainwreck in this AMA?

[–] coffeeisnotlatte@latte.isnot.coffee 18 points 1 year ago (2 children)

iamthatis (Apollo) even said he could do it with a bit more time after the initial shock, some negotiation etc, he was willing to try if Reddit would throw him anything at all so it was possible. But Reddit instead shut down all communication then lied about what happened

[–] coffeeisnotlatte@latte.isnot.coffee 4 points 1 year ago (1 children)

If you're old enough to get around those controls, you're old enough to view porn, frankly. It's like a rite of passage that I went through 15 years ago... the parental controls were also much worse then, so it's arguably more effective now.

Was it lemmy.org.uk? Not sure what happened to that one, I was there too... spun my own up in the end

[–] coffeeisnotlatte@latte.isnot.coffee 2 points 1 year ago* (last edited 1 year ago)

You're not the first, you just don't get the full list of comments until you subscribe from your home instance... and I'm unsure if you get earlier comments than when you did that. It's a bit of a pain point

You don't need to just search, you need to have at least one member subscribed

 

As you can see in the screenshot, most communities I put in yesterday (except this one) have zero comments. Any idea why that would be? If I go to the instance itself I see comments

 

Testing 123

view more: next ›