Commit 65e4a7a
Eric Bower
·
2026-01-02 12:38:06 -0500 EST
parent 0fc145b
fix(prose): filter aliases by user_id This was erroneously showing posts from other users
1 files changed,
+6,
-1
+6,
-1
| ... | ... | @@ -391,7 +391,12 @@ func (me *PsqlDB) FindPostWithSlug(slug string, user_id string, space string) (* | |
| 391 | 391 | post, err := CreatePostWithTagsByRow(r) | |
| 392 | 392 | if err != nil { | |
| 393 | 393 | // attempt to find post inside post_aliases | |
| 394 | - | alias := me.Db.QueryRow(`SELECT post_id FROM post_aliases WHERE slug = $1`, slug) | |
| 394 | + | alias := me.Db.QueryRow( | |
| 395 | + | `SELECT post_aliases.post_id FROM post_aliases | |
| 396 | + | INNER JOIN posts ON posts.id = post_aliases.post_id | |
| 397 | + | WHERE post_aliases.slug = $1 AND posts.user_id = $2`, | |
| 398 | + | slug, user_id, | |
| 399 | + | ) | |
| 395 | 400 | postID := "" | |
| 396 | 401 | err := alias.Scan(&postID) | |
| 397 | 402 | if err != nil { |