# Missing user avatars, bulk delete?
**URL:** https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813
**Category:** Support
**Created:** [November 21, 2020, 12:05am UTC](https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813 "2020-11-21T00:05:18Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@MarcP](https://meta.discourse.org/u/MarcP)
#### Post date: [November 21, 2020, 12:05am UTC](https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813/1 "2020-11-21T00:05:18Z")
I used S3 for a while, and switched back to local a while ago. I then saw some logfiles with s3 urls. I can’t remember if I added the uploads to my local folder, but I think a small amount of avatars is affected.
I remapped those from the s3 url to my local url in rails.
Avatars load cached but don’t appear on profiles (some of em, I used s3 for a short while)
There are no issues with posts or they already have been updated manually.
Is there a way to delete all missing avatars or restore these to default? I don’t have access to the s3 bucket anymore; so we are talking about lost/missing avatar files - and maybe some uploads however I have not found a single post with an issue.
---
### Author:  [@IAmGav](https://meta.discourse.org/u/IAmGav)
#### Post date: [November 22, 2020, 9:54am UTC](https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813/2 "2020-11-22T09:54:24Z")
maybe this is what you looking for
> [@Reset all avatars back to default](https://meta.discourse.org/t/reset-all-avatars-back-to-default/64929):
>
> We would like to reset all users back to default avatar (the first letter of their username). I saw this post where @codinghorror mentions to run a query. But can someone please provide the query to reset this? Thanks in advance
---
### Author:  [@MarcP](https://meta.discourse.org/u/MarcP)
#### Post date: [November 22, 2020, 5:11pm UTC](https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813/3 "2020-11-22T17:11:46Z")
Thanks, that was exactly what I was looking for 😃
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [December 22, 2020, 5:12pm UTC](https://meta.discourse.org/t/missing-user-avatars-bulk-delete/170813/4 "2020-12-22T17:12:47Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.