Lemmy

13469 readers
59 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 5 years ago
MODERATORS
401
 
 

What am I missing?

402
 
 

So, I am working on building a couple of Lemmy sites with the intent of them being sort of community specific. Now, when I was reading setup it felt like establishing multiple lemmy sites in the same code base was possible.

Is this a configuration that is supported?

403
 
 

I'm running a small instance just for myself and a friend. We basically use it to access the Lemmy fediverse.

I was under the impression that our instance would not download imagery that was not hosted on it but the pict-rs "files" directory ended up with 45 gig of data which ultimately filled up the VPS storage space.

Is there a command that I can automate to prune this regularly or does anyone have a solution?

404
 
 

I'm on lemmy.ml, and I want to subscribe to https://lemmy.world/c/songaweek. There it says to put !songaweek@lemmy.world into search on my instance to subscribe, but it doesn't turn up anything. Anyone know why this might be, and/or how to work around it?

405
 
 

Due to the federated nature of Lemmy there's one small problem: if you link to a community (let's say https://lemmings.world/c/wwdits) the link takes people out of their instance.

On Lemmy it can be solved easily - use !wwdits@lemmings.world and the community opens on their own instance.

But the problem still exists outside Lemmy, let's say you write a blog post and link to some community - people who already use Lemmy will again be taken out of their instance.

And to solve this I created this project, available on https://lemmyverse.link and https://threadiverse.link (both are the exact same app).

Instead of https://lemmings.world/c/wwdits you link to https://lemmyverse.link/c/wwdits@lemmings.world and you're greeted with this:

A page letting you choose whether you want to continue to the link or set your home instance first

You can either continue directly if you don't care, or you can set your home instance and afterwards every link at https://lemmyverse.link will automatically be redirected to your preferred instance (with a small countdown allowing you to change your instance):

A page with a redirect to the target community

If enough people start linking using this service, it will greatly improve the experience for Lemmy users!

Let me know what you think!

Edit: Source code is here: https://github.com/RikudouSage/lemmyverse.link

406
 
 

I created an account on lemmy.world and it's all working fine through the webpage. However, when I try to login through any of the apps (connect, thunder, etc) it says "incorrect login".

407
14
submitted 2 years ago* (last edited 2 years ago) by rikudou@lemmings.world to c/lemmy@lemmy.ml
 
 

If you're running an instance and have direct access to the database, you can run some of these SQL queries on your database:

Local users with most comments

select p.name,
       p.display_name,
       (select count(id)
        from comment c
        where c.creator_id = p.id) as comments_count
from person p
where local = true
order by comments_count desc
;

Local users with most posts

select p.name,
       p.display_name,
       (select count(id)
        from post p2
        where p2.creator_id = p.id) as posts_count
from person p
where local = true
order by posts_count desc
;

People who disliked a specific comment

If your SQL client doesn't support parametric queries, you have to replace the question mark with the comment ID manually.

select p.actor_id
from person p
         inner join comment_like cl on cl.person_id = p.id
where cl.comment_id = ?
  and cl.score = -1;

People who disliked specific post

If your SQL client doesn't support parametric queries, you have to replace the question mark with the post ID manually.

select p.actor_id
from person p
         inner join post_like pl on p.id = pl.person_id
where pl.post_id = ?
  and pl.score = -1;

Most disliked posts of a user

If your SQL client doesn't support parametric queries, you have to replace the question mark with the username in single quotes (for example 'rikudou' for mine). Note that this query fails if there are multiple users with same username but on different instances, in that case you should replace (select id from person where name = ?) with (select id from person where actor_id = ?) and instead of username for the question mark you need to use the link to their profile (for example 'https://lemmings.world/u/rikudou' for mine).

select p.ap_id, p.id, count(pl.id) as dislikes
from post p
         inner join post_like pl on pl.post_id = p.id
where pl.score = -1
  and p.creator_id = (select id from person where name = ?)
group by p.ap_id, p.id
order by dislikes desc
;

Most disliked comments of a user

Read the instructions for Most disliked posts of a user above.

select c.ap_id, c.id, count(cl.id) as dislikes
from comment c
         inner join comment_like cl on cl.comment_id = c.id
where cl.score = -1
  and c.creator_id = (select id from person where name = ?)
