Remove Duplicate Images from Wordpress Database - Media Library Settings
HTML-код
- Опубликовано: 11 ноя 2022
- I cannot stress enough how Wordpress will create duplicate images each time you add to your Media Library.
This will bulk our your backend Wordpress Database - and IS NOT GOOD!
Even if you change the Wordpress Media Settings, and add this Code Snippet: websquadron.co.uk/remove-word... - then Duplicates from Previous Images will still exist.
Let's sort it out - and clarify what happens at each step.
See this Page that contains 1 Image in the Database and ensuring that no other size exists in the Database - staging14.websquadron.co.uk/ - view this on a Desktop or a Mobile. BUT Please do test on your own Test site.
WATCH IN FULL and Please SHARE because this hidden issue unless dealt with - can hurt your file-size.
We love to create - share - respond - and deliver.
🧐 Learn with our Mastery Modules: websquadron.co.uk/web-design-...
🔗 All of our Important Links: websquadron.co.uk/socials/
😃 Join our Facebook Group: / 3309523509284305
😃 Get Code Snippets Pro: r.freemius.com/10565/3304295/
😃 Get Elementor Pro: be.elementor.com/visit/?bta=2...
😃 Boost your RUclips Analysis: www.tubebuddy.com/websquadron
👕 Get our Merchandise: websquadron.co.uk/merchandise
🥹 Support us: paypal.me/Websquadron
Hire us to work on your Website!
💌 info@websquadron.co.uk
👩💻 Visit websquadron.co.uk 
Хобби
![Sean Rii, Karyon, Sharzkii - Taungule [My Love] (Official Music Video)](http://i.ytimg.com/vi/eJoMuypbSzQ/mqdefault.jpg)
Excellent, this should be mandatory viewing for everyone starting wih Wordpress, just wish I would have watched this 2 years ago. I just finished deleting ~5000 images! Some of my images had over 30 iterations! Nuts!
I feel lucky to have seen this video while im still building my website. Thank you!
Brilliant. Funny I bumped into this last week. One easy way I found to cleanup the media library is download all images locally from the site (I use Filebird and I think the option comes from that plugin), and that only gets the full images. Then erase everything through file manager and re-upload the images. As I (like you) don't use the year/month/day classification, media path are not changed and everything is fine.
Can you re-iterate that? I'm a little slow:P
Did you manually delete ALL files from media library from within wordpress?
And after this process, did you use and code so duplicates won't be created?
Damn. I think this should be a must watch video for anyone trying to build a wordpress site.
Thanks for this video, lots of great tips! I've now changed my media settings and added the code snippet to the functions.php in my child theme.
I'm also with SiteGround, but couldn't shift select images in the File Manager. Ended up using Filezilla to FTP into the site and delete duplicated images from wp-content > uploads.
This is awesome thank you,good timing too as just started a real image kick for my blog. I would like to see you do a video about code or other stuff remaining from theme changes and how to detect any of that
I've recently tried your zeroing out the images, as you suggest. The problem that I have is that my customers tend to ignore their image file sizes and load very large file sized images. Then they add this image to a page or post and they have no choice but to use these huge images, even if they set it to thumbnail, medium, etc. They think that adding an image and it fills the column (maybe 33%) that the image is now shrunken to fit that space - but that image is still the huge image that they loaded.
I set those media sizes to: 250x0, 450x0, and 1024x0 - this will control the width and and the proper aspect ratio (height). I explain to my customers that they should use the smallest image that just fills the space, a thumbnail may not fill the space but a medium size will. Thanks... I do appreciate all that you do!
That’s a good point that you make
Would you create 1 medium image size for ALL units? (Tablet, mobile and desktop)
With the ratios you do in the settings, doesn't that create duplicates? The 250x0 one's etc.
Yeah!!! Super awesome i was using a plugin for this!!! I will put this function into my Bricks Child Theme.
Yeah Imran thank you!!! Super awesome i was using a plugin for this - thanks for this video with the valuable infos!!! I
With anything - do still take care and make sure that you have a backup just in case
Hi, Imran. I would disagree with some things mentioned in this video.
1. The media cleaner plugin is not something you can trust. It is not that it would be 99% correct. The plugin cannot check the CSS and see which images are used as backgrounds, so you lose all those images.
2. You say copies, but WordPress does not actually create copies of the images. Just different sizes to use when needed. And by disabling this feature you may save some space from your disk, but actually you will use the full size of the images in the pages, and in carousel, post grid and other sections. So you will end up with bigger page sizes and that means bigger loading times.
3. The extra image size that you get when setting the 0 Media > Settings is probably coming from your theme. Other themes may create more sizes. Try a newspaper theme and do the same process. You will end up with a website full of placeholders instead of images.
4. There are plugins that will create different sizes as well, WooCommerce being one of them. And you will end up with more problems when you start deleting images or disabling sizes.
5. There are many themes that are bad at image size handling. Newspaper is one of them. They create over 20 image sizes of each one you upload. There is a solution to identify and only enable the sizes you need, but you will still need some of those. So basically use a better theme.
6. If you end up setting everything to 0 there is a far better way to delete the different image sizes. Use thumbnail image's regenerator. It will delete all the images that are disabled.
Overall, I would not suggest setting everything to 0 and delete all the image sizes. Those images can be used across the website for many reasons.
As always thanks for the video Imnar. Take care
No probs and thanks for the feedback.
A follow-up... A lot of this can be solved by using WEBP. I'm now using EWWW Image Optimizer which does a great job of converting to WEBP. And a bonus, it does image sharpening(!). I'm now using sizes: 360, 550, 1120, 1920, and full. Using WEBP, most of these have file sizes at around 50k. These are the sizes that work best with the default 1140px width. And, a final quick comment, if you use the Elementor Hello theme, that has an option set: $content_width = 800. That setting will max out, to 800px wide, any media setting above the 800. If you set Large to 1020, it will only display 800. Took me two days to figure that out... painful!
Thanks
What about retina screens?
Imran, if I could give this video a 2xthumbs up I'd do that. This was a great time saver / website database size save for me.
Always be careful when deleting images :)
Two things... Firstly, sometimes having small versions of images is a good thing if you have a blog. You might want the large image to appear as the featured image on post, while a smaller version appears on the archive page. Secondly, you kept saying database but it's really the uploads folder. The first two images that you uploaded and then deleted from the uploads folder are still actually in the database as paths to the images within the uploads folder. Just to clarify. I'm definitely going to be using this technique but will need to think about smaller images for blogs. Thanks!!!
It’s one of those weird techniques where there are pros and cons for using it. It’s a pity that WP have removed some control or not made it explicitly clear to users about the amount of images that get loaded into the uploads folder. Be careful when applying anything you’ve seen here.
Agree - deleting images from Upload without taking away the path from database is a recipe for future issue.
thanks a lot
I was able to solve the problem. I hadn't noticed that there was a setting in the settings to show the code or not. I just set it to "Hide" and everything was fine with that... Thank you very much for your prompt reply.
Where did it 'hide'?
Thanks for the tips! I zero'd the media settings and created the snippet you provided but I'm still getting a couple of "extra" sizes. Another commenter here, @pana, posted snippet that worked perfectly. I uploaded 1 image and that's all that was created in by dB.
Super-practical vid! Thanks. Two questions, though: Don’t the different file sizes exist for a reason? … often created by image optimizer, to use a smaller version in an archive grid, compared to the image on a single post. Second question: is there any reliable way (plug-in?) to determine which images are actually used on the site?
I have been dismayed by some plugins that age meant to find when an image is in use or not. As some may think that an image is not in use even though it’s used as a container background image.
Agreed that you have to weigh up why an image is a certain size especially for WooCommerce
Hi Imran, thank you for the never ending knowledge. Are you using this method for every website you build? Or are there instances where this wouldn't be advised? Thanks
When you know the site will be really heavy with images then cleaning up duplicated images can help you reduce the database size.
@@websquadron Sounds great. Cheers!
Thank you for your tutorials.... Does this effect the size needed for a container or featured image, or would I now have to upload the exact size needed?
No but some people don’t like to remove them in case there is an issue.
A simpler option would be to add the snippet code below, there is no need to set all the variants of the media settings to zero.
add_filter('intermediate_image_sizes_advanced','stop_thumbs');
function stop_thumbs($sizes){
return array();
}
Thanks my friend, with yours code working! Any solution how to delete the old Duplicate Images from database? It's thousand.
Pana so shall I just copy this into the snippet? is that all that is necesssary for your method? Or can you copy and paste the code you use into this comment so we can do use the same... Nice one!
Thanks. This worked for me but the code provided in the video did not.
The code in the video works for many, but alas, not for me. Your code snippet does, @pana_____ . Thanks a bunch to both of you 🙏
Ooooh thanks a loooot
Is there a way of getting just 1 image on upload without any code? Why does WordPress create 2 images when the image settings are ticked off?
Where does the code go to? And will it be erased after updates?
Hey Imran, we can delete all extra images sizes files via cPanel BUT in the sql database the path images records are still there right? Any snippet to delete from database too? Great work!!!
Always be careful when deleting images :)
Yes you are correct. Paths to images are still within the database taking up space in there, especially if the image isn't used anymore.
@@BrockBarr Does the paths take up space/clutter directions? How to delete the paths?
I have found too that if I use the media library list view it often tells me am image is not used yet I know it is,is there a better way of telling where an image is used without using a plugin,I try to keep plugins down to bare nessicities
It’s a tricky one and no process is foolproof and some plugins will still get it wrong as to if an image is in use or not.
See this Page that contains 1 Image in the Database and ensuring that no other size exists in the Database - staging14.websquadron.co.uk/ - view this on a Desktop or a Mobile. BUT Please do test on your own Test site.
Thanks great video, i imported 28,000 products with 90,000 images, had to rework the website and now ended up with 1,4 million images, will delete all sub sized images and then check for duplicates by moving all images to same folder see if it helps to overwrite the main images be removed that way.
Oh man - that is a lot! Yup the duplicate images are a pain.
but what do we do for the image widget responsive modes?
elementor doesn't let you have different images for mobile in the image widget.
only possible way to use a smaller image for mobile is the scaled images from the media settings
Trust me I don’t get no issue when I remove them but it is subjective so only remove if you are sure
what a useful video ... thank you for this video.. I'm using ligtspeed webserver I should learn how to do it.. it's another question for me 😂😂
Sorry, so what if the 100x100 or whatever value/size images are being used on the front end? They won't get automatically replaced by the original, would they?
The original would be used so best to be careful with what is or isn’t used
Hi Imran. Is that smart to do? There was a reason for WP to create 3 variations: for the 3 device sizes. Is it smart to load the full image on a smart phone? I'm just about to redesign a website with a heck of lot images, so I have to decide wether to follow or not your advice. Thanks bro.
I'll be putting out a URL shortly that only uses the one size to show it's fine
See this Page that contains 1 Image in the Database and ensuring that no other size exists in the Database - staging14.websquadron.co.uk/ - view this on a Desktop or a Mobile. BUT Please do test on your own Test site.
What about the thumbmails i'm missing for my blog?
The category page where it shows small images for example: In this case it will takes the feature image? (which is big)?
Search results, archive, etc.
What would you recommend in this case?
Should I allow at least one duplication in a size similiar to what I need?
Yes, you do need to assess and check - however on testing, I could remove the 100 and 300 images and my blog posts were still fine - but do check
@@websquadron so if 100 and 300 were disabled, what images were shown on your blog?
@@thegate12345 See this: staging8.websquadron.co.uk/simple-presto/
The Black Friday Image is 1000 x 1000 and all other 100, 300, 768 size images are deleted from my SiteGround File Manager.
It still comes through on the post.
But - it is advised that you test this yourself with a Dummy post and an Image.
what is the best way to remove unused image with or without plugin? not duplicate one. My client has around 12000+ images where around 2-3k images are using in live website. how to delete the rest of the images
That will take a while to weed out unused images
I have added the code using code snippet plugin and done all the settings as you have shown in the video. Afterwards, I added an image to the media library. I can see total 8 versions of the image inside my file manager. Please help.
I can only help as part of a 1-2-1 consultation
Somehow after I did all the settings, when I check in cPanel file manager, it still creates 2 (sometimes 3) more copies of the initial image I upload (webP). Can you help?
Wordpress can still create more and that's a pain
Hi,
Can you explain how to create a custom filtering options on the media library, using code snippet. I could see the name of the post to which my media is attached to, but not able to filter all media attached to a specific post or page. Can you help me with that.
That’s not fully doable as it can cause issues with the backend Wordpress in how it searches
@@websquadron my requirement was to remove files that are uploaded by user on a periodical basis. All these files are getting dumped into my wp media. If I could filter based the page /post through the users uploaded the media, I could select them all and remove them after downloading.
If a permanent filter is not possible a temporary filter also works. Whenever I want to perform this filtration I can activate the snippet and deactivate after my job is done.
Otherwise the filter parameter can be added to the url after '?' for the query result.
I've seen people asking on the WordPress community to filter media based on the author. But I couldn't find anything that I really wanted. Hope you can help.
Hi Web Squadron. Is there a File Manager option in cPanel? Thanks!!
Should be there.
Log in to your cPanel account.
Scroll to the Files section and click on File Manager.
This will open the File Manager where you will be shown a hierarchical list of your main folders
I have a 19GB photography site where the previous theme I used created 8 different versions of thumbnails. Is there I quite script I could run to just delete all of the sizes it generated? It's tens of thousands of images and the manual option would take days.
I’ll be sharing some code shortly
@@websquadron that's amazing! will it be a youtube video?
is there a way to stay only with specific size (large 1920) but without the full size resolution, when i say full size resolution i mean if i upload 3mb image, i want to auto remove the 3MB file and stay only with large size... possible?
Only if done manually
@@websquadron it's a big real estate website that people are login and can submit their properties.. there must be a automatic solution to remove the full size after upload and after imagify finish optimize..
Will WPMUDEV Smush or even setting the display size inside elementor still work?
Display setting size inside Ekementor does still work, but I don't use SMUSH so that would need to be tested out.
Doing this you will load "big images" also for archive pages or there is some workaround?
This is where you have to decide on what else you're using the images for, so if they are to be used for Woo Thumbnails or Archives then keep the relevant size.
Why it does not work with my website and even dupplicate more copies, please help!
Who is your host, have you asked them? And are you definitely deleting?
I tried the snippet but it's still generating all the sizes annoyingly. Any idea what it could be? I host my sites on Hostinger
Try and set everything to 0 zero in the image settings as he showed. Did you work this out?
@@audunjemtland8287 I did do all of that, while it doesn't show the different sizes inside wordpress, they are still being generated in my website files
I guess you also recommend using the Full size of images for example Elementor's Posts widget, Woocommerce grids etc? (Goes without saying the images need to be optimized before uploading) :) edit: Sometimes pagespeed analyzers complain about image sizes with such widgets though, but just ignore them? :D
I add them in, and then resize accordingly inside the Media Library. For instance, I always size Woo images to be 500px x 500px, and others can be variable as I may decide on the exact size when building on the page.
See this Page that contains 1 Image in the Database and ensuring that no other size exists in the Database - staging14.websquadron.co.uk/ - view this on a Desktop or a Mobile. BUT Please do test on your own Test site.
Once cleaning up the images, how does this effect page load and gtmetrix and Gpage speed?
This is more for your backend database size
@@websquadron so, on the front end, it will not effect anything?
No
@@websquadron I just cleaned up about 500 megs on my photography website. On my gallery page I just had to go back in and save the page because some of the images wouldn't showing right. Thanks for the tutorial Hope to see more soon.
I think if you add the snippet and install the plugin regenarate thumbnails it will remove the other generated images
I'll have to try that.
Hello, I think it is working but why is the code shown on my website-heading? I have a screenshot...
That is very strange. Are you adding it to Code Snippets?
Good morning...
I did everything the same as your video, but the images are multiplying on the server.
Have you disabled the Media Image Sizes in Wordpress Settings > Media?
@@websquadron yes
Hi, I've tried this custom php code but wordpress still generates images as 1536x987 and 2048x1317. Why could be it?
Any plugins or optimisation image tools loaded?
@@websquadron I use Elementor and Wp Rocket
The amount and sixes of images added also depends on your theme and your plugins like woocommerce and your beloved :) slider Depicter
Yup. I always size Woo images as 500px x 500px.
DEAREST IMRAN, now I am upload woocommerce at 1000 by 1000 usually sometimes less or sometimes more... I see in the code you have not included the size small, is that because you upload small 500px by 500px or is that all irelevant my friend? And shall I just go ahead and copy the code and your method? for my 1000by1000px.... You the expert, do advise, you the man Imran
Test it out as it depends on the site, but I would suggest leaving the 500 x 500 in.
Hi can you make a tutorial for images randomly dissapearing in wordpress ?
Is this after you have cleaned up or run some optimisation?
i dont know but i cleaned my cache any everything but it still dissapears even if i reupload them @@websquadron
im using ghl + wordpress@@websquadron
i still get 3 sized images when i upload one :( 100x, 300x and 600x). :(
Even after you add the Code Snippet and Change your Settings? Also make sure that you rename the image before uploading it, just in case.
@@websquadron yes all done but still, the moment i upload new fresh image, i always have my original one and the other 3 versions. Maybe it's because of some settings in the other plugins idk but hard to find the culprit. I don't have so much plugins on my site, will figure it out!
@@danjepi82 have you cleared the server and site cache? just a thought
@@visualmediafx thanks and yes yes of course
Hi Imran .. Are you Okay man ? what happened to your hand I'm worried bro why you use these ?
Hi - I was wearing gloves for warmth:)
@@websquadron ohhh.. Okay ! We have warm rainy weather here in Madinah, Saudi Arabia
Ah, just what we need. People screwing up their responsive images by zeroing out their thumbnails.. :/
These do have a purpose.
Yup
I thought the thumbnail was created for the media library?
Funnily enough - not always - unless it's a WooCommerce Image. I've removed all 100x100 sizes and my images still show.
@@websquadron Interesting, but what about media library loading times without these small thumbnail images?
@@angelaschmidtdesign932 I don't have that issue, except with WooCommerce in the library where removing 300x300 can affect the library. But not with my normal images.