Bulk Resize Images Doesn't Find All Images

Imsanity only finds images that are attached to posts, pages, and custom post types. Others have also complained, but I haven’t seen a solution yet.

can you explain or give me any steps to reproduce this? i try uploading from a page/post or just straight to the library and they are always returned in the bulk image search. here is the query that imsanity runs to look for images. maybe you could see what this is returning?

In particular, look at the file_meta column – it should have some data that looks something like this…

a:5:{s:5:"width";i:1680;s:6:"height";i:1050;s:4:"file";}

This is the data that Imsanity is looking for to determine the size. So perhaps that will give some clue?

select
	wp_posts.ID as ID,
	wp_posts.guid as guid,
	wp_postmeta.meta_value as file_meta
	from wp_posts
	inner join wp_postmeta on wp_posts.ID = wp_postmeta.post_id and wp_postmeta.meta_key = '_wp_attachment_metadata'
	where wp_posts.post_type = 'attachment'
	and wp_posts.post_mime_type like 'image%'
	and wp_posts.post_mime_type != 'image/bmp'

Jason, I just tested version 2.2.4, and it found an image that I uploaded straight to the Media Library. So, it appears to function as desired now. Did this functionality change within the last 2 months?

I’m pretty sure in older versions, if you installed Imsanity after you already had unattached images in the Media Library, then ran the bulk resize, it only returned images that were attached. It didn’t return images that were uploaded prior to Imsanity and were also unattached.

If you uploaded images after installing and configuring Imsanity, then it resized properly.

Others previously reported this too. See this thread and this Google Groups post.

Cool – thanks for the reply.

It would definitely be great for anybody who is having that issue to run the query I posted above and report back. I have had a few people complain about missing images but so far nobody has run the query and gotten back to me about it. So, I’m kinda helpless to do anything since I’ve never once been able to reproduce this issue.

What I suspect is that there may be images in people’s library that for some reason don’t have any size metadata. This could be due to GD not being installed at some earlier point in the history of the blog, or photos being uploaded from an older version of WordPress that has some different format. In these cases Imsanity would just ignore the records. It would be great to get some raw SQL results back showing some images that Imsanity doesn’t find so I can see what the deal is.

Thanks for following up.