group by c.ap_id, c.id
order by dislikes desc
;

Blocked communities by user

Read instructions for Most disliked posts of a user.

select c.actor_id
from community c
         inner join community_block cb on c.id = cb.community_id
where cb.person_id = (select id from person where name = ?)
;

Blocked users by user

Read instructions for Most disliked posts of a user.

select p.actor_id
from person p
         inner join person_block pb on p.id = pb.target_id
where pb.person_id = (select id from person where name = ?)
;

Which comments by a specific user were disliked by another specific user

If your SQL client doesn't support parametric queries, you have to replace the :yourUsername with the username in single quotes (for example 'rikudou' for mine), same for :dislikerUsername. For additional instructions read instructions for Most disliked posts of a user.

select c.ap_id, c.id
from comment c
         inner join comment_like cl on cl.comment_id = c.id
         inner join person p on p.id = cl.person_id
where cl.score = -1
  and c.creator_id = (select id from person where name = :yourUsername)
  and p.name = :dislikerUsername;

Only local votes for a comment

If your SQL client doesn't support parametric queries, you have to replace the question mark with the comment ID manually.

select c.ap_id,
       c.id,
       count(case cl.score when -1 then 1 end) as dislikes,
       count(case cl.score when 1 then 1 end)  as likes,
       sum(cl.score)                           as score
from comment_like cl
         inner join person p on cl.person_id = p.id
         inner join comment c on cl.comment_id = c.id
where p.local = true
  and cl.comment_id = ?
group by c.ap_id, c.id
;

Only local votes for a post

If your SQL client doesn't support parametric queries, you have to replace the question mark with the post ID manually.

select p.ap_id,
       p.id,
       count(case pl.score when -1 then 1 end) as dislikes,
       count(case pl.score when 1 then 1 end)  as likes,
       sum(pl.score)                           as score
from post_like pl
         inner join person pe on pl.person_id = pe.id
         inner join post p on pl.post_id = p.id
where pe.local = true
  and pl.post_id = ?
group by p.ap_id, p.id
;


Let me know if you want any other SQL queries and I might take a look into it!

Edit: Added more queries, I'll probably add more without announcing I did an edit from now on.

408
 
 

This morning I was forced to ban about 18 users for being obvious spambots. That deleted their content on my instance. Are they now banned on other instances, too? I'm just trying to figure out what the best process is for eliminating these spambots for good before they flood all of our feeds.

409
410
14
submitted 2 years ago* (last edited 2 years ago) by erranto@lemmy.world to c/lemmy@lemmy.ml
 
 

Hi I found out that it is possible to create a thread on a lemmy community using a mastodon account by mentioning the community handle. but the process is quite undocumented and unknown to many of us.

How Can I make a thread with a separate title and post body from an app like tusky?

how to make the community @ mention not appear on the title ?

Are there any propagation problems to be aware of ?

sometimes the post doesn't show on the community feed, or takes too long to show, or shows from another instance quicker than the one I have posted in. the post might have the correct creation timestamp but fails to show up on the lemmy community promptly.

411
391
submitted 2 years ago* (last edited 2 years ago) by mr_MADAFAKA@lemmy.ml to c/lemmy@lemmy.ml
 
 
412
 
 

Now that the PRs have been mostly merged, here's what the LemmyUI contribution graph looked like after Reddit went garbage overnight

413
 
 

Hey everyone, I figured that some new users might not know that comments and posts have a formatting standard called Markdown.
In simple terms, Markdown is a (semi)universal language that uses formatting symbols to give a certain style to a portion of text.
This quick guide can help you to write in a way that's more appealing and easy to read.

