# Como listar todas as postagens com uploads retornando 404

**URL:** https://meta.discourse.org/t/how-to-list-all-post-with-uploads-giving-404-response/190374
**Category:** Support
**Created:** [14 Maio , 2021 05:54 UTC](https://meta.discourse.org/t/how-to-list-all-post-with-uploads-giving-404-response/190374 "2021-05-14T05:54:51Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![hosna](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hosna/32/99969_2.png) [@hosna](https://meta.discourse.org/u/hosna)
#### Post date: [14 Maio , 2021 05:54 UTC](https://meta.discourse.org/t/how-to-list-all-post-with-uploads-giving-404-response/190374/1 "2021-05-14T05:54:51Z")

</div>

Existe uma maneira de listar todas as postagens que possuem um upload que retorna uma resposta 404?

Tenho alguns vídeos servidos assim:

```plaintext
    <video preload="metadata" controls="" dir="ltr" width="100%" height="100%">
      <source src="/404" data-orig-src="upload://hnRUlglnYmKLcykGjadxGrjx2XH.mp4">
      <a href="/404" dir="ltr">/404</a>
    </video>

```

Embora eu tenha rastreado o arquivo carregado e descoberto que o arquivo realmente está na pasta de uploads, no entanto, na minha postagem, ele retorna o erro 404 não encontrado.

Para descobrir o problema, primeiro preciso saber quais postagens são afetadas.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [14 Maio , 2021 10:15 UTC](https://meta.discourse.org/t/how-to-list-all-post-with-uploads-giving-404-response/190374/2 "2021-05-14T10:15:13Z")

</div>

Isso pode resolver no console do Rails..

```plaintext
posts = Post.where("cooked like 'src=\"/404'")

```