FORMATTING SYNTAX EXAMPLE
New line put two spaces at the end of the line you want to break Line__
New paragraph return two times at the end of the paragraph Line↵↵
Horizontal rule between each paragraph put three "-" or "*" ***
Bold put your text between two "**" or "__" **Bold** or __Bold__
Italic put your text between two "*" or "_" *Italic* or _Italic_
~Sub~script put your text between two "~" ~Subscript~
^Super^script put your text between two "^" ^Superscript^
Inline code put your text between two "`" `sudo rm -rf /`
Headings and Titles put one or more "#" at the beginning of the line # Headings for level 1, ## Headings for level 2...
Blockquotes put ">" at the beginning of the line > Blockquote
Links put the the text between [ ] and the link between ( ) [Links]( https://piped.video/watch?v=dQw4w9WgXcQ )
Images Images like links but you put "!" before the first square bracket ![Images]( https://lemmy.ml/pictrs/image/fa6d9660-4f1f-4e90-ac73-b897216db6f3.png?format=webp&thumbnail=96 )

You can also do unordered lists using "-" at the beginning of each line:

- Salt
- Potatoes
- Beans

will become

  • Salt
  • Potatoes
  • Beans

Or ordered list by putting "1." at the beginning of each line:

1. Salt
2. Potatoes
3. Beans

will become

  1. Salt
  2. Potatoes
  3. Beans

You can save other users from spoilers by encasing a paragraph between a section that starts with ":::" followed by a space and the word "spoiler" + the title of the spoiler and ends with ":::". The spoiler will be hidden inside a menu and you'll be able to see it if you click on it

warning! spoiler!
the butler did it

will become

warning! spoiler!the butler did it


In the end you can also format big code blocks by putting "```" at the beginning and at the end of each paragraph

```
println("Hello World!")
```

will become

    println("Hello World!")  

Last but not least remember that you can always use break formatting syntax by putting "\" in front of a character:
so if I want "^" in my text without having the rest of the paragraph in superscript, I'm simply going to write "\^"


Now go and have fun!

414
 
 

In a comment I wrote, I was surprised to see something I didn't write showing up, in the form of a third dot.

So, where did the third dot come from?

Well, markdown-it has an extension where "typographic replacements" are done. You can see them all in action here (tick typographer on and off).

So, wherever two or more dots are written, even if around quotes, three dots will be rendered ('..' => '..')

While it may seem nice, this is more trouble than good IMHO. Not to mention the fact that people using other apps, utilizing other markdown implementations, will not see what others see (which is why some of you probably had no idea what the hell I was talking about at the start of this post).

It is my opinion that use of non-standard markdown extensions should be kept to a minimum, or preferably not used at all. And since a new UI is going to be written (which may open the possibility to use a high-quality markdown Rust crate), this should be a deliberate implementation choice going forward.

415
 
 

Hi all,

I'm having an issue with my Lemmy on K8S that I selfhost. No matter what I do, Pictrs doesn't want to use my Minio instance. I even dumped the env variables inside the pod, and those seem to be like described in the documentation. Any ideas?

kind: ConfigMap
metadata:
  name: pictrs-config
  namespace: lemmy
data:
  PICTRS__STORE__TYPE: object_storage
  PICTRS__STORE__ENDPOINT: http://192.168.1.51:9000
  PICTRS__STORE__USE_PATH_STYLE: "true"
  PICTRS__STORE__BUCKET_NAME: pict-rs
  PICTRS__STORE__REGION: minio
  PICTRS__MEDIA__VIDEO_CODEC: vp9
  PICTRS__MEDIA__GIF__MAX_WIDTH: "256"
  PICTRS__MEDIA__GIF__MAX_HEIGHT: "256"
  PICTRS__MEDIA__GIF__MAX_AREA: "65536"
  PICTRS__MEDIA__GIF__MAX_FRAME_COUNT: "400"
***
apiVersion: v1
kind: Secret
metadata:
  name: pictrs-secret
  namespace: lemmy
type: Opaque
stringData: 
  PICTRS__STORE__ACCESS_KEY: SOMEUSERNAME
  PICTRS__STORE__SECRET_KEY: SOMEKEY
  PICTRS__API_KEY: SOMESECRETAPIKEY
***
apiVersion: apps/v1
kind: Deployment
metadata:
  name: pictrs
  namespace: lemmy
spec:
  selector:
    matchLabels:
      app: pictrs
  template:
    metadata:
      labels:
        app: pictrs
    spec:
      containers:
      - name: pictrs
        image: asonix/pictrs
        envFrom:
        - configMapRef:
            name: pictrs-config
        - secretRef:
            name: pictrs-secret
        volumeMounts:
        - name: root
          mountPath: "/mnt"
      volumes:
        - name: root
          emptyDir: {}
***
apiVersion: v1
kind: Service
metadata:
  name: pictrs-service
  namespace: lemmy
spec:
  selector:
    app: pictrs
  ports:
  - port: 80
    targetPort: 8080
  type: ClusterIP
416
 
 

Is there currently a way on Lemmy-ui to mark a post as "read" so that it no longer shows up in the feed? As the admin of my personal server I know I can remove the post but I'm looking for a solution that doesn't affect others on my instance. I see a setting for hiding read posts but I don't see a way to mark a post as being read.

417
 
 

RIght now lemmy doesn't calculate or display a user's "karma". And many think this a good thing (me included).

Interestingly, kbin does calculate karma, even for us lemmy users (you can all probably just search on kbin.social and find your karma now, +/- federation inconsistencies).

Whenever karma comes up, this fact often comes up, along with the identification of up/down voters, such that many lemmy users will probably know that they actually do have karma and can go look it up if they want to. Some lemmy apps/frontends are also reporting karma AFAIU.

So I think the question now presents itself of whether this is an issue we want users to have some control over, within the bounds of what can done over federation/AP of course.

I can imagine a system where karma is an opt-in setting of one's profile, and a protocol is established that any platform/client that understands up/down votes ought to respect this setting and that non-compliance risks defederation.

Though lemmy/kbin obviously lean more "public internet resource" than microblogging platforms like mastodon, I think it makes sense to value user health and safety here, and this seems like a not unreasonable option to establish a norm around.

Thoughts?

418
 
 

Not sure if that's the right place to ask, but I used to use Boost for Reddit and I was able to follow people (I don't know if this was a Reddit or a Boost feature).

Is it possible to follow users in Lemmy? The only options I see are to either block or msg user.

419
1
submitted 2 years ago* (last edited 2 years ago) by PropaGandalf@lemmy.world to c/lemmy@lemmy.ml
 
 

Hey all,

I am very happy with Lemmy and what the platform has to offer. I also think that it has an important place in the fediverse as it serves a special content niche. For me, this niche is the uncomplicated transfer of information through text together with the quick exchange of information with other users. It is a perfect kind of mixture between a long blog without much commentary and the user-based microblogging platforms.

I think it would be exciting to see how Lemmy could make use of this text in different ways. Typst is a markdown-like LaTeX alternative. It offers real-time compilation, a simple syntax and the formatting strengths of LaTeX. Imagine how cool it would be to be able to format your posts the way you really want including maths formulas, coloured boxes, fancy tables and much more. And you could simply save these configurations as templates and import or even store them directly for later, so you would have a consistent style for each new post.

The whole thing is also open source and written in Rust, which would certainly favour an implementation in the rust-written Lemmy. What do you think?

Mockup:

420
 
 

Hi there, Been running my own little Lemmy instance basically to see how it runs with federation and stuff like that. I have had open (email validation) for the odd person or 2 that might want to use it.

Early this morning (my time 4:43am) I had about 15 new users all at the exact same time registering as users with same structure names (random words) followed by 4 numbers. Being all within 1 minute of each other they are obvious bots.

Going through the UI I have not been able to find a way to remove them. I have since changed my registration policy to make the person fill in an application, captcha, email validation etc. to help stop polluting the ecosystem with bots.

Any help would be appreciated. I am running it all under docker

421
 
 
422
16
custom feeds (jlai.lu)
submitted 2 years ago* (last edited 2 years ago) by chat_mots@jlai.lu to c/lemmy@lemmy.ml
 
 

Hello ! I am a new user and I was wondering, is it possible to have custom feeds with some communities in it ? Like a multireddit.
If I want to have my « technology » feed I’ll put some c/technology coming from differents instances.
I would like to do this to have some feeds without memes. Thanks for the answers !

423
 
 

lol, lmao even

424
 
 

Hi, I enabled 2fa about 2 weeks ago, it seemed to work but now I can't log in, it doesn't say anything, I just see 400 http status in browser's debugger (F12), i have only this Jerboa session logged in and no browser session to disable 2fa

425
 
 

Hello

I am happy on this instance and 2 other federated instances that take good care of the culture by not federating with some other instances.

Yet sometimes I wonder what the "firehose of trash" would be like if I would see really everything and am wondering if there is a "catch all" Instance that is not limiting anything at all?

I would like to take a peek down the abyss for once.

view more: ‹ prev next ›